pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Invoking sql functions through jdbc 3+ messages / 3 participants [nested] [flat]
* Invoking sql functions through jdbc @ 2001-01-26 03:57 Ron Sofrin <rsofrin@entercept.com> 0 siblings, 2 replies; 3+ messages in thread From: Ron Sofrin @ 2001-01-26 03:57 UTC (permalink / raw) To: pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Invoking sql functions through jdbc @ 2001-01-27 03:04 Greg Speegle <Greg@10happythings.com> parent: Ron Sofrin <rsofrin@entercept.com> 1 sibling, 0 replies; 3+ messages in thread From: Greg Speegle @ 2001-01-27 03:04 UTC (permalink / raw) To: Ron Sofrin <rsofrin@entercept.com>; +Cc: pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Invoking sql functions through jdbc @ 2001-01-27 12:00 Peter Mount <peter@retep.org.uk> parent: Ron Sofrin <rsofrin@entercept.com> 1 sibling, 0 replies; 3+ messages in thread From: Peter Mount @ 2001-01-27 12:00 UTC (permalink / raw) To: Greg Speegle <Greg@10happythings.com>; Ron Sofrin <rsofrin@entercept.com>; +Cc: pgsql-interfaces; pgsql-jdbc@postgresql.org 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-01-27 12:00 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-01-26 03:57 Invoking sql functions through jdbc Ron Sofrin <rsofrin@entercept.com> 2001-01-27 03:04 ` Greg Speegle <Greg@10happythings.com> 2001-01-27 12:00 ` Peter Mount <peter@retep.org.uk>
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