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 | 10 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

    query, join and IS NULL

    Oracle Community | 10 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)

    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