Re: SQL Error on fetch
Re: SQL Error on fetch
- Subject: Re: SQL Error on fetch
- From: Tim W via Webobjects-dev <email@hidden>
- Date: Fri, 7 Feb 2020 09:36:28 -0800
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
> <email@hidden> 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/_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 (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to 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