Invalid dattime format

[nag...@my-deja.com]

Hi gurus,

searched the whole of the deja group to no success.
Using jdbc-obdc with MSAccess. Actually am importing many records into
the database. (inserting) I get this strange error
which says

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Invalid
datetime format (null)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(SQLException.java:43)
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Compiled Code)
at sun.jdbc.odbc.JdbcOdbc.standardError(Compiled Code)
at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Compiled Code)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Compiled
Code)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate
(Compiled Code)

I am inserting a Timestamp into the database along eith other values.
Also i have made sure its not a null ( if that helps??)
in which case i use preparedStatement.setNull(..
has anyone faced the same problem ??
Am i doing something wrong.

thanks
Nagesh

Sent via Deja.com http://www.deja.com/
Before you buy.