Functions returning SETs and CallableStatment Interface

From: Thomas Hill <Thomas(dot)K(dot)Hill(at)t-online(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Functions returning SETs and CallableStatment Interface
Date: 2015-08-22 16:25:38
Message-ID: 55D8A282.4080709@t-online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2015-08-22 23:22:31 Re: sql type reported for enum
Previous Message rcohen 2015-08-21 17:03:47 Re: sql type reported for enum