> I found the following code does not work as expected:

> stat.executeUpdate("drop table if exists t;");
> stat.executeUpdate("create table t (c text);");
> prep = conn.prepareStatement("insert into t values (?);");
> prep.setString(1, "a");
> prep.addBatch();
> System.out.println("call 1: " + prep.executeBatch().length);
> prep.setString(1, "b");
> prep.addBatch();
> System.out.println("call 2: " + prep.executeBatch().length);

> rs = stat.executeQuery("select * from t;");

> while (rs.next())
>     System.out.println(rs.getString(1));

> Output:
> call 1: 1
> call 2: 2
> a
> a
> b

> The expected result (and what I get with MySQL driver) would be:
> call 1: 1
> call 2: 1
> a
> b

> That is, the call to executeBatch() should delete the commands in the
> batch and not execute them again on the next call.

> Regards,
>   Thomas.

> I am not sure which behavior is truely expected in the JDBC
> specification:http://java.sun.com/j2se/1.3/docs/guide/jdbc/spec2/jdbc2.1.frame6.htm...

> However, it seems that each call of executeBatch() method do the
> updates
> to the database, so the first result makes sense to me in that
> it correctly returns the number of SQL queries executed.

> <thenl...@gmail.com> wrote:
> > Hi,

> > I found the following code does not work as expected:

> > stat.executeUpdate("drop table if exists t;");
> > stat.executeUpdate("create table t (c text);");
> > prep = conn.prepareStatement("insert into t values (?);");
> > prep.setString(1, "a");
> > prep.addBatch();
> > System.out.println("call 1: " + prep.executeBatch().length);
> > prep.setString(1, "b");
> > prep.addBatch();
> > System.out.println("call 2: " + prep.executeBatch().length);

> > rs = stat.executeQuery("select * from t;");

> > while (rs.next())
> >     System.out.println(rs.getString(1));

> > Output:
> > call 1: 1
> > call 2: 2
> > a
> > a
> > b

> > The expected result (and what I get with MySQL driver) would be:
> > call 1: 1
> > call 2: 1
> > a
> > b

> > That is, the call to executeBatch() should delete the commands in the
> > batch and not execute them again on the next call.

> > Regards,
> >   Thomas.

> I found the following code does not work as expected:

> stat.executeUpdate("drop table if exists t;");
> stat.executeUpdate("create table t (c text);");
> prep = conn.prepareStatement("insert into t values (?);");
> prep.setString(1, "a");
> prep.addBatch();
> System.out.println("call 1: " + prep.executeBatch().length);
> prep.setString(1, "b");
> prep.addBatch();
> System.out.println("call 2: " + prep.executeBatch().length);

> rs = stat.executeQuery("select * from t;");

> while (rs.next())
>     System.out.println(rs.getString(1));

> Output:
> call 1: 1
> call 2: 2
> a
> a
> b

> The expected result (and what I get with MySQL driver) would be:
> call 1: 1
> call 2: 1
> a
> b

> That is, the call to executeBatch() should delete the commands in the
> batch and not execute them again on the next call.

> Regards,
>   Thomas.