setAutoCommit(false), it should not be treating all next transactions as single set, simple, this is what expected behavior
The point is that all subsequent statements (after an exception) are part of the same transaction (in autocommit=false mode). So you have to issue an explicit ROLLBACK before any new statement can give meaningful results.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963