try it man and send the error make sure that mapping file is correct chao vaneet
-----Original Message----- From: Edwin van Stam [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 15:17 To: [EMAIL PROTECTED] Subject: Re: [castor-dev] Pass Thru SQL throws exception 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 ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
