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
>>
>>
>
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 |