Jdbc2Odbc, Prepared Stmts and Batches... just don't work together.

Hi.

this throws a NegativeArraySizeException on executeBatch:

con.setAutoCommit(false);

PreparedStatement p=con.prepareStatement("insert test_date(txt) values(?)");

p.setString(1, "das");

p.addBatch();

p.setString(1, "sss");

p.addBatch();

p.executeBatch();

con.commit();

p.close();

con.close();

*******************************

this does too:

con.setAutoCommit(false);

PreparedStatement p=con.prepareStatement("insert test_date(txt) values(?)");

p.setString(1, "das");

p.addBatch();

p.executeBatch();

con.commit();

p.close();

con.close();

*******************************

this works fine:

con.setAutoCommit(false);

PreparedStatement p=con.prepareStatement("insert test_date(txt) values(?)");

p.setString(1, "das");

p.addBatch();

p.executeUpdate();

con.commit();

p.close();

con.close();

*******************************

to make things worse, this does not throw any Exception, but instead of a 5, I get 144595456 in the table!!!:

con.setAutoCommit(false);

PreparedStatement p=con.prepareStatement("insert test_date(l) values(?)");

p.setInt(1, 5);

p.addBatch();

p.executeBatch();

con.commit();

p.close();

con.close();

could someone recode Jdbc2Odbc? :))

nikolas/

[1444 byte] By [ngiannG] at [2007-9-26 3:56:53]