Ok, let me put this way in JDBC we have *setAutoCommit( false ) *, and all dmls are independent transactions
and when any transaction fails then the session not allowing next transactions in Java when we do setAutoCommit( false ) its behaving like all transactions in BEGIN-END block, this is not expected behavior i guess this is bug On Thu, Feb 18, 2016 at 2:00 PM, Vladimir Sitnikov < sitnikov.vladi...@gmail.com> wrote: > > but in this case all these transactions are independent with autocommit > off, > > At database level, there is no "autocommit=off". > There's just "begin-end". > > It is database who forbids .commit, not the JDBC driver. > Vladimir >