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

Jump to bottom

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

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

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

firebird-automations opened this issue Apr 11, 2015 · 4 comments
Assignees
@mrotteveel
Labels
affect-version: Jaybird 2.2 affect-version: Jaybird 2.2.1 affect-version: Jaybird 2.2.2 affect-version: Jaybird 2.2.3 affect-version: Jaybird 2.2.4 affect-version: Jaybird 2.2.5 affect-version: Jaybird 2.2.6 affect-version: Jaybird 2.2.7 component: jdbc driver fix-version: Jaybird 2.2.8 fix-version: Jaybird 3.0.0 priority: minor resolution: fixed type: bug

Comments

@firebird-automations
Copy link

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-automations
Copy link
Author

Modified by: @mrotteveel

Fix Version: Jaybird 2.2.8 [ 10664 ]

Fix Version: Jaybird 3.0 [ 10440 ]

@firebird-automations
Copy link
Author

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-automations
Copy link
Author

Modified by: @mrotteveel

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Author

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
Assignees

@mrotteveel mrotteveel

Labels
affect-version: Jaybird 2.2 affect-version: Jaybird 2.2.1 affect-version: Jaybird 2.2.2 affect-version: Jaybird 2.2.3 affect-version: Jaybird 2.2.4 affect-version: Jaybird 2.2.5 affect-version: Jaybird 2.2.6 affect-version: Jaybird 2.2.7 component: jdbc driver fix-version: Jaybird 2.2.8 fix-version: Jaybird 3.0.0 priority: minor resolution: fixed type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mrotteveel @firebird-automations