You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Brian Abbott <br...@dommoni.com> on 2004/08/31 09:21:07 UTC

PreparedStatement.addBatch/executeBatch issues

Has anyone had any problems executing addBatch(void) and executeBatch(void) in Derby?

I have a loop that inserts integers into a two column table. At the bottom of the iteration is a call to addBatch() once the loop finishes, I call executeBatch(). However I'm missing a great deal of data. I'm creating the connection with autoCommit set to false and calling Connection.commit() later in the sequence. Any ideas?

Brian

Re: PreparedStatement.addBatch/executeBatch issues

Posted by Mamtap <ma...@Remulak.Net>.

Hi Brian,

Can you provide some specific code for the problem? I am not aware of
any existing bug in the Batch functionality.

Mamta

Brian Abbott wrote:

> Has anyone had any problems executing addBatch(void) and
> executeBatch(void) in Derby? I have a loop that inserts integers into
> a two column table. At the bottom of the iteration is a call to
> addBatch() once the loop finishes, I call executeBatch(). However I'm
> missing a great deal of data. I'm creating the connection with
> autoCommit set to false and calling Connection.commit() later in the
> sequence. Any ideas? Brian