aspose file tools
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

Win a copy of Meteor in Action this week in the JavaScript forum!
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 ....