Re: Why use Java Stored Procedures....

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Sun, 05 Mar 2006 18:35:19 -0500
Message-ID: <471atuFddf0dU1@individual.net>

Jim Kennedy wrote:
> "Bob Jones" <email_at_me.not> wrote in message
> news:R5GOf.20245$2O6.19971_at_newssvr12.news.prodigy.com...

>> "HansF" <News.Hans_at_telus.net> wrote in message
>> news:pan.2006.03.04.23.59.29.686441_at_telus.net...
>>> On Sat, 04 Mar 2006 23:26:47 +0000, Bob Jones wrote:
>>>
>>>> "HansF" <News.Hans_at_telus.net> wrote in message
>>>> news:pan.2006.03.03.20.05.02.904786_at_telus.net...
>>>>> On Thu, 02 Mar 2006 00:13:49 +0000, Bob Jones wrote:
>>>>>
>>>>>> Would you rather have a Java programmer migrating Java stored
>>>>>> procedures
>>>>>> to
>>>>>> a different database or have a PL/SQL programmer migrating PL/SQL
>>>>>> stored
>>>>>> procedures to a foreign language for a different database?
>>>>> Help me out here .... which other databases use Java natively for

> Stored

>>>>> Procedures.
>>>>>
>>>>> I'm not asking which databases can interact with or be used by Java.
>>>>> Which ones allow Java to be stored and run under control of the

> database

>>>>> kernel.
>>>>>
>>>> I am not sure what you meant by "native". What makes Java a native
>>>> language
>>>> only to Oracle but not to others?
>>> OK - let's simplify.
>>>
>>> Which databases can use JAVA *STORED PROCEDURES*.  That is, procedures
>>> that are stored in the database.
>>>
>> Aside from Microsoft databases, most well-known databases support java
>> stored procedures. After all, the main benefit of Java is platform
>> independent. The more vendor support, the better it is for the technology.
>>
>>

>
> Besides Oracle who supports Java stored procedures?
> Jim
>
>

DB2 (iSeries, zSeries, and LUW),
IDS
Sybase 11 apparently does not
I didn't check Teradata

If we agree that DB2, Oracle and MS SQL Server are the big three then two of three constitutes as "most" :-)

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Received on Sun Mar 05 2006 - 17:35:19 CST