Re: Are java stored procedures worth it?

I have built Java classes, loaded them into Oracle, wrapped them in PL/SQL, and used them. There is an article in Java Developer, circa December 1999 that helped me greatly. If you are using JDeveloper, you can acutally deploy your classes directly into Oracle. Quite nice.

As far as performance is concerned. After doing the loading and all, the first time you call the procedure, performace was quite slow. However, after the initial load, the performace was very good. I would ask those who report sluggish performance, did they disregard the first call, and base the time measurement on the second and later calls?

There are situations where you need Java, like certain kind of data manipulation and mining. For example, we found Java classes on the internet from USGS to make coordinate transformations. These transformations would have been silly to try in PL/SQL. However, the transformations worked very well in Java/PLSQL. There were good reasons why we wanted to avoid using the classes in the middle tier, and therefore put them in the back-end.

I hope this helps,
Dave

Eoin Gardiner 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.
  Received on Fri Nov 17 2000 - 19:34:35 CST