Functions returning SETs and CallableStatment Interface - Mailing list pgsql-jdbc

From Thomas Hill
Subject Functions returning SETs and CallableStatment Interface
Date
Msg-id 55D8A282.4080709@t-online.de
Whole thread Raw
Responses Re: Functions returning SETs and CallableStatment Interface  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Hi,

I would like a Java program that can be run in conjunction with an Apache Database Server and an Oracle server to also run using postgresql as backend. The program is using stored procedures and the callableStatement interface for "all" database communication.

If I understand the following statement from the documentation correctly, this means my code will not work when dealing with stored procedures returning restultsets.
"Functions that return data as a set should not be called via the CallableStatement interface, but instead should use the normal Statement or PreparedStatement interfaces."

So I was wondering if there are any plans for an implementation that allows using the callableStatement interface also for functions returning sets?

Thanks
Thomas

pgsql-jdbc by date:

Previous
From: rcohen@e1b.org
Date:
Subject: Re: sql type reported for enum
Next
From: Dave Cramer
Date:
Subject: Re: sql type reported for enum