[JBoss-user] jboss dynamic ql problem

[aaaa aaaa]

Hi,

I have a dynamic ql issue. Does anyone has working examples for dynamic-ql and share them with jboss -users? I am stuck with the following dynamic ql errors.

 

Thanks

 

J.P.

 

in the ejb-jar.xml, here is the piece:

 <query>
  <query-method>
    <method-name>ejbSelectABCD</method-name>
    <method-params>
     <method-param>java.lang.String</method-param>
     <method-param>java.lang.Object[]</method-param>
  </query-method>
  <ejb-ql/>
 </query>

 

in the jbosscmp-jdbc.xml, here is the piece:

 <query>
  <query-method>
    <method-name>ejbSelectABCD</method-name>
    <method-params>
     <method-param>java.lang.String</method-param>
     <method-param>java.lang.Object[]</method-param>
  </query-method>
  <dynamic-ql/>
 </query>

 

In the program, I construct:

String sql_str="SELECT OBJECT(obj) FROM xyzTable obj WHERE obj.f1 = a1 AND obj.f2 = a2";

and call jbSelectABCD(sql_str, new Object[]{});

 

the error log messages I got are:

 

DEBUG [ejbSelectABCD] DYNAMIC-QL: SELECT OBJECT(obj) FROM xyzTable obj WHERE obj.f1 = a1 AND obj.f2 = a2

 

ERROR [STDERR] javax.ejb.FinderException:

Error compiling ejbql: org.jboss.ejb.plugins.cmp.ParseException: Encountered "a1" at line1, column ...

Was expecting one of:
 "CONCAT"
 "SUBSTRING"...

 

ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.execute(JDBCDynamicQLQuery.java:74)

 

org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCSelectorBridge.execute(JDBCSelectorBridge.java:64)

---

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!