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>
<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>
<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"...
"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!
