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 <gino.paci...@baseenterpriseus.com> > 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 >> <webobjects-dev@lists.apple.com <mailto:webobjects-dev@lists.apple.com>> >> 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 (Webobjects-dev@lists.apple.com >> <mailto:Webobjects-dev@lists.apple.com>) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/ginokris%40mac.com >> <https://lists.apple.com/mailman/options/webobjects-dev/ginokris%40mac.com> >> >> This email sent to ginok...@mac.com <mailto:ginok...@mac.com> >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
