1 Reply Latest reply on Jan 20, 2003 5:11 PM by Loren Rosen

    EJB-QL problem

    ravidwivedi Newbie

      Hi All
      Please not that I am working on porting one application from weblogic server to Jboss.
      In one of the EJB named as DomainDataEJB a cmp filed is of Character object type called as status and I have defined abstract get and set methods as follows:

      abstract public Character getStatus();
      abstract public void setStatus(Character status);

      I have defined one EJB QL to get all the domains with status as A as follows

      <![CDATA[SELECT OBJECT(o) FROM DomainDataEJB AS o WHERE o.status = 'A']]>

      this is working fine in weblogic6.1sp2 server and I am getting correct results but
      when I am trying to deploy the ejb with same EJB QL on jboss-3.0.4_tomcat-4.1.12 server I am getting exceptions
      and then I changed the CMP field to String type as shown below

      abstract public Character getStatus();
      abstract public void setStatus(Character status);

      It starts working in case of Jboss also.

      Now my question is that how to compare Character
      in case of Jboss and kindly suggeste the EJB QL for Jboss when the CMP fields are of Character type same as what was for WLS
      with best regards
      ravi
      Note:The field is defined as STATUS CHAR (1) in DB