[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] QueryByExamplePolicy not being used on a ReadAllQuery
|
The code looks correct. What is the SQL generated? Is you String value
null?
You might want to try the same on EclipseLink, to see if it still occurs
(note, this is the EclipseLink forum, not TopLink Essentials).
nickgoodman wrote:
>
>
> I've got some code that appears to correctly use a QueryByExamplePolicy;
> however, when I look at the SQL generated via TopLink Essentials (I'm
> using WebLogic 10.3), I see it using equals instead of like for the
> comparison of attributes in the example object (the result set is clearly
> the equals query and not the like query). The following code is what's
> being executed:
>
>
> /* searchPImpl has one field set to a value like "test%", and I want it to
> pickup values such as "test1", "test", "test 23", et cetera */
>
> QueryByExamplePolicy policy = new QueryByExamplePolicy();
> policy.addSpecialOperation(String.class, "like");
> policy.addSpecialOperation(Integer.class, "equal");
>
> ReadAllQuery raq = new ReadAllQuery();
> raq.setExampleObject(searchPImpl);
> raq.setReferenceClass(searchPImpl.getClass());
> raq.setQueryByExamplePolicy(policy);
>
>
> ClientSession cs = getClientSession();
> ArrayList arrayList = new ArrayList((Vector) cs.executeQuery(raq));
>
>
-----
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland
http://www.eclipse.org/eclipselink/
EclipseLink , http://www.oracle.com/technology/products/ias/toplink/
TopLink
Wiki: http://wiki.eclipse.org/EclipseLink EclipseLink ,
http://wiki.oracle.com/page/TopLink TopLink
Forums: http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink ,
http://www.nabble.com/EclipseLink-f26430.html EclipseLink
Book: http://en.wikibooks.org/wiki/Java_Persistence Java Persistence
--
View this message in context: http://www.nabble.com/QueryByExamplePolicy-not-being-used-on-a-ReadAllQuery-tp25647908p25664455.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.