Re: Why use Java Stored Procedures....

From: Bob Jones <email_at_me.not>
Date: Mon, 06 Mar 2006 00:34:01 GMT
Message-ID: <ZrLOf.39805$F_3.22821@newssvr29.news.prodigy.net>

"Serge Rielau" <srielau_at_ca.ibm.com> wrote in message news:471atuFddf0dU1_at_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" :-)

>

PostgreSQL and Cloudscape, if I may add. Received on Sun Mar 05 2006 - 18:34:01 CST