Error during Batch Updates

[Prashant Ks]

i am using following codes for batch update test purpose:

import java.sql.*;
public class BatchUpdate
{
public static void main(String[] args)
{
try
{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con = DriverManager.getConnection("jdbc:odbc:pubs");
      con.setAutoCommit(false);
PreparedStatement ps = con.prepareStatement("Insert into emp (id,name) values (?,?)");
ps.setInt(1,99999);
ps.setString(2,"Joe Blo");
ps.addBatch();
ps.setInt(1,22222);
ps.setString(2,"Jim Bob");
ps.addBatch();
int[] insertCount=ps.executeBatch();
con.commit();
System.out.println("Update Rows " + insertCount.length);
}
catch(Exception e){System.out.println(e);}
}
}

pubs is a MS-SQL DB and emp is a table in this DB having Id and number as columns..
i am using Kawa for compiling and running this program..
it is not giving any error at compile time..when i run it is showing..
java.lang.NegativeArraySizeException
Process Exit...
but when i see "emp" table there is no new entry...
wot is the exact problem?? is there anything wrong in codes?
Plz reply soon
Thanks
Prashant
[ Edited by Dave to add code tags and fix UBB smilie problems ]
[This message has been edited by David O'Meara (edited December 17, 2001).]

[David O'Meara]

Looks like you're falling into the trap of treating Access like a real database and the jdbc:odbc bridge as a real driver.
Unfortunately the executeBatch() method is a part of JDBC2.0 and the bridge doesn't support it (see http://java.sun.com/products/jdbc/faq.html#2 )
You should start by getting another database or another driver (preferably both) since Access and the jdbc:odbc bridge driver are unsuitable for what you are attempting.
Dave.