Re: EOSQLQualifier replacement
Re: EOSQLQualifier replacement
- Subject: Re: EOSQLQualifier replacement
- From: Tom Pelaia <email@hidden>
- Date: Fri, 17 Apr 2009 14:20:14 -0400
Hi Chuck,
Thanks for the info. I will look into Wonder for an example. It seemed
to me that an Oracle Plugin inner class was handling the SQL
generation. As you mentioned, the documentation on how to create a
EOQualifier subclass is weak.
thanks,
tom
On Apr 17, 2009, at 1:56 PM, Chuck Hill wrote:
On Apr 17, 2009, at 10:27 AM, Tom Pelaia wrote:
Hi,
We are using a CLOB to store some data and I need to search on it
using the Oracle "contains" operation, but we also have several
other fields which are used to qualify the search. I am already
using EO Qualifiers to perform the search on the other parameters,
but now I see that I need something like EOSQLQualifier to handle
the CLOB. However, that class is deprecated, and the alternatives
listed don't seem to be ideal since that would require me to
rewrite the entire qualification using raw SQL. I would like to
preserve the my current qualifier architecture.
Any suggestions?
The right way to do this would be to make a custom qualifier that
generates the SQL needed. Wonder has some examples. Writing them
can be challenging due to the lack of documentation and examples
with the "why" documented. But then you can make qualifiers like:
EOQualifier qual = new OracleContainsQualifier("clobAttribute",
"some text");
Chuck
--
Chuck Hill Senior Consultant / VP Development
Come to WOWODC'09 in San Fran this June!
http://www.wocommunity.org/wowodc09/
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden