File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

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