1 Reply Latest reply on Jun 19, 2009 7:22 AM by allforjava.allforjava.aol.in

    How to: Restrictions or Ejbql?

    allforjava.allforjava.aol.in
      Dear Team,

      Please clarify as what am I missing towards query in getEjbql():

      String searchId = '%'+issuesId.toUpperCase()+'%';
      String query = " where timesheets.workLog.issues.issueId like \'"+searchId+"\' or "+"timesheets.workLog.tasks.taskId like \'"+searchId+"\' ";
      return "select timesheets from Timesheets timesheets "+query;

      It throws:

      Caused by: javax.el.ELException: /TimesheetsList.xhtml @80,56 rendered="#{empty timesheetsList.resultList}": Error reading 'resultList' on type org.domain.Portal.session.TimesheetsList_$$_javassist_70
           at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)
           at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:370)
           ... 55 more
      Caused by: java.lang.NullPointerException
           at org.hibernate.hql.ast.tree.FromClause.findIntendedAliasedFromElementBasedOnCrazyJPARequirements(FromClause.java:120)

      Referred:

      http://seamframework.org/Community/JBossSeamEnitityQueryAndRestrictionsAndOrOperationInTheQuery     

      http://seamframework.org/Community/EntityQueryWithRestrictionsProblem#comment75589

      Note: Using seam 2.0.1 SP1
      IssueId and TaskId are Strings.

      Thank you in advance!