Re: Are java stored procedures worth it?

A friend of mine was contracting at a company that began its project using java stored procedures for back end processing but ported the application to pl/sql because the performance of java stored procedures was not comparible to pl/sql. That was on an 8.1.5 database and I have no doubt that performance improvements were made to the JVM in 8.1.6 and 8.1.7. 8.1.7 has the advantage that it will basically port your java code into platform independent C then compile it into platform dependent C.

In article <8v2ghl$prs$1_at_nnrp1.deja.com>,   Eoin Gardiner <eoin7_at_my-deja.com> wrote:
>
>
> I need to evaluate the use of java stored procedures, which I have
> never used before.
>
> I will be trying the examples from the Oracle Technology Network, but
 I
> also want to solicit input from people who have experience of using
> java stored procedures, via the following questions:
>
> Are there clear advantages of using java stored procedures over
> traditional PL/SQL ones?
>
> It seems that they are more complicated to build, needing a
 compilation
> in java, and a PL/SQL wrapper, whereas PL/SQL stored procedures can be
> built at a snap from a script.
> Does this make creation and maintenance much more difficult?
>
> Are there any performance gains or drops with java stored procedures
> over PL/SQL?
>
> The application under development is a web application written using
> java (including EJBs).
> Is this a reason to use java stored procedures?
> Is there a possibility of direct calls from client java to java stored
> procedures?
>
> Any feedback on your experiences greatly appreciated.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 17 2000 - 12:28:29 CST