0 Replies Latest reply on May 7, 2010 7:00 AM by kalpana prakasam

    Join query doesn't bind the parameter at all

    kalpana prakasam Novice
      I am using the join query on a pair of tables. The query runs fine via plain sql, but the result list doesn't seem to take the restriction parameter even if set.
      
      For example TableA contains a OneToOne relationship to TableB and my ejbQL looks like this "
      
      TableAList.java contains the following code
      
      EJBQL = "select a from TableA a join a.TableB b";
      
      private static final String[] RESTRICTIONS = {
          "a.type = #{tableAList.a.type}",
          "b.status = #{tableAList.status}"
      
      Even if we set the tableAList.status the SQL never generates the where clause for b.status.
      
      What am I missing here?