update Blobs in Batch jobs

What makes you think that JDBC, and not the specific driver that you are using, precludes this?

I would also be rather curious as to what the purpose is as well. A real batch job (ftp a file and then use the server tools to load it) is likely to be significantly, probably an order of magnitude, faster, so absolute speed isn't the reason.

I would also be surprised if the overhead of moving real blobs could even provide a significant improvement in relative speed.

And if transaction control is the issue, then use temporary table storage and then do an on box move to final storage. (Although batch jobs usually require breakups due to size anyways.)

So why does it matter if it doesn't work via batches?

jschella at 2007-7-13 19:08:33 >