When should I use a TxDataSource instead of a DataSource?
"When to Enable Global Transactions in a Data Source" in the Administration Console Online Help. When you select Honor Global Transactions in the Administration Console, you create a JDBCTxDataSource in the config.xml file (the default). If you clear the Honor Global Transactions check box, you create a JDBCDataSource in the config.xml file.