###@###.### 2002-01-15

J2SE Version (please include all output from java -version flag):
  java version "1.4.0-rc"
  Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.0-rc-b90)
  Java HotSpot(TM) Client VM (build 1.4.0-rc-b90, mixed mode)

Does this problem occur on J2SE 1.3? Yes / No (pick one)
  No.

Operating System Configuration Information (be specific):
  Windows 2000, Windows NT4

Hardware Configuration Information (be specific):
  P3, 866 Mhz with 512 MB Ram or P2 400Mhz with 256 MB Ram

Bug Description:
  It is not possible to save a timestamp in a datetime column in MS
  Access. When execute updateTimestamp and then insertRow on a ResultSet
  that have a connection to MS Access then you will get the following exception:

  java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Error in row
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6106)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6263)
        at sun.jdbc.odbc.JdbcOdbc.SQLSetPos(JdbcOdbc.java:4726)
        at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5019)
        at sun.jdbc.odbc.JdbcOdbcResultSet.insertRow(JdbcOdbcResultSet.java:4018)
        at TestUpdateTimestamp.main(TestUpdateTimestamp.java:29) SQLException: SQLState(22008) vendor code(35)
        java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Error in row
        at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5068)
        at sun.jdbc.odbc.JdbcOdbcResultSet.insertRow(JdbcOdbcResultSet.java:4018)
        at TestUpdateTimestamp.main(TestUpdateTimestamp.java:29) java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Invalid
datetime format (null)
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6106)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6263)
        at sun.jdbc.odbc.JdbcOdbc.SQLSetPos(JdbcOdbc.java:4726)
        at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5019)
        at sun.jdbc.odbc.JdbcOdbcResultSet.insertRow(JdbcOdbcResultSet.java:4018)
        at TestUpdateTimestamp.main(TestUpdateTimestamp.java:29) java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Error in row
        at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5068)
        at sun.jdbc.odbc.JdbcOdbcResultSet.insertRow(JdbcOdbcResultSet.java:4018)
        at TestUpdateTimestamp.main(TestUpdateTimestamp.java:29)

Attached is the complete logging output of the test program(error_log.txt)
and the test program(TestUpdateTimestamp.java) to reproduce it, also.


Steps to Reproduce (be specific):

1. Create a ODBC DSN called "access" to the attached Access.mdb.
2. Execute the test program TestUpdateTimestamp with b90 of JDK 1.4


Attached:
1) Access.mdb (MS Access 2000)
2) test program TestUpdateTimestamp.java
3) The complete logging output of TestUpdateTimestamp