|
Hi Scott,
Here at Pro-Concept Inc., Oracle is our "core" database and i can tell you that it's possible for Oracle to search "like" queries in CLOB. If you have a Oracle DB on hand, try this : 1) create table my_table_with_clob ( 2) insert some rows in this table 3) issue following statement against this table : select * from my_table_with_clob where my_clob_column like 'wathever you want%' 4) should you see the rows containing the searched value. FYI : here at Pro-Concept we run Oracle 9.2.0.1 through 9.2.0.6 and Oracle 10g and like "queries" on clob work very well Cheers, Fixing description - it's exact matches which fail, not 'like' queries.
|
||||||||||||||||||||||||||||||||||||||||||||||||
http://jakarta.apache.org/commons/dbcp/configuration.html