[DERBY-821] Client driver: Implicitly close exhausted result sets on the server

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.2.1.6
• Component/s: Network Client, Network Server
• Bug behavior facts: Performance
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 18/Jan/06 19:50
• Updated: 29/Jun/09 14:39
• Resolved: 13/Feb/06 21:47

Description

Forward-only result sets that are exhausted should be implicitly
closed on the server. This way, ResultSet.close() does not have to
send an explicit close message generating unnecessary network traffic.

The DRDA protocol supports this. From the description of OPNQRY (open
query):

The qryclsimp parameter controls whether the target server
implicitly closes a non-scrollable query upon end of data (SQLSTATE
02000) in association with the cursor type.