my dog learned polymorphism
The moose likes JDBC and Relational Databases 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 and Relational Databases
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!
I agree. Here's the link:
subject: Why it is not INSERTing
It's not a secret anymore!