Re: How to use nvl , decode functions .

2005-03-28 Thread Jakob Braeuchi
hi chandan, ojb does not explicitely support database-functions like nvl etc. but you can use function in the expressions of a criteria: Criteria crit = new Criteria(); crit.addEqualTo("upper(productGroup.groupName)", "LIQUORS"); Query q = QueryFactory.newQuery(Article.class

How to use nvl , decode functions .

2005-03-28 Thread Chandan AHUJA
Hello , I am new to OJB , and I have following query . In OJB , using the "Criteria" class we can define the where clause . I would like to know , in OJB how can we manipulate the "fields to be selected" in the "select clause" . To be more precise how can we use functions like "nvl" and