Re: Invoking sql functions through jdbc

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