Skip to content
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

Unable to retrieve update count after result set. [JDBC390] #432

Closed
firebird-issue-importer opened this issue Apr 11, 2015 · 4 comments
Closed

Comments

@firebird-issue-importer

Submitted by: @mrotteveel

If a statement produces a result set (eg a normal select, or an UPDATE ... RETURNING), then it is impossible to get an update count; it always returns -1.

Commits: 0f590b8 955fa60 FirebirdSQL/fbt-repository@14673bd FirebirdSQL/fbt-repository@1a72cf5

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 11, 2015

Modified by: @mrotteveel

Fix Version: Jaybird 2.2.8 [ 10664 ]

Fix Version: Jaybird 3.0 [ 10440 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 12, 2015

Commented by: @mrotteveel

Changed getMoreResults and getUpdateCount logic. After executing a query that produces a result set, calling getMoreResults will allow getUpdateCount to actually return the update count where previously it always returned -1. In the same way this also allows obtaining the update count after a select query (even when executed using executeQuery). For selects this will usually be 0.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 12, 2015

Modified by: @mrotteveel

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 31, 2015

Modified by: @mrotteveel

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment