Subject Re: [Firebird-Java] Re: Blobs and batches
Author Serge Bogatyrev
On Mon, Aug 31, 2009 at 12:11 PM, Roman Rokytskyy<roman@...> wrote:
>> You better post your problem in firebird-support group. There you will get
>> much faster response.
> I doubt - they will point you here, since this is JDBC driver issue.
> The issue with batching BLOBs looks new to me, and most likely, is
> related to auto-commit mode.

Did you miss "setAutoCommit(false)"?

> Anyway, in case of Firebird you do not win anything with batching the
> calls, since the API does not have batch calls. Driver simply simulates
> the batch calls by executing them one by one.

So, it is just "simulation" problem.

It looks like the driver starts the blob writing after setting
parameter value. And I think this is a problem. For example, we have
no transaction at this moment.

Serge Bogatyrev.