Hi Gino: I think I might have seen this error when the MySQLPlugin is not in the app classpath? In other words, some SQL that the frameworks are trying to build for a transaction are subsequently not being customized properly for MySQL before being sent to the DB.
The errors makes sense in that context. First, there is an attempt to build the SQL string, then com.mysql.jdbc.PreparedStatement.executeInternal experiences an error parsing what has been sent. Check it out. Tim > On Feb 4, 2020, at 1:00 PM, Gino Pacitti via Webobjects-dev > <webobjects-dev@lists.apple.com> wrote: > > Hi > Has anyone encountered this sort of error before? > > It does not happen all the time but just on occasion. > > mysql Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using EditLine wrapper > > Java 8 > > mysql-connector-java-8.0.19.jar > > This is my connection URL > jdbc:mysql://127.0.0.1/<DATABASE>_UTF_8?capitalizeTypeNames=true&useUnicode=true&characterEncoding=UTF-8&characterSetResults=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&sendFractionalSeconds=false&autoReconnect=true&useServerPrepStmts=false&rewriteBatchedStatements=true&useCompression=true > > <mysql://127.0.0.1/%3CDATABASE%3E_UTF_8?capitalizeTypeNames=true&useUnicode=true&characterEncoding=UTF-8&characterSetResults=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&sendFractionalSeconds=false&autoReconnect=true&useServerPrepStmts=false&rewriteBatchedStatements=true&useCompression=true> > > And here is the error > Unexpected exception encountered during > query.java.lang.NullPointerExceptionat > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2532) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903) > at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1242) > 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 > er.extensions.jdbc.ERXJDBCAdaptor$Channel.evaluateExpression(ERXJDBCAdaptor.java:283) > at > com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.java:220) > at > er.extensions.jdbc.ERXJDBCAdaptor$Channel.selectAttributes(ERXJDBCAdaptor.java:200) > 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:1307) > at > com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4444) > at > er.extensions.eof.ERXFetchSpecification.fetchObjects(ERXFetchSpecification.java:155) > _______________________________________________ > 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/lists%40thetimmy.com > > This email sent to li...@thetimmy.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
