Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
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
jQuery in Action, 3rd edition