From: Greg Speegle <Greg@10happythings.com>
To: Ron Sofrin <rsofrin@entercept.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Invoking sql functions through jdbc
Date: Sat, 27 Jan 2001 03:04:09 GMT
Message-ID: <20010127.3040903@gregs.wireless.calpha.com> (raw)
In-Reply-To: <94qsgr$aac$1@news.tht.net>
References: <94qsgr$aac$1@news.tht.net>
Hi Ron,
You can call postgresql functions from a normal statement, although I
don't know if you can have it return multiple result sets.
I've assigned a class project to a graduate database class to work on the
CallableStatment interface for the JDBC driver. I hope we'll have
something for you by May.
Greg Speegle
Baylor University
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 1/25/01, 9:57:32 PM, "Ron Sofrin" <rsofrin@entercept.com> wrote
regarding [INTERFACES] Invoking sql functions through jdbc:
> Hi all,
> I am trying to invoke a postgres sql function though JDBC using the
> CallableStatment object. I have build the driver with it's jdbc1.2
option.
> However, I am getting the following exception "Callable statments are not
> supported at this time"
> Does any one have an idea if there is a work around it?
> I have noticed that there is something called the Fastpath API. Is there
any
> way to get a result set (and not byte[]) out of it?
> thanks
> Ron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: Greg@10happythings.com, rsofrin@entercept.com
Subject: Re: Invoking sql functions through jdbc
In-Reply-To: <20010127.3040903@gregs.wireless.calpha.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox