This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
execute batch is not executing all the queries.
Firing SQLs in Batch to enhance performance
What problem with this batch update ?
Prepared Statement
Batch update in EJB