New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Processing and closing the ResultSet from callable statement and then using the getters throws NullPointerException [JDBC350] #167
Comments
Modified by: @mrotteveelAttachment: SO20140427.java [ 12503 ] |
Modified by: @mrotteveel |
Modified by: @mrotteveel |
Modified by: @mrotteveelVersion: Jaybird 2.2.6 [ 10588 ] Version: Jaybird 2.2.5 [ 10582 ] => Version: Jaybird 2.2.4 [ 10531 ] => Version: Jaybird 2.2.3 [ 10510 ] => Version: Jaybird 2.2.2 [ 10480 ] => Version: Jaybird 2.2.1 [ 10474 ] => Version: Jaybird 2.2 [ 10053 ] => Version: Jaybird 2.1.6 [ 10285 ] => |
Modified by: @mrotteveelVersion: Jaybird 2.2.5 [ 10582 ] Version: Jaybird 2.2.4 [ 10531 ] Version: Jaybird 2.2.3 [ 10510 ] Version: Jaybird 2.2.2 [ 10480 ] Version: Jaybird 2.2.1 [ 10474 ] Version: Jaybird 2.2 [ 10053 ] Version: Jaybird 2.1.6 [ 10285 ] Fix Version: Jaybird 2.2.6 [ 10588 ] Version: Jaybird 2.2.6 [ 10588 ] => |
Modified by: @mrotteveel |
Commented by: Lukas Eder (lukas.eder) While implementing routine support in jOOQ, I've run into this issue as well. This would be a very helpful fix. |
Modified by: @mrotteveelFix Version: Jaybird 3.0 [ 10440 ] |
Commented by: @mrotteveel Made two changes: For selectable procedures everything continues to work as is, except now trying to use an accessor after processing the result set will not produce a NullPointerException, but an SQLException that the result is closed. NOTE Being able to obtain a ResultSet for an executable procedure, and use the accessors for a selectable procedure is actually invalid behavior, but for backwards compatibility we leave that as it is for now (might change in JDBC297). |
Modified by: @mrotteveelstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @mrotteveel |
Submitted by: @mrotteveel
Is related to JDBC297
Is related to JDBC229
Is related to JDBC357
Relate to JDBC381
Attachments:
SO20140427.java
Votes: 1
When an executable stored procedure is processed by first reading the ResultSet and then using the getters on CallableStatement (as for example Spring SimpleJdbcCall does), then the getter will throw a NullPointerException.
See the attached file and http://stackoverflow.com/questions/23238260/simplejdbccall-nullpointerexception-on-firebird-db for an example of this problem.
See also JDBC297 and JDBC229
Commits: 0dd2b00 cadcfc3 FirebirdSQL/fbt-repository@448e08d FirebirdSQL/fbt-repository@51a2fd8
The text was updated successfully, but these errors were encountered: