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.setAut
I believe that the connections are 'in transaction' because the commit
call commits one transaction and begins the next. There is no
beginTransaction call, so that's pretty much the way it has to work, I
believe.
-danch
Alexey Yudichev wrote:
My application does not use direct jdbc calls and
With a non xa jdbc driver, jboss calls connection.commit() (or rollback())
to end a transaction. What is the approved Postgres way to end a
transaction properly?
david jencks
On 2003.03.14 05:06 Alexey Yudichev wrote:
> My application does not use direct jdbc calls and all EJBs are CMT
> CMP2
My application does not use direct jdbc calls and all EJBs are CMT CMP20 beans. I
use PostgreSQL. I see that all unused connections in jboss pool are marked by postgres
as "idle in transaction". It means jboss does not end the JDBC transaction properly
(although all changes are saved correctly