org.apache.derby.client.am.SqlException: Syntax error: Encountered "*" at line 1, column 199.Error Code: -1 Call:SELECT t0.ID, t0.NODO_ID, t0.ATTORE_ID, t0.STATOORDINE_ID, t0.CLASSIFICAZIONE_ID FROM ordini t0 LEFT OUTER JOIN an_nodi t1 ON (t1.ID = t0.NODO_ID) WHERE ((t1.NOME = 'abc') OR t0.NODO_ID =* NULL) Query:ReportQuery(it.test.app.entity.Ordine)

Oracle Community | rooz | 9 years ago
  1. 0

    query, join and IS NULL

    Oracle Community | 9 years ago | rooz
    org.apache.derby.client.am.SqlException: Syntax error: Encountered "*" at line 1, column 199.Error Code: -1 Call:SELECT t0.ID, t0.NODO_ID, t0.ATTORE_ID, t0.STATOORDINE_ID, t0.CLASSIFICAZIONE_ID FROM ordini t0 LEFT OUTER JOIN an_nodi t1 ON (t1.ID = t0.NODO_ID) WHERE ((t1.NOME = 'abc') OR t0.NODO_ID =* NULL) Query:ReportQuery(it.test.app.entity.Ordine)
  2. 0

    Delete query

    Oracle Community | 10 years ago | 843830
    org.apache.derby.client.am.SqlException: Syntax error: Encountered "=" at line 1, column 46.Error Code: -1 Call:DELETE FROM WVID WHERE ((LISTNAME = ?) AND ( = ?)) bind => [tobiassen1/default@meldingssentralen.no, no.tobiassen.entities.Users[id=1]] Query:DeleteAllQuery() at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:303) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
  3. 0

    JPA 2.0 CriteriaBuilder.size() throws SQLSyntaxError Exception

    Eclipse Bugzilla | 7 years ago | raja.perumal
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "FROM" at line 1, column 9. Error Code: -1 Call: SELECT FROM CUSTOMER_TABLE t0 Query: ReportQuery(referenceClass=Customer sql="SELECT FROM CUSTOMER_TABLE t0")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Migration's parser is causing causing false syntax error on certain comments

    GitHub | 2 years ago | GoogleCodeExporter
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered ";" at line 1, column 51.
  6. 0

    importing

    db-derby-user | 7 years ago | Glenn Ambrose
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "/" at line 1, column 53.

    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. org.apache.derby.client.am.SqlException

      Syntax error: Encountered "*" at line 1, column 199.Error Code: -1 Call:SELECT t0.ID, t0.NODO_ID, t0.ATTORE_ID, t0.STATOORDINE_ID, t0.CLASSIFICAZIONE_ID FROM ordini t0 LEFT OUTER JOIN an_nodi t1 ON (t1.ID = t0.NODO_ID) WHERE ((t1.NOME = 'abc') OR t0.NODO_ID =* NULL) Query:ReportQuery(it.test.app.entity.Ordine)

      at oracle.toplink.essentials.exceptions.DatabaseException.sqlException()
    2. oracle.toplink.essentials
      EJBQueryImpl.getResultList
      1. oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:303)
      2. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
      3. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
      4. oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:465)
      5. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
      6. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
      7. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
      8. oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
      9. oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2115)
      10. oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2081)
      11. oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuery(ReportQuery.java:774)
      12. oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
      13. oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
      14. oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
      15. oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2218)
      16. oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
      17. oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
      18. oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:346)
      19. oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:447)
      19 frames