i am using following codes for batch update test purpose:
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).]
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.