Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

; pgsql-general@postgresql.org; Kris Jurka Asunto: Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA >As I understand, it's all what you need, isn't you Ideally I would like to see a pull request at https://github.com/pgjdbc/pgjdbc/pulls, however your cod

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

drian Klaver; pgsql-j...@postgresql.org; pgsql-general@postgresql.org; Kris Jurka Asunto: Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA On Fri, Dec 11, 2015 at 2:11 PM, Corradini, Carlos wrote: > with your and Mr. Kevin explanations, the Java program have worked &g

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

n Klaver; pgsql-j...@postgresql.org; pgsql-general@postgresql.org; Kris Jurka Asunto: Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA On Fri, Dec 11, 2015 at 2:11 PM, Corradini, Carlos wrote: > with your and Mr. Kevin explanations, the Java program have worke

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

date) TO ro_dw_bsc_sys_adm; One more thing, I am a DBA ORACLE and not a Developer, please, excuse me if I made "horrors" in the programming, I promise to be more effective next time ! As I understand, it's all what you need, isn't you -Mensaje original- De: V

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

diciembre de 2015 12:27 p.m. Para: Corradini, Carlos; pgsql-j...@postgresql.org; pgsql-general@postgresql.org CC: bo...@ejurka.com Asunto: Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA On 12/11/2015 07:10 AM, Corradini, Carlos wrote: > Mr. Adrian, first let me say m

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

>Ok. I understand, to put there a pull request, I must to register into this >webpage ?? Exactly. Vladimir -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

>As I understand, it's all what you need, isn't you Ideally I would like to see a pull request at https://github.com/pgjdbc/pgjdbc/pulls, however your code seems to be good enough so somebody else can pick it up, simplify a bit, and file a PR. Vladimir -- Sent via pgsql-general mailing lis

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

> I hope I have been the most clear as my poor level of English could be.. It would be great if you could express that in java + sql as well, so the exact code can be added to JDBC driver test suite as a regression test. Vladimir -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

On Fri, Dec 11, 2015 at 2:11 PM, Corradini, Carlos wrote: > with your and Mr. Kevin explanations, the Java > program have worked fine and have printed the data obtained from a two > cursors inside a PostgreSQL Database Stored Function. > > Then, I can confirm that this version of DB ( 9.4 ) use t

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

a.m. Para: Corradini, Carlos; pgsql-j...@postgresql.org; pgsql-general@postgresql.org CC: bo...@ejurka.com Asunto: Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA On 12/11/2015 04:56 AM, Corradini, Carlos wrote: > Mr. Adrian, here i transcribe the code of the function

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

; select * from dw_bsc.proc_perspectives('R', 1, null, null, null, null, null); fetch all from ""; end; inside the query gui tool provided by pgAdmin III The connection into the java application was changed to con.setAutoCommit(false); I think I do not forget nothing else Some h

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

rlos; pgsql-j...@postgresql.org; pgsql-general@postgresql.org CC: bo...@ejurka.com Asunto: Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA On 12/10/2015 05:38 AM, Corradini, Carlos wrote: Dear Gurus : First let me say hello from Buenos Aires, Arge

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

Some help will be appreciated very, very, very much ! -Mensaje original- De: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Enviado el: jueves, 10 de diciembre de 2015 06:25 p.m. Para: Corradini, Carlos; pgsql-j...@postgresql.org; pgsql-general@postgresql.org CC: bo...@ejurka.com Asunt

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

On Thu, Dec 10, 2015 at 7:38 AM, Corradini, Carlos wrote: > I have a Java application that must read a > data provided by two ( 2 ) cursors returned by a function stored in a > database. I know to retrieve data if the function have one ( 1 ) cursor, but > with two I can’t. I will very pleased if

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

On 12/10/2015 05:38 AM, Corradini, Carlos wrote: Dear Gurus : First let me say hello from Buenos Aires, Argentina. I took this emails addresses from internet ( page www.postgresql.org ) Now I will try to explain which is my problem (

[GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA

Dear Gurus : First let me say hello from Buenos Aires, Argentina. I took this emails addresses from internet ( page www.postgresql.org ) Now I will try to explain which is my problem ( excuse my poor level of English, please ). I have a Java application that

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor

Hi Kris, I use this the code found here. http://www.postgresql.org/docs/7.4/interactive/jdbc-callproc.html But I don't think there is a way to make it work with SETOF RefCursor. I will try your code wich seem to work. SQL STRING: ? = call usp_Comptabilite_JournalVentes (?, ?, ?, ?, ? )

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor AS. How

On Thu, 24 Mar 2005, David Gagnon wrote: > Hi Kris, > >I don't get error with the rsTmp.close() statement but with " > (rsTmp.next()) ". The arraycopy is because I want to shrink the > original array (size 50) to it real size. It's not intended to be a > deep copy. Right, my bad. I

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor AS. How to

Hi Kris, I don't get error with the rsTmp.close() statement but with " (rsTmp.next()) ". The arraycopy is because I want to shrink the original array (size 50) to it real size. It's not intended to be a deep copy. Plpgsql function can return multiple refcursor .. so the question is how

Re: [GENERAL] [JDBC] plpgsql function with RETURNS SETOF refcursor AS. How

On Thu, 24 Mar 2005, David Gagnon wrote: > I'm already able to get Refcursor from a stored procedure. But now I > need to get a SETOF refcursor and I can't make it work... Is that > possible to do this via JDBC? > > He is the code I did. The rsTmp.next() throws a Connection is > closed