PgCallableStatement registerOutParameter for PROCEDURE not ready #1545
Comments
|
Given that procedures currently cannot be used inside transactions we are wondering what anyone would actually use them for ? |
|
Thanks your comments. I added one test case patch. You can look the test case to find my usage. |
|
Add my crack to PgCallableStatement.java can work fine. But that ONLY for test my usage, NOT correct patch!!! Put here. |
gregn123
added a commit
to gregn123/pgjdbc
that referenced
this issue
Sep 5, 2019
…tive CALL
Currently, using CallableStatement, the PGJDBC driver will allow invocation of procedures using
the native "call myproc(...)" syntax, provided the procedure only has IN parameters or no
parameters.
However, if the procedure has any INOUT parameters, then an attempt to invoke the
CallableStatement's registerOutParameter() method, which is required in order to register the OUT
part of the INOUT parameter, will fail with the following error:
This statement does not declare an OUT parameter. Use { ?= call ... } to declare one.
This fixes issue: pgjdbc#1545
davecramer
pushed a commit
that referenced
this issue
Nov 26, 2019
…tive CALL (#1561) Currently, using CallableStatement, the PGJDBC driver will allow invocation of procedures using the native "call myproc(...)" syntax, provided the procedure only has IN parameters or no parameters. However, if the procedure has any INOUT parameters, then an attempt to invoke the CallableStatement's registerOutParameter() method, which is required in order to register the OUT part of the INOUT parameter, will fail with the following error: This statement does not declare an OUT parameter. Use { ?= call ... } to declare one. This fixes issue: #1545
|
closed by #1561 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Class PgCallableStatement registerOutParameter for PROCEDURE not ready, that ONLY for function now.
In Postgresql 11 PROCEDURE is ready. But isFunction in class PgCallableStatement limited registerOutParameter ONLY for fuction. Should update the class PgCallableStatement for Postgresql 11 PROCEDURE.
Driver Version 42.2.7
Java Version JDK 8
OS Version openSuSE 15.0
PostgreSQL Version 11.5
To Reproduce
PgConnection.prepareCall("CALL clone_mozilla_send(?, ?)")
CallableStatement.registerOutParameter(1,..
CallableStatement.registerOutParameter(2,..
Expected behaviour
This statement does not declare an OUT parameter. Use '{' ?= call ... '}' to declare one.
Logs
This statement does not declare an OUT parameter. Use '{' ?= call ... '}' to declare one.
And I crack the class PgCallableStatement with remove isFunction condition, I can get out value use CallableStatement.getXXX.
The text was updated successfully, but these errors were encountered: