Re: Java app and SPI functions

Hi Ntinos,

    You don't need to use PL/Java - you can call the SPI functions 
through standard SQL. I have C functions that return tuples and call 
them with executeQuery(...).

The function in question is defined as

CREATE TYPE correlation_type AS
(
        id INTEGER,
        num_points INTEGER,
        correlation FLOAT8
);

CREATE OR REPLACE FUNCTION
   max_min_correlation(int,smallint,smallint,int,int)
RETURNS SETOF correlation_type
AS '$libdir/contrib/my_func.so','max_min_correlation'
LANGUAGE 'C' STABLE STRICT;

and then I call it with

ResultSet results = st
                    .executeQuery("SELECT * FROM 
max_min_correlation("+var+")");

and work through the result set.

Good luck,

Adriaan

Katsaros Kwn/nos wrote:

>Hi everybody!
>
>I'm new to PostgreSQL with JDBC. What I want to do is to connect an
>already implemented Java application to my postgresql server.I want to
>be able to pass arguments from the java application to some function
>I've written in C (that uses SPI functions) and receive tuples to
>display in the Java GUI. 
>
>Any hints on where to start from? 
>
>Richard Huxton at the General list kindly pointed me to the PL/Java
>project. Is this where I should focus?
>
>Thanks in advance,
>Ntinos Katsaros
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>  
>