If i get a java.sql.Connection from a datasource that is part of a transaction managed pool (org.jboss.resource.connectionmanager.LocalTxConnectionManager) the Connection implementation complains if i try and call rollback while i'm in a managed transaction. Fair enough, but how does the pool know to call rollback (rather than commit) when the connection is returned to the pool?? Surely I have to have some way of telling the pool what action i want taken when the Connection is returned. Or can i not rollback on a Connection from a transaction managed pool?
Please read up on jta and how j2ee manages transactions and finally the setRollbackOnly method.