Обсуждение: 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

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

At 03:04 27/01/01 +0000, Greg Speegle wrote:

>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.

The network protocol supports it, and so should Statement/Prepared
statement. However, I've never got it to actually do it.

PS: All JDBC related stuff should be going to the new pgsql-jdbc list.

Peter


>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