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 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!
 
GeeCON Prague 2014
 
subject: Why it is not INSERTing