java.sql.SQLSyntaxErrorException: Syntax error: Encountered "_" at line 1, column 8. Error Code: 30000 Call: SELECT _id, ID, version FROM MACADDRESS Query: ReadAllQuery(referenceClass=MacAddress sql="SELECT _id, ID, version FROM MACADDRESS")

SpringSource Issue Tracker | The Alchemist | 5 years ago
  1. 0

    In Roo, do this: // Spring Roo 1.1.5.RELEASE [rev d3a68c3] log opened at 2011-07-28 11:10:39 project --topLevelPackage blah.bcfactory --projectName blah --java 6 persistence setup --database DERBY --provider ECLIPSELINK entity --class ~.domain.MacAddress --testAutomatically field number --fieldName id --type java.lang.Long --notNull perform test What'll you get? Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "_" at line 1, column 8. Error Code: 30000 Call: SELECT _id, ID, version FROM MACADDRESS Query: ReadAllQuery(referenceClass=MacAddress sql="SELECT _id, ID, version FROM MACADDRESS") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:566) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:647) -- Configuration Details -- Product: SpringSource Tool Suite 2.7.1.201107091000-RELEASE (com.springsource.sts.ide) Installed Features: com.springsource.sts 2.7.1.201107091000-RELEASE

    SpringSource Issue Tracker | 5 years ago | The Alchemist
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "_" at line 1, column 8. Error Code: 30000 Call: SELECT _id, ID, version FROM MACADDRESS Query: ReadAllQuery(referenceClass=MacAddress sql="SELECT _id, ID, version FROM MACADDRESS")
  2. 0

    In Roo, do this: {noformat} // Spring Roo 1.1.5.RELEASE [rev d3a68c3] log opened at 2011-07-28 11:10:39 project --topLevelPackage blah.bcfactory --projectName blah --java 6 persistence setup --database DERBY --provider ECLIPSELINK entity --class ~.domain.MacAddress --testAutomatically field number --fieldName id --type java.lang.Long --notNull perform test {noformat} What'll you get? {code} Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "_" at line 1, column 8. Error Code: 30000 Call: SELECT _id, ID, version FROM MACADDRESS Query: ReadAllQuery(referenceClass=MacAddress sql="SELECT _id, ID, version FROM MACADDRESS") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:566) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:647) {code}

    Spring JIRA | 5 years ago | The Alchemist
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "_" at line 1, column 8. Error Code: 30000 Call: SELECT _id, ID, version FROM MACADDRESS Query: ReadAllQuery(referenceClass=MacAddress sql="SELECT _id, ID, version FROM MACADDRESS")
  3. 0

    In Roo, do this: {noformat} // Spring Roo 1.1.5.RELEASE [rev d3a68c3] log opened at 2011-07-28 11:10:39 project --topLevelPackage blah.bcfactory --projectName blah --java 6 persistence setup --database DERBY --provider ECLIPSELINK entity --class ~.domain.MacAddress --testAutomatically field number --fieldName id --type java.lang.Long --notNull perform test {noformat} What'll you get? {code} Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "_" at line 1, column 8. Error Code: 30000 Call: SELECT _id, ID, version FROM MACADDRESS Query: ReadAllQuery(referenceClass=MacAddress sql="SELECT _id, ID, version FROM MACADDRESS") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:566) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:647) {code}

    Spring JIRA | 5 years ago | The Alchemist
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "_" at line 1, column 8. Error Code: 30000 Call: SELECT _id, ID, version FROM MACADDRESS Query: ReadAllQuery(referenceClass=MacAddress sql="SELECT _id, ID, version FROM MACADDRESS")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    In Roo, do this: // Spring Roo 1.1.5.RELEASE [rev d3a68c3] log opened at 2011-07-28 11:10:39 project --topLevelPackage blah.bcfactory --projectName blah --java 6 persistence setup --database DERBY --provider ECLIPSELINK entity --class ~.domain.MacAddress --testAutomatically field number --fieldName id --type java.lang.Long --notNull perform test What'll you get? Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "_" at line 1, column 8. Error Code: 30000 Call: SELECT _id, ID, version FROM MACADDRESS Query: ReadAllQuery(referenceClass=MacAddress sql="SELECT _id, ID, version FROM MACADDRESS") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:566) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:647) -- Configuration Details -- Product: SpringSource Tool Suite 2.7.1.201107091000-RELEASE (com.springsource.sts.ide) Installed Features: com.springsource.sts 2.7.1.201107091000-RELEASE

    SpringSource Issue Tracker | 5 years ago | The Alchemist
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "_" at line 1, column 8. Error Code: 30000 Call: SELECT _id, ID, version FROM MACADDRESS Query: ReadAllQuery(referenceClass=MacAddress sql="SELECT _id, ID, version FROM MACADDRESS")
  6. 0

    JPA query syntax error

    Stack Overflow | 2 years ago | Ghost
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "LIKE" at line 1, column 146. Error Code: 30000 Call: SELECT t1.COD_ENCOMENDA, t1.DATA_ENCOMENDA, t1.DATA_PREVISTA, t1.UNIDADES, t1.MED_COD_MEDICAMENTO FROM MEDICAMENTO t0, ENCMEDICAMENTO t1 WHERE ( LIKE ? AND (t0.COD_MEDICAMENTO = t1.MED_COD_MEDICAMENTO)) bind => [1 parameter bound] Query: ReadAllQuery(referenceClass=EncMedicamento sql="SELECT t1.COD_ENCOMENDA, t1.DATA_ENCOMENDA, t1.DATA_PREVISTA, t1.UNIDADES, t1.MED_COD_MEDICAMENTO FROM MEDICAMENTO t0, ENCMEDICAMENTO t1 WHERE ( LIKE ? AND (t0.COD_MEDICAMENTO = t1.MED_COD_MEDICAMENTO))")

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      Syntax error: Encountered "_" at line 1, column 8. Error Code: 30000 Call: SELECT _id, ID, version FROM MACADDRESS Query: ReadAllQuery(referenceClass=MacAddress sql="SELECT _id, ID, version FROM MACADDRESS")

      at org.eclipse.persistence.exceptions.DatabaseException.sqlException()
    2. EclipseLink (non-OSGi)
      DatasourceCallQueryMechanism.selectAllRows
      1. org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
      2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684)
      3. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
      4. org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729)
      5. org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:566)
      6. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
      7. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
      8. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264)
      9. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:647)
      9 frames