-
1. Re: Can i generate a dynamic query ejbSelect method using XD
pdutta Nov 22, 2002 10:14 AM (in response to drinferno)If you are using the latest beta XDoclet (1.2.0beta something) then @jboss.query does work. Here is an example:
@jboss.query
signature = "java.util.Set ejbSelectSynamic(java.lang.String sql, java.lang.Object[] args)"
dynamic = "true"
Also create the abstract method signature in the bean and off you go. Hope this helps.
-Partha -
2. Re: Can i generate a dynamic query ejbSelect method using XD
r_q_d Dec 19, 2002 9:49 AM (in response to drinferno)My 2 cents for this used with xdoclet.
1. define this in the ejb bean:
* @ejb:finder
* signature = "java.util.Collection findDynamicly(java.lang.String sql, java.lang.Object[] args)"
* query = ""
*
* @jboss:query
* signature = "java.util.Collection findDynamicly(java.lang.String sql, java.lang.Object[] args)"
* dynamic = "true"
2. at the client side, use this:
String status=...;
StringBuffer sql=new StringBuffer("SELECT OBJECT(c) FROM Article as c where c.clientId=?1 and c.status='");
Vector args=new Vector();
args.add("123");
sql.append( status+"'");
Collection records=home.findDynamicly(sql.toString(), args.toArray());
hope this helps.