Re: MySQL Gets Functions in Java - Enlightenment Please

From: "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com>
To: "Tony (Unihost)" <tony(at)unihost(dot)net>
Cc: johnsw(at)wardbrook(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: MySQL Gets Functions in Java - Enlightenment Please
Date: 2003-12-20 12:11:45
Message-ID: 2329.192.168.0.64.1071922305.squirrel@mercury.wardbrook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry but I don't know what would be supported. Perhaps someone else can
provide more info.

Here is a document from Oracle detailing their java stored procedure support:

http://otn.oracle.com/tech/java/jroadmap/jsproc/listing.htm#998299

Hope that helps.

John

Tony (Unihost) said:
> Does this include ALL the functionality of Java? Objects, Polymorphism,
> Inheritance, or is it just a subset?
>
> T.
>
>
> John Sidney-Woollett wrote:
>
>>It means that you can create stored procedures/functions which reside in
>>the database that are written in java (as opposed to the native SQL
>>programming language).
>>
>>Why would you want this? If you were more familiar with java than any of
>>the currently supported procedural languages, then it means that you
>> don't
>>necessarily have to get to grips with another programming language.
>>
>>This would be a "nice to have" for Postgres too - I believe that it
>>supports PL/pgSQL, PL/Tcl, PL/Perl, and PL/Python at present.
>>
>>Oracle also offers the ability to write stored procedures in java.
>>
>>It's funny, even though I program in java all the time, I still write my
>>procedures in the SQL programming language (PL/pgSQL). Even if the java
>>language were available for Postgres, I'm not sure I would use it...
>>
>>John Sidney-Woollett
>>
>>Tony (Unihost) said:
>>
>>
>>>Can someone a little more clever than I (which means just about anyone
>>>on this list) tell me what the implications/benefits are of this are
>>>please?
>>>
>>>http://developers.slashdot.org/developers/03/12/19/1628241.shtml?tid=108&tid=126&tid=137&tid=156&tid=198
>>>
>>>Cheers
>>>
>>>T.
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 2: you can get off all lists at once with the unregister command
>>> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>>>
>>>
>>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-12-20 13:05:17 Re: MySQL Gets Functions in Java - Enlightenment Please
Previous Message Tony (Unihost) 2003-12-20 11:27:06 Re: MySQL Gets Functions in Java - Enlightenment Please