how to not wrap a query inside a transaction for xa-datasource

[kchen007]

we had xa-datasource and some of our client will only run query with it. if they set the auto-commit to false and did not call commit with their select statement, the connection will never return back to pool. is there any way to exclude queries from transaction?

thanks

Kevin

[rareddy]

May be you should explain why you are trying to set auto-commit to false?

You can set "autoCommitTxn=OFF" on Teiid JDBC URL, then no transactions will be invoked.

Ramesh..