Issue Details (XML | Word | Printable)

Key: JDBC-390
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Mark Rotteveel
Reporter: Mark Rotteveel
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
Jaybird JCA/JDBC Driver

Unable to retrieve update count after result set.

Created: 11/Apr/15 06:57 PM   Updated: 31/May/15 02:37 PM
Component/s: JDBC driver
Affects Version/s: Jaybird 2.2, Jaybird 2.2.1, Jaybird 2.2.2, Jaybird 2.2.3, Jaybird 2.2.4, Jaybird 2.2.5, Jaybird 2.2.6, Jaybird 2.2.7
Fix Version/s: Jaybird 2.2.8, Jaybird 3.0.0

 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 11/Apr/15 09:29 PM
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.