jQuery in Action, 3rd edition
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Problem with addBatch ....
It's not a secret anymore!