Re: converting to java stored procs

Do it right and use each platform's strengths to their best advantage. There are significant differences with each (just look at concurrency) that unless you want performance and scalability to bite the big one, use what you are paying for to the best advantage.(or at least let the client use what the client is paying for to best advantage) Jim

-- 
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Michael Weir" <mweir_at_transres.com> wrote in message
news:YWZJa.144$oD6.4857_at_news.on.tac.net...


> Thanks for the advice.

>

> What we're actually doing is building something that has to run on MS SQL

> Server; Oracle, and DB2.  I'd like to find a way of maintaining a single

 set


> of source code that can be used to generate stored procs for each of these

> platforms.

>

> "Rauf Sarwar" <member31517_at_dbforums.com> wrote in message

> news:3027385.1056145927_at_dbforums.com...


> >

> > Originally posted by Michael Weir

> > > Is there a tool that generates java stored procs from regular

> > > stored procs?

> > > Thanks.

> >

> >

> > Just want to put this out, as mentioned here frequently, to give you

> > second thoughts on whatever I assume you are trying to do...

> >

> > 1) If you can do it in SQL then do it in SQL.

> > 2) If you can't do it in SQL then do it in PL/SQL

> > 3) If you can't do it in PL/SQL, Only then do it in Java

> >

> > Regards

> > /Rauf Sarwar

> >

> > --

> > Posted via http://dbforums.com

>

>