File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Error during Batch Updates Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Error during Batch Updates" Watch "Error during Batch Updates" New topic

Error during Batch Updates

Prashant Ks

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..
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
[ 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

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 )
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.
I agree. Here's the link:
subject: Error during Batch Updates
It's not a secret anymore!