Re: Efficient Insert statement for one record into multiple

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