Обсуждение: Functions returning SETs and CallableStatment Interface
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
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
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
Hi Thomas,
Not really, stored procedures in postgresql aren't really stored procedures rather functions and are called by doing select funcname() ...
Dave
On 22 August 2015 at 12:25, Thomas Hill <Thomas.K.Hill@t-online.de> wrote:
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 theCallableStatement
interface, but instead should use the normalStatement
orPreparedStatement
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