From: | "Guy Rouillier" <guyr(at)masergy(dot)com> |
---|---|
To: | "PostgreSQL Interfaces" <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | JDBC support for CALL / PERFORM |
Date: | 2006-02-13 22:11:47 |
Message-ID: | CC1CF380F4D70844B01D45982E671B230137A6C0@mtxexch01.add0.masergy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-jdbc |
I have some Java code that I'm trying to convert from Oracle to PG.
This code uses the JDBC batch functionality to submit batches of stored
procedures invocations using the "call" syntax. I implemented the same
stored functions in PG, having them return void. I converted the batch
statements to use "select" with these stored functions. Even though the
stored functions return void, the select is still producing a result
set, and JDBC does not allow results with batches.
I'd like to take a crack at adding CALL (for Oracle and general JDBC
compatibility) and/or PERFORM (for PL/SQL compatibility) to the JDBC
driver. My approach would be to simply substitute SELECT, then discard
the result set upon completion.
Is this approach feasible? Is this change acceptable?
--
Guy Rouillier
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2006-02-13 23:02:42 | Re: JDBC support for CALL / PERFORM |
Previous Message | Eric Chapdelaine | 2006-02-13 22:07:43 | libpq - Unhandled Exception - Executing Samples under win32 |
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2006-02-13 23:02:42 | Re: JDBC support for CALL / PERFORM |
Previous Message | Kris Jurka | 2006-02-13 16:44:09 | Re: Pb with Spring & Metadat |