Re: Java Stored Procedures

My experience with JSPs is that JDBC calls to the databse are about 3.5X slower than the same SQL implemented in PL/SQL. Oracle Support confirmed that these numbers are what you should expect when running a side by side test between PL/SQL and JSPs. If you are going to write SQL code that will need to perform optimally, JSPs may not be the answer. If your code does not perform SQL or the overhead of the JDBC call is acceptable, then java makes a lot of sense.

"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 Tue Feb 17 2004 - 01:08:00 CET