Hi Guys,
I am using jboss 4.0.0, trying to deploy entity bean. I am getting following error for EJB-QL. I have tried modifying the EJB-QL little bit, Finally i got to a point that if i remove "'F' = ?2" this kind of check in the EJB-QL it is getting deployed.
Can some one help me to make the bellow EJB-QL work as it is..
************************ERROR LOG***********************
org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT DISTINCT OBJECT(a)
FROM bbsoft a
WHERE
a.bNbr = ?1
AND ('F' = ?2 OR a.tStatus = ?3)
ORDER BY a.tId'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "\'F\'" at line 5, column 42.
Was expecting one of:
"ABS" ...
"LENGTH" ...
"LOCATE" ...
"SQRT" ...
"MOD" ...
"(" ...
"+" ...
"-" ...
<INTEGER_LITERAL> ...
<FLOATING_POINT_LITERAL> ...
<NUMERIC_VALUED_PARAMETER> ...
<NUMERIC_VALUED_PATH> ...
"NOT" ...
<COLLECTION_VALUED_PATH> ...
<STRING_VALUED_PATH> ...
"CONCAT" ...
"SUBSTRING" ...
<BOOLEAN_VALUED_PATH> ...
<DATETIME_VALUED_PATH> ...
<ENTITY_VALUED_PATH> ...
<IDENTIFICATION_VARIABLE> ...
)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:52)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:60)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:272)
************************ERROR LOG***********************
Thanks
Anil