Hi Hans,

The usual way of managing autocommit is to check if your jdbc
connection supports transactions
"conn.getMetaData().supportsTransactions()" and then if so, turn of
autocommit "conn.setAutoCommit(false)" This is what you normally see in
many java projects, whatever the jdbc-dbms server are they using (or
expecting).

As you see it must be done whenever you get a connection. I do not know
if any dbms vendor or driver allows to done it globally outside the
code. If so, I do not recommend that way to you as your code will not
be portable or applied to other dbms as is (a very important feature)

HTH

Carlos

Hans Weisenberger ha escrito: