Re: Efficient Insert statement for one record into multiple - Mailing list pgsql-jdbc

From Peter Neu
Subject Re: Efficient Insert statement for one record into multiple
Date
Msg-id 00f201c72357$0ba220d0$bcc8a8c0@PCMELZER
Whole thread Raw
In response to Re: Efficient Insert statement for one record into multiple  (Roland Walter <roland.walter.rwa@gmx.net>)
Responses Re: Efficient Insert statement for one record into multiple  (Markus Schaber <schabi@logix-tt.com>)
Re: Efficient Insert statement for one record into multiple  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Hello,

the insertion within the same connection objects works just fine. ;o)
One thing which still keeps me thinking is how should I handle duplicate
key exceptions when it happens in the first insert? Should I just close
the connection object in the catch clause when this happens in the first
statement so the second statement hits an AlreadyClosedConnectionException?

Cheers,
Pete



pgsql-jdbc by date:

Previous
From: "Edoardo Ceccarelli"
Date:
Subject: Re: [ADMIN] pg_clog
Next
From: Markus Schaber
Date:
Subject: Re: Efficient Insert statement for one record into multiple