Re: MySQL Gets Functions in Java - Enlightenment Please - Mailing list pgsql-general

From John Sidney-Woollett
Subject Re: MySQL Gets Functions in Java - Enlightenment Please
Date
Msg-id 2329.192.168.0.64.1071922305.squirrel@mercury.wardbrook.com
Whole thread Raw
In response to Re: MySQL Gets Functions in Java - Enlightenment Please  ("Tony (Unihost)" <tony@unihost.net>)
List 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@postgresql.org)
>>>
>>>
>>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>>
>


pgsql-general by date:

Previous
From: "Tony (Unihost)"
Date:
Subject: Re: MySQL Gets Functions in Java - Enlightenment Please
Next
From: Nilabhra Banerjee
Date:
Subject: Re: BLOBS : how to remove them totally