Return-Path: Mailing-List: contact tomcat-dev-help@jakarta.apache.org; run by ezmlm Delivered-To: mailing list tomcat-dev@jakarta.apache.org Received: (qmail 64370 invoked from network); 21 Jun 2000 07:04:56 -0000 Received: from lh04.opsion.fr (212.73.208.230) by locus.apache.org with SMTP; 21 Jun 2000 07:04:56 -0000 Received: from 213.56.124.242 [213.56.124.242] by lh04.opsion.fr; Wed, 21 Jun 2000 07:01:11 GMT From: "Jean-Yves MENGANT" To: Subject: RE: cvs commit:jakarta-tomcat/proposals/catalina/src/share/org/apache/tomcat/realmJDBCRealm.java Date: Wed, 21 Jun 2000 09:07:56 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 In-Reply-To: Importance: Normal X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N >> FYI! >>You don't need to close RS's although, I'm sure it doesn't really hurt >>anything. You're right but... Resulset may consume lot of memory resources, mainly depending on the way JDBC driver provider's implementation , so a good programming habbit consist in closing them as soon as you don't need them anymore , this has impacts on memory consumptions. Jean-Yves -----Message d'origine----- De : Jon Stevens [mailto:jon@latchkey.com] Envoye : Wednesday, June 21, 2000 2:30 AM A : tomcat-dev@jakarta.apache.org Objet : Re: cvs commit:jakarta-tomcat/proposals/catalina/src/share/org/apache/tomcat/rea lmJDBCRealm.java on 6/20/2000 5:04 PM, "craigmcc@locus.apache.org" wrote: > * Close result sets when we are through with them, to avoid dangling > objects and occupied database resources. FYI! You don't need to close RS's although, I'm sure it doesn't really hurt anything. "A ResultSet object is automatically closed when the Statement object that generated it is closed, re-executed, or used to retrieve the next result from a sequence of multiple results. " -jon --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-dev-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-dev-help@jakarta.apache.org ______________________________________________________________________________ message envoye depuis http://www.ifrance.com emails (pop)-sites persos (espace illimite)-agenda-favoris (bookmarks)-forums Ecoutez ce message par tel ! : 08 92 68 92 15 (france uniquement)