Dear Castor developers,
I'm trying to retrieve one field from my table. I understand that I cannot
do that using plain OQL but need to write a SQL Pass Thru query. So I write:
> OQLQuery qry = db.getOQLQuery("CALL SQL SELECT firstName FROM T_USER");
But when executing I get the following exception:
> org.exolab.castor.jdo.QueryException: Stored procedure call must end with
"AS <class-name>"
When retrieving a complete row this is understandable, but I'm retrieving
one field only. Judged by other messages in this mailing list, other people
do not seem to have this problem.
Could anyone tell me what I am missing here?
Thanks,
Edwin van Stam
--
****************************************************************************
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