I was hoping someone could answer this question -- I would like to write a
pass-thru SQL statement that returns one column.
On the FAQ page, there is an example to create a pass-thru SQL statement
like this:
OQLQuery oql = castorDb.getOQLQuery(
"CALL SQL SELECT id, name, date "+
"FROM user WHERE upper(name) like $1");
However, when I try to do "CALL SQL select accountNo from Staff" , I get an
exception: "org.exolab.castor.jdo.QueryException: Stored procedure call must
end with "AS <class-name>".
I would like to do the pass-thru SQL because the Staff object is very large,
and it is expensive to load it in its entirety.
Thanks
-mark
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
