Kevin, Vaneet, others...,

How should I interpret this comment from
http://castor.exolab.org/jdo-faq.html then (see below). Does it not say I
can retrieve some single fields from my table? And isn't that also what
Walter is doing (Subject: problem with CALL SQL)?

*

Can I write a pass-thru OQL?

Yes. Just put "CALL SQL" in front of your SQL statement.

For example,

    OQLQuery oql = castorDb.getOQLQuery(
        "CALL SQL SELECT id, name, date "+
        "FROM user WHERE upper(name) like $1");

Be remember that the order of the fields listed must match what is defined
in the mapping file.

*

Edwin

--
****************************************************************************
This message contains information that may be privileged or confidential and
is the property of the Cap Gemini Ernst & Young Group. It is only intended
for the person to whom it is addressed. If you are not the intended
recipient, you are not authorized to read, print, retain, copy disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all copies
of this message.
****************************************************************************

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

Reply via email to