Re: move to mysql 8 on Catalina jdbc Incorrect DATE value: '??’
Re: move to mysql 8 on Catalina jdbc Incorrect DATE value: '??’
- Subject: Re: move to mysql 8 on Catalina jdbc Incorrect DATE value: '??’
- From: John Pollard via Webobjects-dev <email@hidden>
- Date: Mon, 9 Nov 2020 14:41:08 +0000
Very kind of you. All I did was swap mysql-connector-java-8.0.19.jar in place
of the more recent mysql-connector-java-8.0.22.jar and it resolved my problem.
Using the latest 8.0.22 version, I get the "Incorrect DATE value: '??’at” error.
Should I update my Wonder code anyway? My last grab of it was in 2015! I have
been scared to touch it.
Obviously it is a concern that the latest mysql jdbc connector has this problem
and I would be interested to know whether anyone else had tried 8.0.22 with
success. For now I can work with the 8.0.19 version.
Thanks
John
> On 9 Nov 2020, at 13:31, CEO BASE USA <email@hidden>
> wrote:
>
> Hi John
> I used this jar and then this config
>
> MYEOMODEL.URL =
> jdbc:mysql://127.0.0.1/MYDATABASE?capitalizeTypeNames=true&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=false&sendFractionalSeconds=false
>
> <mysql://127.0.0.1/MYDATABASE?capitalizeTypeNames=true&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=false&sendFractionalSeconds=false>
>
> MYEOMODEL.URL.DBUser = xxx
> MYEOMODEL.URL.DBPassword = xxx
> MYEOMODEL.URL.DBPlugin = MySQL
> MYEOMODEL.URL.DBDriver = com.mysql.cj.jdbc.Driver
> #dbEOPrototypesEntityGLOBAL=EOJDBCMySQLPrototypes
> <mysql-connector-java-8.0.19.jar>
>
>> On 9 Nov 2020, at 11:58, John Pollard via Webobjects-dev
>> <email@hidden <mailto:email@hidden>>
>> wrote:
>>
>> 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
>>
>> <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
>> <mailto:email@hidden>)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden <mailto:email@hidden>
>
_______________________________________________
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