I'm using DynamicQL with a SearchObject (Value Object for searching) the
following way. Maybe it gives you a hint for the LIKE. This is working on 3.2.x.
| public abstract Collection ejbSelectGeneric(String jbossQl, Object[] args)
throws FinderException;
|
| /**
| * @ejb.home-method
| */
| public Collection ejbHomeGetBySearch(SearchObject so) throws
FinderException {
| ArrayList argsList = new ArrayList();
| StringBuffer jbossQl = new StringBuffer();
| jbossQl.append("SELECT OBJECT(t) ");
| jbossQl.append("FROM Table_x t ");
| int bindCount = 0;
| if (so.getNumberCriterion()) {
| bindCount++;
| jbossQl.append((bindCount == 1 ? "WHERE" : "AND") + " t.column1
LIKE ?" + bindCount + " ");
| argsList.add(so.getColumn1());
| }
| if (so.getTitleCriterion()) {
| bindCount++;
| jbossQl.append((bindCount == 1 ? "WHERE" : "AND") + " t.column2
LIKE ?" + bindCount + " ");
| argsList.add(so.getColumn2());
| }
| jbossQl.append("ORDER BY t.column1 ASC");
| Object[] args = argsList.toArray();
| return ejbSelectGeneric(jbossQl.toString(), args);
| }
|
Johan
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3856339#3856339
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3856339
-------------------------------------------------------
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://productguide.itmanagersjournal.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
