JDBC support for CALL / PERFORM
| От | Guy Rouillier |
|---|---|
| Тема | JDBC support for CALL / PERFORM |
| Дата | |
| Msg-id | CC1CF380F4D70844B01D45982E671B230137A6C0@mtxexch01.add0.masergy.com обсуждение исходный текст |
| Ответы |
Re: JDBC support for CALL / PERFORM
|
| Список | pgsql-interfaces |
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
В списке pgsql-interfaces по дате отправления: