aspose file tools*
The moose likes JDBC and the fly likes Why it is not INSERTing Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Why it is not INSERTing" Watch "Why it is not INSERTing" New topic
Author

Why it is not INSERTing

Huzefa Zohaib
Ranch Hand

Joined: Nov 21, 2001
Posts: 40
Please tell me what is the meaning of following exception
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
It is occuring on the following lines
Philip Shanks
Ranch Hand

Joined: Oct 15, 2002
Posts: 189
Just a guess, but when you are using a string literal for a query do you need to have single quotes around the parameter value (as 'Amir')?


Philip Shanks, SCJP - Castro Valley, CA
My boss never outsources or has lay-offs, and He's always hiring. I work for Jesus! Prepare your resume!
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Why it is not INSERTing