Re: Efficient Insert statement for one record into multiple

[Markus Schaber <schabi(at)logix-tt(dot)com>]

Hi, Peter,

"Peter Neu" <peter(dot)neu(at)gmx(dot)net> wrote:

> 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?

Why execute the second statement at all?

Maybe you should rework the control flow of your application.

Regards,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org