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
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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