how to specify null value in MS Access

Question

I am not able to call setNull on PreparedStatement using MS Access (sun.jdbc.odbc.JdbcOdbcDriver)

preparedStatement.setNull(index, sqltype). Is there a workaround for this.

For LONGBINARY data type, I tried the following calls, neither worked.

 setNull(index, java.sql.Types.VARBINARY)
 setNull(index, java.sql.Types.BINARY)

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Invalid SQL data type
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
        at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterNull(JdbcOdbc.java:986)
        at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setNull(JdbcOdbcPreparedStatement.java:363)

Answer 1

The Sun JDBC ODBC bridge driver has a lot of odd bugs/flaws and I personally have never used it extensively, so here's a shoot in the dark: what if you just set it with a real null?

preparedStatement.setBinaryStream(index, null);

For the better MS Access driver, have a look at HXTT.