Hello,
Here's the Faq I saw before :
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 AS myapp.Product");
Be remember that the order of the fields listed must match what is
defined in the mapping file.
But what I don't understand, is the AS clause ...
What is this class? I've seen in differents messages that it must be
mapped ... ok ... but map whit which table ????
Sylvie.
___________________
CREDI RA
Sylvie Palluel
[EMAIL PROTECTED]
___________________
> -----Message d'origine-----
> De�: Bruce Snyder [mailto:[EMAIL PROTECTED]
> Envoy�: mercredi 11 juin 2003 20:09
> ��: [EMAIL PROTECTED]
> Objet�: Re: [castor-dev] How to use pass-through SQL ?
>
> This one time, at band camp, PALLUEL Sylvie said:
>
> PS>I don't understand how to use pass-through SQL ...
>
> Sylvie,
>
> Please see the question titled, 'Can I write a pass-thru OQL?' in the
> JDO FAQ here:
>
> http://www.castor.org/jdo-faq.html#OQL
>
> Bruce
> --
> perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-
> O;0\`\`");'
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
