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]