Re: Java Stored Procedures

From: David Morse <davem405_at_comcast.net>
Date: Fri, 27 Feb 2004 21:07:59 GMT
Message-ID: <OkO%b.133857$jk2.548668@attbi_s53>

FirstSQL/J uses Java as the SP language - static methods are SPs and can be called anywhere from standard SQL.

See www.firstsql.com

Dave M.
"Hawkeye" <me_at_my-deja.nospamcom> wrote in message news:iYVXb.40926$yE5.160182_at_attbi_s54...
> I am investigating the Java Stored Procedure, first to gain better
> understanding on what this is,
> and also if it would be suitable for a new project which will be running
on
> Sun One AS7
> (Client is Swing)
>
> I have spent about a day reading through many docs, mostly in Oracle site
> and also the
> past newsgroup discussions. Still, I am not clear really on who this Java
> Stored Proc
> technology is intended for. Most of the example are toy examples really.
> Any consensus on who this technology is aimed at and who should really be
> using it?
>
>
> Would you use Java Stored Proc and have it contain lots of JDBC calls
inside
> it and have it be
> called either by a client or a EJB session bean?
>
> Any info based on experience would be helpful
>
> THANKS
>
>
Received on Fri Feb 27 2004 - 15:07:59 CST