aspose file tools*
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
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: 563
    
    3

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..
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: 2510
    
  10

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


OCUP UML fundamental and ITIL foundation
youtube channel
 
jQuery in Action, 2nd edition
 
subject: I m getting error '[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.'