-
Bug
-
Resolution: Duplicate
-
P3
-
None
-
1.4.0
-
x86
-
windows_2000
###@###.### 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
- duplicates
-
JDK-4638528 Updatable Result sets crashes in stress test
-
- Resolved
-