EJB-QL problem

[ravidwivedi]

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

[lorensrosen]

Yeah, this seems not to work... if you search back you'll find other people asking about this. You might try the parameterized query (...where o.status = ?1) or just use the string query and the obvious conversion to character.