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 I m getting error '[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.' 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 "I m getting error Watch "I m getting error New topic
Author

I m getting error '[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.'

java mohamed
Greenhorn

Joined: Dec 22, 2010
Posts: 9
Hi I am getting error '[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.'


my code is below





help me.. thanks in advance
Prasad Krishnegowda
Ranch Hand

Joined: Apr 25, 2010
Posts: 507

This exception may come with MS-Access database, when you specify a column name in a select statement. Try giving * instead of the fields.. also, try removing the where condition if the error persists..


Regards, Prasad
SCJP 5 (93%)
T. Huy Nguyen
Ranch Hand

Joined: Nov 02, 2010
Posts: 57
This line



does not seem right because CQ_ID is of type String and there is no quote around CqId


My material for SCJP (2008), SCWCD (2010), SCBCD (2010). About me
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

You have a resource leak here. You return without closing your resources.


OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: I m getting error '[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.'
 
Similar Threads
Not able to iterate through a bean property of type Array List
Access DB
Error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
SQL Error :Too few parameters.
Reading excel file with data in chinese language using jdbc