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")

Spring JIRA | The Alchemist | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 6 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 | 6 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 | 6 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 | 6 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")

    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