File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
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