Re: Java stored procedures

From: Jeremy Russell <jeremy.russell_at_usa.net>
Date: Sat, 17 Feb 2001 21:48:40 GMT
Message-ID: <3a8ef152.175432889@news.earthlink.net>

I've no experience on DB2 but I think you'll find Java stored code slower generally than PL/SQL on 8i - it's rumored to be changing in future releases however. I guess the decision may then depend on the ability to support one set of code and also with which language you feel more comfortable.

On Tue, 6 Feb 2001 13:55:53 +0100, "kim" <kim_at_lokoy.com> wrote:

>I'm working on a product supporting both DB2 MVS V6 and Oracle 8i. In the
>Upgrading of the product we have previously used PL/SQL on Oracle and a
>Cobol program for DB2 MVS for patches that can not be written in standard
>SQL. I wondered if anyone had experience with java stored procedures on
>both platforms, whether it is a good alternative in my case. I.e. large
>amount of shared code between the two platforms, same standards on the
>platforms (SQLJ ...).
>
>Another issue is the performance of java stored procedures compared to
>PL/SQL for example..
>
>
>
Received on Sat Feb 17 2001 - 15:48:40 CST