Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 36429 invoked from network); 1 Aug 2006 12:59:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Aug 2006 12:59:03 -0000 Received: (qmail 15703 invoked by uid 500); 1 Aug 2006 12:59:01 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 15581 invoked by uid 500); 1 Aug 2006 12:59:01 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 15569 invoked by uid 99); 1 Aug 2006 12:59:01 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Aug 2006 05:59:01 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [85.90.206.104] (HELO office.redwerk.com) (85.90.206.104) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Aug 2006 05:59:00 -0700 Received: from bofh by office.redwerk.com with local (Exim 4.62 (FreeBSD)) (envelope-from ) id 1G7tpa-00017r-0N for user-java@ibatis.apache.org; Tue, 01 Aug 2006 15:58:42 +0300 Date: Tue, 1 Aug 2006 15:58:41 +0300 From: Eugeny N Dzhurinsky To: user-java@ibatis.apache.org Subject: Re: Closing a connection Message-ID: <20060801125841.GB4221@office.redwerk.com> Mail-Followup-To: user-java@ibatis.apache.org References: <859230af0608010514kf4b2af7t74b7eb4ba0b1529c@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline In-Reply-To: <859230af0608010514kf4b2af7t74b7eb4ba0b1529c@mail.gmail.com> User-Agent: Mutt/1.5.12-2006-07-14 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On Tue, Aug 01, 2006 at 05:44:52PM +0530, Prasad Jayakumar wrote: > I am researching on using iBatis 2.1.7 in our project. I am an Oracle > DBA and a Java Developer. I am using > iBatis DAO > SQLMAP Transaction Manager > SqlMapDaoTemplate. > > I tried some sample programs. I noticed all the database connection > not getting closed. Is there anything in particular I should look at > or include in the code? > > Could you tell in general, How / When database connection is getting > closed in iBatis? It is usually much better to allow some database pools (like Apache DBCP) to manage connections opening/closing. -- Eugene N Dzhurinsky