From: | Greg Speegle <Greg(at)10happythings(dot)com> |
---|---|
To: | Ron Sofrin <rsofrin(at)entercept(dot)com> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: Invoking sql functions through jdbc |
Date: | 2001-01-27 03:04:09 |
Message-ID: | 20010127.3040903@gregs.wireless.calpha.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Maurizio | 2001-01-27 07:03:18 | Re: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG |
Previous Message | Bruce Momjian | 2001-01-26 21:35:15 | Re: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2001-01-27 12:00:42 | Re: Invoking sql functions through jdbc |
Previous Message | Barry Lind | 2001-01-26 23:37:50 | Re: [BUGS] no way in LargeObject API to detect short read? |