This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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!
I agree. Here's the link:
subject: Why it is not INSERTing
Similar Threads
classpath - differences between java command line argument and environment variable
Sql optimizer
count number of coulmns in table?
Problem in RDBMS
how do i do this urgent