Java Batching & Blobs

From: Vinnie <vincent.salerno_at_lmco.com>
Date: 8 Aug 2003 05:24:31 -0700
Message-ID: <c6c61dbf.0308080424.26ba0ab7@posting.google.com>

I have this situation:
We are inserting many rows at a given time. Part of the data is a blob.
We are using prepared statements & are thinking about batching the inserts.
The problem is the PK is a sequence. Therefor we must go to the dB each time
to grab the nextval so we can then do the BLOB update. Can anyone think of anyway to eliminate that extra call to the dB to grab the .nextval or is the performance hit small?

Thanks Received on Fri Aug 08 2003 - 07:24:31 CDT