defaultAutoCommit and JDBC Connection Pool
I am using Glassfish 2.1 with ESB.
When I do my development on my laptop, I find that I cannot use Glassfish JDBC Connection Pools, as for some reason a full Glassfish restart is required every time I redeploy a WAR that uses the pools.
So when working locally I don't use Glassfish connection pooling, but instead use Spring connection pooling.
Spring works nicely with the property defaultAutoCommit=false.
I can then invoke stored procedures, which are written such that they only do a final COMMIT if everything works.
My problem is that when I deploy to the target Solaris Glassfish environment, and I switch to using the Glassfish connection pooling, the stored procedures that I call ALWAYS get committed.
This is the data source bean:
This is the bit from my domain.xml that defines the connection pool:
Can anybody help me? What am I doing incorrectly?
Thank you very much!