If I accidently delete something from the castor Wiki is it gone forever?
> -----Original Message-----
> From: tek1 [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2003 1:24 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [castor-dev] How to use pass-through SQL ?
>
>
> 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
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
