Issue Details (XML | Word | Printable)

Key: DERBY-821
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Knut Anders Hatlen
Reporter: Knut Anders Hatlen
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

Client driver: Implicitly close exhausted result sets on the server

Created: 18/Jan/06 07:50 PM   Updated: 29/Jun/09 02:39 PM
Return to search
Component/s: Network Client, Network Server
Affects Version/s: 10.2.1.6
Fix Version/s: 10.2.1.6

Time Tracking:
Not Specified

File Attachments:
  Size
HTML File Licensed for inclusion in ASF works changes.html 2006-02-10 11:27 PM Knut Anders Hatlen 17 kB
File Licensed for inclusion in ASF works DERBY-821-v2.diff 2006-02-10 11:27 PM Knut Anders Hatlen 71 kB
Text File Licensed for inclusion in ASF works DERBY-821-v2.stat 2006-02-10 11:27 PM Knut Anders Hatlen 3 kB
File Licensed for inclusion in ASF works DERBY-821.diff 2006-01-31 10:50 PM Knut Anders Hatlen 59 kB
Text File Licensed for inclusion in ASF works DERBY-821.stat 2006-01-31 10:50 PM Knut Anders Hatlen 2 kB

Bug behavior facts: Performance
Resolution Date: 13/Feb/06 09:47 PM


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

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Knut Anders Hatlen made changes - 19/Jan/06 12:12 AM
Field Original Value New Value
Status Open [ 1 ] In Progress [ 3 ]
Knut Anders Hatlen made changes - 31/Jan/06 10:50 PM
Attachment DERBY-821.stat [ 12322508 ]
Attachment DERBY-821.diff [ 12322507 ]
Attachment changes.html [ 12322509 ]
Knut Anders Hatlen made changes - 31/Jan/06 10:53 PM
Other Info [Patch available]
Summary Client driver: Implicitly close exhausted result sets on the server
Client driver: Implicitly close exhausted result sets on the server
Bryan Pendleton made changes - 03/Feb/06 02:12 AM
Attachment changes-no-object-tags.html [ 12322568 ]
Knut Anders Hatlen made changes - 10/Feb/06 11:23 PM
Attachment changes-no-object-tags.html [ 12322568 ]
Knut Anders Hatlen made changes - 10/Feb/06 11:23 PM
Attachment changes.html [ 12322509 ]
Knut Anders Hatlen made changes - 10/Feb/06 11:27 PM
Attachment changes.html [ 12322825 ]
Attachment DERBY-821-v2.diff [ 12322823 ]
Attachment DERBY-821-v2.stat [ 12322824 ]
Bernt M. Johnsen made changes - 13/Feb/06 09:47 PM
Resolution Fixed [ 1 ]
Status In Progress [ 3 ] Resolved [ 5 ]
Knut Anders Hatlen made changes - 13/Feb/06 11:22 PM
Status Resolved [ 5 ] Closed [ 6 ]
Dag H. Wanvik made changes - 29/Jun/09 01:47 PM
Component/s Performance [ 11709 ]
Dag H. Wanvik made changes - 29/Jun/09 02:39 PM
Derby Categories [Performance]