Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 44059 invoked from network); 6 Feb 2007 16:36:24 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 6 Feb 2007 16:36:24 -0000 Received: (qmail 20516 invoked by uid 500); 6 Feb 2007 16:36:27 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 20498 invoked by uid 500); 6 Feb 2007 16:36:27 -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 20460 invoked by uid 99); 6 Feb 2007 16:36:27 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Feb 2007 08:36:26 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of clinton.begin@gmail.com designates 64.233.184.233 as permitted sender) Received: from [64.233.184.233] (HELO wr-out-0506.google.com) (64.233.184.233) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Feb 2007 08:36:17 -0800 Received: by wr-out-0506.google.com with SMTP id i4so1742861wra for ; Tue, 06 Feb 2007 08:35:55 -0800 (PST) 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=Q2srCD6ybr5dPjKUKPJ29uXVy3R9OYTQS2HvX42wK8O16yY5QlrJweuc+A/1ooYXLkXMRwKk0jq6D1WHxLEYn75YWa/g53Z5i5RdUMZNC2XqiOjPUfR2TwTA6P0yF0PN6CoUeQ8ejYWwNGwUbQ8WRtUVDPWyVczBuknFi8nDpVU= Received: by 10.114.107.19 with SMTP id f19mr789752wac.1170779755294; Tue, 06 Feb 2007 08:35:55 -0800 (PST) Received: by 10.114.135.7 with HTTP; Tue, 6 Feb 2007 08:35:55 -0800 (PST) Message-ID: <16178eb10702060835jf5d006etdc2ee10fc0941d25@mail.gmail.com> Date: Tue, 6 Feb 2007 09:35:55 -0700 From: "Clinton Begin" To: user-java@ibatis.apache.org Subject: Re: Difference between DBCP and SIMPLE connection pools In-Reply-To: <003c01c749d9$8e237dd0$0300a8c0@isanusid800> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <003c01c749d9$8e237dd0$0300a8c0@isanusid800> X-Virus-Checked: Checked by ClamAV on apache.org DBCP is a connection pool made by Apache. You need to download an additional JAR to use it. SIMPLE is built into iBATIS. SimpleDataSource has served us very well over the years, with very few changes. I'd like to redo the interface at some point (currently yucky property based config), but the implementation seems to work well. It's a synchronous pool that doesn't spawn any threads for reaping connections or anything like that. Cheers, Clinton On 2/6/07, Abdullah Kauchali wrote: > Hi folks, > > What's the difference between configuring connections as DBCP vs SIMPLE? > When to use which? > > TIA, > > A > > > > > > > > > > > > > > >