Tim Funk wrote:
On connection.close() - the pool should ensure that autocommit is
reset correctly. Example test case:
// assume autocommit for JDBC verndor is true
that's an interesting assumption, while it probably stands with most
drivers.
there is a 'defaultAutoCommit' property you can use.
Connection con = datasource.getConnection();
System.out.println("con.autoconnect=" + con.getAutoCommit()\n";
// above line should say true
con.setAutoCommit(false);
con.close();
con = datasource.getConnection();
System.out.println("con.autoconnect=" + con.getAutoCommit()\n";
// above line will return false instead of true
con.close();
I will put this into the ConnectionState interceptor, to manage all the
state.
Filip
-Tim
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]