non-transactional JDBC connections

[wesgere]

Some SQL statements in my app need to be executed in autocommit mode. However, I would still like to take advantage of JBoss connection pooling for these connections.

Another way of stating this is: I would like to have a Data Source where the connections do not participate in (are not registered with) the current transaction.

Is there any way to do this? Is there some configuration of properties for a Data Source in jboss.jcml that does this? Or, can I just call connection.setAutocommit(true)?

Also, please state what version (2.4.4 or 3.0) will support the solution.

Thanks in advance,
-wes

[davidjencks]

I think for 2.4 there's something like a JDBCDataSourceLoader that is non-transactional, and for 3 you can use a ConnectionFactoryLoader with the NoTransactionConnectionManagerFactoryLoader. I think in 3 you also have to set a ManagedConnectionFactory property AutoCommit=true.