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 Problem with addBatch .... 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 "Problem with addBatch ...." Watch "Problem with addBatch ...." New topic

Problem with addBatch ....

smyle khanna
Ranch Hand

Joined: Jan 14, 2004
Posts: 54
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

this code is raising the following exceptions:
SQLException:[Microsoft][ODBC Microsoft Access Driver]Syntax error in Insert INTO statement
Message::[Microsoft][ODBC Microsoft Access Driver]Syntax error in Insert INTO statement
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:
subject: Problem with addBatch ....
It's not a secret anymore!