Subject Re: [Firebird-Java] Re: Blobs and batches
Author Roman Rokytskyy
>>> 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)"?

Yup :) I have seen the first one, but not the second one.

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

Hmmm... can be an issue. I will check sources and report here.

Roman