Skip site navigation (1) Skip section navigation (2)

Re: Java app and SPI functions

From: Adriaan Joubert <a(dot)joubert(at)albourne(dot)com>
To: Katsaros Kwn/nos <ntinos(at)aueb(dot)gr>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Java app and SPI functions
Date: 2004-09-30 13:28:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
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

RETURNS SETOF correlation_type
AS '$libdir/contrib/','max_min_correlation'

and then I call it with

ResultSet results = st
                    .executeQuery("SELECT * FROM 

and work through the result set.

Good luck,


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(at)postgresql(dot)org

Attachment: a.joubert.vcf
Description: text/x-vcard (288 bytes)

In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2004-09-30 21:55:14
Subject: Re: Remote query very slow
Previous:From: Katsaros Kwn/nosDate: 2004-09-30 12:16:44
Subject: Java app and SPI functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group