Hello all

I asked this question a while back but got no response - is there any way of 
creating a Java stored procedure in a postgres database ? I can see that 
there is a built-in PL/sql type of environment and a python one but it would  
be nice if I could migrate Java stored procedures in an Oracle database into  
postgres.

Any comments?

Chris

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com

25 Oct 2001 09:46:58 -0500
tweekie <None@news.tht.net>
java virtual machine
--- tweekie <None@news.tht.net> wrote:
> I asked this question a while back but got no response - is there any way of 
> creating a Java stored procedure in a postgres database ?

AFAIR, there was an answer to your question by Bruce,
and it was that PostgreSQL does not support Java 
as a PL. The only languages are PL/pgSQL, PL/Python,
PL/Perl and PL/TCL if I'm not mistaken.

> I can see that 
> there is a built-in PL/sql type of environment and a python one but it would  
> be nice if I could migrate Java stored procedures in an Oracle database into  
> postgres.
> Any comments?

Write PL/Java one day :)

-s

__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com

Thu, 25 Oct 2001 12:19:29 -0700 (PDT)
Serguei Mokhov <serguei_mokhov@yahoo.com>
Re: java virtual machine
* tweekie <None@news.tht.net> wrote:
|
| I asked this question a while back but got no response - is there any way of 
| creating a Java stored procedure in a postgres database ? I can see that 
| there is a built-in PL/sql type of environment and a python one but it would  
| be nice if I could migrate Java stored procedures in an Oracle database into  
| postgres.
| 
| Any comments?


It would rock ;-) An Hungarian guy just sent a mail indicating that he
had a first prototype version of something with Kaffe up and running.
But I believe there is a lot of issues to be solved, especially
threading issues...

-- 
Gunnar Rï¿½nning - gunnar@polygnosis.com
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/

26 Oct 2001 03:05:49 +0200
Gunnar =?iso-8859-1?q?R=F8nning?= <gunnar@polygnosis.com>
Re: java virtual machine
> > I asked this question a while back but got no response - is there any way of 
> > creating a Java stored procedure in a postgres database ?
> 
> AFAIR, there was an answer to your question by Bruce,
> and it was that PostgreSQL does not support Java 
> as a PL. The only languages are PL/pgSQL, PL/Python,
> PL/Perl and PL/TCL if I'm not mistaken.

PL/Ruby too.  ;)

> > I can see that 
> > there is a built-in PL/sql type of environment and a python one but it would  
> > be nice if I could migrate Java stored procedures in an Oracle database into  
> > postgres.
> > Any comments?
> 
> Write PL/Java one day :)

::shudder::  -sc

Mon, 29 Oct 2001 21:52:21 -0800
Sean Chittenden <sean@chittenden.org>
Re: java virtual machine