Criteria.addSql() vs. attributes (not columns)

[St...@fws.gov]

I am using PB in 1.0.4.  I'm trying to call the Oracle Text contains() 
function in my query, so I want to end up with something like this:

select ... from table1 A0, table2 A1 where ... and 
contains(A1.description, 'something', 1);

The only way I can see to get there is by using addSql(), but I don't know 
how to get the attribute -> column mapping and the A1 alias applied - 
there is a 'description' column in both tables, so it doesn't work to just 
use addSql("contains(description, 'something', 1)).

Is there a way to accomplish this?

-steve

Steve Clark
ECOS Development Group
steve_clark@fws.gov
(970)226-9291


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org