aspose file tools*
The moose likes JDBC and the fly likes Error during Batch Updates Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error during Batch Updates" Watch "Error during Batch Updates" New topic
Author

Error during Batch Updates

Prashant Ks
Greenhorn

Joined: Dec 16, 2001
Posts: 3
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).]
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error during Batch Updates