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.