Hi
I am trying to commit transaction (if auto commit is off) before closing connection and I wonder if it is possible using addConnectionEventListener (close event) from java code ..
This is because application does not commit before closing connection (bug and we do not want to fix at this time) as previous version (JBoss 5/db2 driver old version) commits before closing connection.
any idea ?
ctx = new javax.naming.InitialContext();
datasource = (DataSource) ctx.lookup(connectionPoolName);