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,
On 2/18/2016 1:42 AM, Sridhar N Bamandlapally wrote:
but why?, this is not expected behavior
autocommit is just autocommit, its not responsible to treat multi-transactions as single or independent
its exactly how jdbc is defined to work, fit into postgres's transaction model.
if autocommit is ON, then every statement is a standalone query.
if autocommit is OFF, then its in transaction mode. JDBC has an implicit transaction start when you execute the first query, and you have to commit or rollback the transaction.
if you want each INSERT to run indepedently, then use autocommit ON.