[castor-dev] How to do a simple MAX(column) query?

[Bart Jenkins]

Ok,
  How do you do a simple query like "select max(id) from mytable"?

I have:

  db.getOQLQuery( "CALL SQL SELECT max(m_product_id) FROM M_PRODUCT AS
java.lang.Integer");

and I keep getting an exception saying:

  org.exolab.castor.jdo.QueryException: Could not find an engine supporting
class java.lang.Integer

I get the same when I substitute "java.lang.Integer" with "int" or "String"
or anything...

I FINALLY figured out that I can do:

  db.getOQLQuery( "SELECT max(p.id) FROM Product p");

and get the number as an Integer by doing:

  QueryResults = maxProdIDResults = maxProdOQL.execute();      //execute the
query
  maxProdID = new Integer(maxProdIDResults.next().toString());//retrieve the
MAX of column m_product_id

What a hassle.  Why doesn't the passthrough query work?

Bart Jenkins

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev