Which version of the PostgreSQL,JDBC do you use??
I think the driver back in 7.2.* always
issued a "BEGIN;" on new connections,
and then issued a "ROLLBACK;" ( or "COMMIT;")
in case of a connection.setAutoCommit(true).
Also the driver always issued a "ROLLBACK;BEGIN;"
in case of connection.setAutoCommit(false).
Thats why you see these "idle in transaction" ps output.
Its fixed in 7.3.2.
--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: [EMAIL PROTECTED]
[EMAIL PROTECTED]
-------------------------------------------------------
This SF.net email is sponsored by:Crypto Challenge is now open!
Get cracking and register here for some mind boggling fun and
the chance of winning an Apple iPod:
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
