Thanks to Bruce and Dave for your help. The answer is clear, and should be added to the faq ...
I don't know very well Jdbc : the syntax used in the select clause in the pass-thru OQL must be sql syntax ? Or is it specific jdbc driver syntax ? But may be it's the same thing ???? Sylvie. ___________________ CREDI RA Sylvie Palluel [EMAIL PROTECTED] ___________________ > -----Message d'origine----- > De�: Bruce Snyder [mailto:[EMAIL PROTECTED] > Envoy�: mercredi 11 juin 2003 22:39 > ��: [EMAIL PROTECTED] > Objet�: Re: [castor-dev] How to use pass-through SQL ? > > This one time, at band camp, Dave Keller said: > > DK>That answers the question if you can use it but not why one would use > DK>it. I posted a similar question last week about pass thru SQL but > DK>never got any responses. I think the main issue is that if Castor > DK>writes the SQL for you, why would you want to make an explicit SQL > call? > DK> What purpose does it serve and under what conditions would I want to > DK>use a pass thru SQL call instead on relying on Castor to create the > DK>statements for me? > > Dave, > > My apologies for missing your post. I certainly would have replied. > > Using pass-through SQL is something that should only be used in certain > situations. I remember seeing some code from a Castor user that *only* > used pass-through SQL. What a bad idea! This completely undermines > Castor's job. Anyway, a very good question. I thought about this same > thing as I answered the original question. Castor's pass-through SQL is > really only to be used for very specialized situations. > > Here are a few examples: > > - At my day job, the software i work on uses Oracle Spatial. Querying > geodetic data is 1) not something that is implemented in Castor's > OQL > Engine, and 2) highly tunable using SQL. > > - If you need to tune a query in a very database specific manner, > you might want to use the pass-through SQL. Think Oracle hints > for this one. > > - Batch statements, dropping/creating indexes, trunating tables, etc., > etc. > > 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
