Re: How to get batch commands to work - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: How to get batch commands to work
Date
Msg-id Pine.BSO.4.63.0602271713090.283@leary.csoft.net
Whole thread Raw
In response to How to get batch commands to work  (Björn Bergenheim <bjornJmagic@kenetworks.se>)
List pgsql-jdbc

On Mon, 27 Feb 2006, Bj�rn Bergenheim wrote:

> Hello all, I have tried to check out the archive since this seems like a
> question I shouldnt be the first to ask, but I have come up with
> nothing. I'm doing a massive insert batch, and thought that you could
> add a few insert to a batch, and then execute the batch, and then
> continue adding more inserts, and then run the batch, and so on.
> However, when I try to do this, I get an exception when I try to
> populate my prepared statement after I have run the executeBatch() for
> the first time. The eception I get is "Parameter index out of range":
>

This should work fine as the attached test does for me.  Can you show us a
complete example of something that fails?

Kris Jurka
Attachment

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: postgres PreparedStatement commented ? problem PSQLException:
Next
From: "Jonathan Vallar"
Date:
Subject: Bad Value for Data Type Timestamp