Re: executeBatch() issue with new driver?

Without looking at the code, I noticed that the javadoc's refer to
addBatch as adding a single command, see below.

Adds the given SQL command to the current list of commmands for this
|Statement| object. The commands in this list can be executed as a batch
by calling the method |executeBatch|.

Dave
Alan Stange wrote:

> Hello all,
>
> I'm using pg8 beta 3, with the pgdev.307.jdbc3.jar JDBC driver.
>
>
> If I run the following example code:
>
> Connection conn = ...;
> Statement st = conn.createStatement();
> String sql = "create temp table t (a int4); insert into t (a) values
> (1);";
> st.addBatch(sql);
> st.executeBatch();
>
> I get the following error:
>
> Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 1
>    at
> org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2317)
>
>    at
> org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleCommandStatus(AbstractJdbc2Statement.java:2293)
>
>    at
> org.postgresql.core.v3.QueryExecutorImpl.interpretCommandStatus(QueryExecutorImpl.java:1230)
>
>    at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:968)
>
>    at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)
>
>    at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2371)
>
>    at com.rentec.fi.db.DbStatement.executeBatch(DbStatement.java:88)
>
>
> Am I missing something here?
>
> Thanks!
>
> -- Alan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>

--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561