Re: EOSQLQualifier replacement
Re: EOSQLQualifier replacement
- Subject: Re: EOSQLQualifier replacement
- From: Chuck Hill <email@hidden>
- Date: Fri, 17 Apr 2009 10:56:51 -0700
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