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

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:

File Name	Date Attached	Attached By	Size
changes.html	2006-02-10 11:27 PM	Knut Anders Hatlen	17 kB
DERBY-821-v2.diff	2006-02-10 11:27 PM	Knut Anders Hatlen	71 kB
DERBY-821-v2.stat	2006-02-10 11:27 PM	Knut Anders Hatlen	3 kB
DERBY-821.diff	2006-01-31 10:50 PM	Knut Anders Hatlen	59 kB
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:

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]