Hello Bruce,
Thanks for your answer.
About pass-thru OQL, I did'nt understand exactly the syntax :
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� : jeudi 12 juin 2003 21:14
> � : [EMAIL PROTECTED]
> Objet : Re: [castor-dev] How to use pass-through SQL ?
>
>
> This one time, at band camp, PALLUEL Sylvie said:
>
> PS>Thanks to Bruce and Dave for your help.
> PS>
> PS>The answer is clear, and should be added to the faq ...
> PS>
> PS>I don't know very well Jdbc : the syntax used in the
> select clause in
> PS>the pass-thru OQL must be sql syntax ? Or is it specific
> jdbc driver
> PS>syntax ? But may be it's the same thing ????
>
> There is actually a note already in the JDO FAQ right below
> the pass-thru OQL question stating the following:
>
> 'Be remember that the order of the fields listed must
> match what is
> defined in the mapping file.'
>
> Obviously there's a typo there, but the info is there nonetheless.
>
> In answer to the questions above, the syntax in pass-thru SQL
> is SQL. It could potentially be specific to the database
> being used. That is determined by you and how you write the SQL.
>
> 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
