"select top * ..." with Access

[yuki tanabe]

Hi,

I'm having trouble executing a PreparedStatement against a MS Access database. The query string, taken using Eclipse debugger during runtime is:

  
"select  top ? * from files where id >= ? "

and I do

pstmtFetchPage.setInt(1,PAGE_SIZE);
pstmtFetchPage.setInt(2,startIndex);

where pstmtFetchPage is the PreparedStatement.

When I execute the statement, I get the following error:

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)

I really can't see what I'm doing wrong. Any help is very much appreciated.

cheers.

[Jeanne Boyarsky]

Abe,
The database is complaining about the first question mark (the one after the keyword top.) In JDBC, you can't substitute just any part of the SQL in through a prepared statement. Basically, you can only put a value in (for the where clause.) You are going to need to build the first part of the statement dynamically.