• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: SQL Error on fetch
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: SQL Error on fetch
      • From: Gino Pacitti via Webobjects-dev <email@hidden>
References: 
 >SQL Error on fetch (From: Gino Pacitti via Webobjects-dev <email@hidden>)

  • Prev by Date: More recent PRs for wolifecycle-maven-plugin
  • Next by Date: Looking for WOStart.exe (jre 8 and after)
  • Previous by thread: Re: SQL Error on fetch
  • Next by thread: Re: SQL Error on fetch
  • Index(es):
    • Date
    • Thread