Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC behaviour - Mailing list pgsql-jdbc

From Andreas Joseph Krogh
Subject Re: JDBC behaviour
Date
Msg-id VisenaEmail.10b.13d77f0d98d4ad81.152f409b3ee@tc7-visena
Whole thread Raw
In response to Re: JDBC behaviour  (Andreas Joseph Krogh <andreas@visena.com>)
Responses Re: JDBC behaviour
List pgsql-jdbc
Tree view
På torsdag 18. februar 2016 kl. 11:59:50, skrev Andreas Joseph Krogh <andreas@visena.com>:
På torsdag 18. februar 2016 kl. 11:43:36, skrev Sridhar N Bamandlapally <sridhar.bn1@gmail.com>:
The code/framework is written to handle batch inserts, which is common for all databases
 
I feel, PostgreSQL JDBC may need to modify setAutoCommit(false) code to "implicit savepoint - on error - rollback to savepoint"
 
You simply cannot have batch-inserts in the same transaction and expecting the batch not to fail if one of the statements in the batch fails.
 
Note that it's perfectly doable to have a connection-pool configured with autocommit=false and do the transaction-management your self. Then you can do whatever you want when one statement fails. You would want to rollback that statement...
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-jdbc by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: JDBC behaviour
Next
From: Sridhar N Bamandlapally
Date:
Subject: Re: JDBC behaviour