Re: [castor-dev] How to use pass-through SQL ?

[tek1]

Sylvie, can you please add the solution to the CastorWIKI?  (Anyone can 
edit it!) :)

http://www.brainopolis.com/castorwiki/Wiki.jsp?page=Main

Thanks!



At 07:56 03/06/12 +0200, you wrote:
>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

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev