users@glassfish.java.net

Re: Does the jdbc pool manager support setting the defaultAutoCommit?

From: <glassfish_at_javadesktop.org>
Date: Thu, 26 Jul 2007 10:19:08 PDT

Are you using a non-transactional datasource? (I see 'associate-with-thread="false"' in the pool definition). If you are, the autoCommit is not reset for those connections (vs. the regular pool where it is). The expectation is (was?) that a non-transactional connection will be used for non-transactional queries only and the caller will handle any other settings by themselves.

Regards,
-marina
[Message sent by forum member 'mvatkina' (mvatkina)]

http://forums.java.net/jive/thread.jspa?messageID=228411