Paul Guermonprez penned
> i try to use JBoss dynamic query, with xdoclet,
> the deployment is ok, but the result is empty,
> no exception generated.
> ...
> the testing QL is :
>
> select Object(o) from Employee o where o.firstName like '%?1%'
You cannot include %'s directly with regular EJB-QL, so I suspect the
same is true with JBoss-QL. The reason is that the QL engine replaces ?1
-- in the case of a String param -- with "'<value>'" (note the single
quotes). So you end up with the query
... o.firstName like '%'Paul'%'
or something equally broken. Why that doesn't give you an error, I do
not know. Instead, when using like queries, you must add the %'s to the
parameter and remove the single-quotes from the query. For example, pass
in "%Paul%" as the parameter and
select Object(o) from Employee o where o.firstName like ?1
as the query.
--
David Harkness Sony Pictures Digital
Sr. Software Engineer 310.482.4756 [EMAIL PROTECTED]
Those who judge the value of advice by its source
will at once dismiss the best and follow the worst.
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
xdoclet-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/xdoclet-user
