Thanks a lot for the reply!


The applications uses the jdbc driver with autocommit turned off,
commit and rollback. Do you know if the jdbc driver just starts a new transaction as soon as the last one was ended with commit/
rollback ?


Yes, it does.
You have to explictly setAutocommit(true) instead of commit() (or, you can commit(), and *then* setAutocommit(true) if you want, the result is the same).


I hope, it helps....

Dima



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to