move to mysql 8 on Catalina jdbc Incorrect DATE value: '??’
move to mysql 8 on Catalina jdbc Incorrect DATE value: '??’
- Subject: move to mysql 8 on Catalina jdbc Incorrect DATE value: '??’
- From: John Pollard via Webobjects-dev <email@hidden>
- Date: Mon, 9 Nov 2020 11:58:37 +0000
Hello WO list,
I upgraded my Mac to Catalina and found mysql 5 no longer ran, so installed
mysql 8
I switched to the latest mysql-connector-java-8.0.22.jar
I note the following error when I run an application:
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class
is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the
SPI and manual loading of the driver class is generally unnecessary.
My connection dictionary:
URL:
jdbc:mysql://localhost/BetRankDB?user=root&capitalizeTypeNames=true&useUnicode=true&characterEncoding=UTF-8&sendFractionalSeconds=false
Driver: com.mysql.jdbc.Driver
Plugin: MySQL
I tried removing the Driver, but got the same error message. So I changed
Driver to com.mysql.cj.jdbc.Driver and that error went away.
However, I get the following exception:
er.transaction.adaptor.Exceptions - Database Exception occured: Incorrect DATE
value: '??’at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at
com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370)
at
com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:265)
at
com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
at
com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296)
at com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.java:220)
at
com.webobjects.eoaccess.EODatabaseChannel._selectWithFetchSpecificationEditingContext(EODatabaseChannel.java:897)
at
com.webobjects.eoaccess.EODatabaseChannel.selectObjectsWithFetchSpecification(EODatabaseChannel.java:234)
at
com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3055)
at
com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195)
at
com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488)
at
com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069)
at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1308)
at
com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4444)
I confess I haven’t updated Wonder code for a very long time, could that be the
issue?
Many thanks for any pointers.
John
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden