java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters

Question

It seems that this part of my code is where the exception occurs:

c = dbConnection.getConnection(); 
q = "SELECT * FROM book WHERE nextInc<=? AND inlib=?";
s = c.prepareStatement(q); 
s.setBigDecimal(1,BigDecimal.valueOf(curDate.getTime())); 
s.setBoolean(2,false); 
rs = s.executeQuery(); <-- Error.

I'm using "sun.jdbc.odbc.JdbcOdbcDriver".

shahkalpesh · Accepted Answer · 2010-02-27 05:14:35Z

5

As per this, the error could occur because of non-existent column.

Could you put the structure of the table here?

answered Feb 27, 2010 at 5:14

shahkalpesh

33.6k4 gold badges66 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dean Over a year ago

I feel like an idiot, I mistyped the column name. Thanks for the help.

Dave · Accepted Answer · 2011-04-05 14:46:03Z

0

After checking all of my column names, I also discovered that double quotes around a string literal will cause the same error.

Wrong: WHERE foo LIKE "bar"

Right: WHERE foo LIKE 'bar'

Just an FYI for any non-Access folks scratching their heads (like me).

answered Apr 5, 2011 at 14:46

Dave

4,5972 gold badges42 silver badges61 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related