setting null values in mS ACCESS DB using preparedStatement.setNull()
843854Oct 1 2002 — edited Oct 1 2002URGENT!!! help needed,
I have something really strange using JdbcOdbCDriver1.22 Class to manipulate data in a MS ACCESS DB. I use the setNull(int parameterIndex, int sqlType) method on a PreparedStatement to update existig data in my table.
When dealing with String typed fields, no problem. But when I try to assign null value to a DATE typed field, I get this from Driver :
[Microsoft][Gestionnaire de pilotes ODBC] Type de donn�es SQL hors limites"
java.sql.SQLException: [Microsoft][Gestionnaire de pilotes ODBC] Type de donn�es SQL hors limites
java.lang.Throwable(java.lang.String)
java.lang.Exception(java.lang.String)
java.sql.SQLException(java.lang.String, java.lang.String, int)
java.sql.SQLException sun.jdbc.odbc.JdbcOdbc.createSQLException(int, int, int)
void sun.jdbc.odbc.JdbcOdbc.standardError(short, int, int, int)
void sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterNull(int, int, int, byte [], int [])
void sun.jdbc.odbc.JdbcOdbcPreparedStatement.setNull(int, int)
Thanks for any Idea;