Uploaded image for project: 'JDK'
  1. JDK
  2. JDK-4623847

can not save a timestamp in a datetime column in MS Access

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: P3 P3
    • None
    • 1.4.0
    • core-libs


      ###@###.### 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

            ahandasunw Amit Handa (Inactive)
            tyao Ting-Yun Ingrid Yao (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:
              Imported:
              Indexed: