Note, we found and fixed an issue that involved the cache sync operation not re-using the SQLConnection from the current transaction when you disable autocommit. This will fix your issue (as we understand it) but we still have an open question on what exactly you're trying to achieve.
-
-
Sorry for the delay. I was on vacation. Thank's for your help.
I used the “setAutoCommit” API just as temporary fix for the synchronisation issue. With your fix I can remove this lines.
The stored procedure has to use the same db session, not necessary the same transaction.
My database transaction boundaries are quiet simple. Do all database stuff in one transaction and at the end of the HTTP request execute a commit. Occurs an error do a rollback.Comment
Comment