Thread: Java application and SPI...(?)

Java application and SPI...(?)

From
"Katsaros Kwn/nos"
Date:
Hi everybody,
 
Is there any way to connect a Java application to user defined functions (which use SPI)?
I have an already implemented Java app that I want to use in order to pass arguments to my functions and receive results (e.g. tuples).
I'm thinking of JNI and/or JDBC but I haven't reached a conclusion yet on whether it can help me do the job.
 
I'm a little confused. Any suggestions?
 
Regards,
Ntinos Kataros

Re: Java application and SPI...(?)

From
Richard Huxton
Date:
Katsaros Kwn/nos wrote:
> Hi everybody,
>
> Is there any way to connect a Java application to user defined functions (which use SPI)?
> I have an already implemented Java app that I want to use in order to pass arguments to my functions and receive
results(e.g. tuples). 
> I'm thinking of JNI and/or JDBC but I haven't reached a conclusion yet on whether it can help me do the job.
>
> I'm a little confused. Any suggestions?

PL/Java might be a good place to start
   http://gborg.postgresql.org/project/pljava/projdisplay.php

Also there is a java/jdbc mailing list that might be a good place to
discuss this.
--
   Richard Huxton
   Archonet Ltd