Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: domain of len.popp@gmail.com designates
 209.85.146.178 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=HE2ru98tQmS4aIQszcU2tf8RfzkVSfBIFYZS9Na2gbR12sI/GAw+WLblfIhB6ZgJGSI0AiNXZFaA9noTLpImLE12lDI5tRQwWy7plHc52Qp3syxbvRZjetGdKiHV7UjAR2scDj4O1Ivn9NLm942OAm3UxkYe94ba9PQk5g/4cNE=
Message-ID: <497fac690710251424v160e90d9x1e1ac43dcc80f0de@mail.gmail.com>
Date: Thu, 25 Oct 2007 17:24:34 -0400
From: "Len Popp" <len.popp@gmail.com>
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: Suggestions for connection pooling
In-Reply-To: 
 <40B0057E59252B40A70D1881216C4A0104348DCA@mail3.benefitconceptsinc.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: 
 <40B0057E59252B40A70D1881216C4A0104348D30@mail3.benefitconceptsinc.com>
	 <40B0057E59252B40A70D1881216C4A0104348DCA@mail3.benefitconceptsinc.com>

On 10/25/07, Tony Fountain <tfountain@benefitconcepts.com> wrote:
> Now, my goal is to utilize connection pooling.  Does (a) this
> implementation achieve that and (b) the close statement suffice to
> return the object to the pool and not actually close the connection?  Or
> do I also need to set "conn = null;"?

You don't need to set conn = null, but you *do* need to make sure that
the connection is closed in all cases, even when an exception is
thrown. So:

       Connection conn = ds.getConnection();
       try {
           ...do something...
       } finally {
           conn.close();
       }

-- 
Len

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org