bug #6111

invalid SQL (MySQLSyntaxErrorException) during call to CdmEntityDaoBase.list()

Added by Andreas Kohlbecker almost 5 years ago. Updated over 4 years ago.

Target version:
Start date:
Due date:
% Done:


Found in Version:


The Specimens Table in the chichorieae portal is no longer working due to a bug in the CdmEntityDaoBase.list() method.

The web service call to causes the cdmlib to throw an exception:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by this_.titleCache asc limit 30' at line 1
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
    at java.lang.reflect.Constructor.newInstance(
    at com.mysql.jdbc.Util.handleNewInstance(
    at com.mysql.jdbc.Util.getInstance(
    at com.mysql.jdbc.SQLError.createSQLException(
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(
    at com.mysql.jdbc.MysqlIO.sendCommand(
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
    at com.mysql.jdbc.ConnectionImpl.execSQL(
    at com.mysql.jdbc.PreparedStatement.executeInternal(
    at com.mysql.jdbc.PreparedStatement.executeQuery(
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(
    at org.hibernate.loader.Loader.getResultSet(
    at org.hibernate.loader.Loader.executeQueryStatement(
    at org.hibernate.loader.Loader.executeQueryStatement(
    at org.hibernate.loader.Loader.doQuery(
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(
    at org.hibernate.loader.Loader.doList(
    at org.hibernate.loader.Loader.doList(
    at org.hibernate.loader.Loader.listIgnoreQueryCache(
    at org.hibernate.loader.Loader.list(
    at org.hibernate.loader.criteria.CriteriaLoader.list(
    at org.hibernate.internal.SessionImpl.list(
    at org.hibernate.internal.CriteriaImpl.list(
    at eu.etaxonomy.cdm.persistence.dao.hibernate.common.CdmEntityDaoBase.list(
    at eu.etaxonomy.cdm.api.service.OccurrenceServiceImpl.pageFieldUnitsByAssociatedTaxon(

Associated revisions

Revision d8607241 (diff)
Added by Andreas Müller over 4 years ago

fix #6111 hopefully fix MySQLSyntaxErrorException during call to CdmEntityDaoBase.list()


#1 Updated by Andreas Müller almost 5 years ago

  • Target version changed from Release 4.4 to Release 4.5

#2 Updated by Andreas Müller over 4 years ago

  • Target version changed from Release 4.5 to Release 4.6

#3 Updated by Andreas Müller over 4 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 50

#4 Updated by Andreas Müller over 4 years ago

Check after release if this is fixed by d8607241

#5 Updated by Andreas Müller over 4 years ago

  • Assignee changed from Andreas Müller to Andreas Kohlbecker

This seems to be fixed. I checked in TaxEditor that Lactuca perennis does not have any any associatedFieldUnits, so the empty result seems to be correct.
Please review.

#6 Updated by Andreas Kohlbecker over 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)