hi michael,
try using addSql:
Query query;
Criteria crit;
crit = new Criteria();
crit.addEqualTo(boss, new Boolean(true));
crit.addSql(upper( name) like '%ER');
query = new QueryByCriteria(Person.class, crit);
broker.getCollectionByQuery(query);
hth
jakob
Michael Schulze wrote:
Hello,
I use OJB with the PB API and DB2.
I want to add FETCH x ROWS ONLY to a query to limit the number of rows
returned (I know i could do this with setEndAtIndex(x) too, but FETCH x
ROWS ONLY is faster).
What is missing is an addSql() method on the query to add free form sql
to the query the same way addOrderBy()... works. There is auch a
addSql() method for criteria.
Is there any reason why i can't add free form sql to a query, or is
there some other way to do this ?
Thanks,
Michael
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]