Thread: java in postgres?

java in postgres?

From
"shiva"
Date:
Hi,
 
   how can we use java function postgresql. In Oracle they have load java procedure which allows to load java functions,class files and jar files . any procedure in posgresql any idea...
pls comment...
 
Regards,
Shiv...
 

Re: java in postgres?

From
Bruce Momjian
Date:
shiva wrote:
> Hi,
>
>    how can we use java function postgresql. In Oracle they have load java procedure which allows to load java
functions,classfiles and jar files . any procedure in posgresql any idea... 
> pls comment...

No, we don't support this.  There is a gborg.postgresql.org project that
does this but I am not sure on its quality.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: java in postgres?

From
s0lao@netscape.net (S. L.)
Date:
shiva,

[...]
>   how can we use java function postgresql.
[...]

If you mean to use java programming language in accessing postgresql databases, then the answer is that you must use
jdbcfor connecting to the backend. Either try to compile the jdbc driver yourself or get one from
http://jdbc.postgresql.org. 

[...]
In Oracle they have load java procedure which allows to load java functions,class files and jar files . any procedure
inposgresql any idea... 
>pls comment...
[...]

If you mean a (somehow) PL/Java function loading, I'm afraid a previous post applies.

SLao

__________________________________________________________________
New! Unlimited Access from the Netscape Internet Service.
Beta test the new Netscape Internet Service for only $1.00 per month until 3/1/04.
Sign up today at http://isp.netscape.com/register
Act now to get a personalized email address!

Netscape. Just the Net You Need.

Re: java in postgres?

From
Reshat Sabiq
Date:


shiva wrote:
Hi,
 
   how can we use java function postgresql. In Oracle they have load java procedure which allows to load java functions,class files and jar files . any procedure in posgresql any idea...
pls comment...
 
Regards,
Shiv...
 
I don't think it's currently supported, but might be a good idea to consider.
I didn't know Oracle let's you use Java in its DB. Nice feature. :)
-- 
Sincerely,
Reshat.

-------------------------------------------------------------------------------------------
If you see my certificate with this message, you should be able to send me encrypted e-mail. 
Please consult your e-mail client for details if you would like to do that.
Attachment

Re: java in postgres?

From
Oliver Vecernik
Date:
shiva schrieb:

> Hi,
>
>    how can we use java function postgresql. In Oracle they have load
> java procedure which allows to load java functions,class files and jar
> files . any procedure in posgresql any idea...
> pls comment...


Hi,

there is a project on SF:

http://pljava.sourceforge.net/

but the latest news is from 12/07/2002. It seems to be not actively
developed, but I'm not sure...


Oliver