Andreas, ROLLBACK doesn't work as it do for all previous statements,
autocommit ON is not option as it controlled by connection pool,
with this the simple "statement" with need to replace with "try-catch", "savepoint", "statement" and "rollback to savepoint", this looks lot of changes in code to make it app/java-database compatible,
still, this is bug
ROLLBACK is not a per-statement command, but a per-transaction.
I think you have to re-read the answers given in this thread.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963