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".

Answer 1

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

Could you put the structure of the table here?