This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Problem with addBatch .... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with addBatch ...." Watch "Problem with addBatch ...." New topic
Author

Problem with addBatch ....

smyle khanna
Ranch Hand

Joined: Jan 14, 2004
Posts: 54
Hi
i am trying 2 insert data using the addBatch statement,n its givin the following exceptions,plz do tell where is the mistake n how 2 recitfy it
thanks

this code is raising the following exceptions:
SQLException:[Microsoft][ODBC Microsoft Access Driver]Syntax error in Insert INTO statement
SQLState:37000
Message::[Microsoft][ODBC Microsoft Access Driver]Syntax error in Insert INTO statement
Vendor:0
Update Counts:
Varun Khanna
Ranch Hand

Joined: May 30, 2002
Posts: 1400
Your query is going like :
"insert into VBJavaoptvalues ..."
You are missing a space before "values" string.


- Varun
 
wood burning stoves
 
subject: Problem with addBatch ....
 
Similar Threads
Problem inserting a single quote (')
batchupdateException.getUpdateCounts() doesnot return correct result as per JDBC api
Syntax error in INSERT INTO statement
getting batchupdate exception while inserting recored for second time...
oracle connection with jdbc