--- Herve Tchepannou <[EMAIL PROTECTED]> wrote: > I'm trying to execute the following EJB-QL query: > > SELECT DISTINCT OBJECT(p) FROM Product AS p WHERE > LOCATE(p.productId,?1) > -1 OR > LOCATE(p.name,?1) > -1 OR > LOCATE(p.description,?1) > -1 > > Shouldn't this work like the following SQL query: > SELECT * FROM Product WHERE > p.productId like ?1 OR > p.name LIKE ?1 OR > p.description LIKE ?1 > > If not, does anyone knows how to use LIKE in EJB-QL > with parameters?
I do not think that question about workings of JBOSS persistence engine belongs to this list. jboss.prg got its own forums, and there is certainly one about persistence problems... regards, ===== Konstantin Priblouda ( ko5tik ) Freelance Software developer < http://www.pribluda.de > < play java games -> http://www.yook.de > < render charts online -> http://www.pribluda.de/povray/ > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus � Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Xdoclet-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/xdoclet-user
