db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-821) Client driver: Implicitly close exhausted result sets on the server
Date Wed, 18 Jan 2006 10:50:50 GMT
Client driver: Implicitly close exhausted result sets on the server

---------------------------------------------------------------------

         Key: DERBY-821
         URL: http://issues.apache.org/jira/browse/DERBY-821
     Project: Derby
        Type: Improvement
  Components: Network Client, Network Server, Performance  
    Versions: 10.2.0.0    
    Reporter: Knut Anders Hatlen
 Assigned to: Knut Anders Hatlen 
    Priority: Minor
     Fix For: 10.2.0.0


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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message