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
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3869778#3869778
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3869778
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
