Return-Path: Delivered-To: apmail-jakarta-commons-dev-archive@apache.org Received: (qmail 63768 invoked from network); 27 Dec 2001 19:23:42 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by daedalus.apache.org with SMTP; 27 Dec 2001 19:23:42 -0000 Received: (qmail 29818 invoked by uid 97); 27 Dec 2001 19:23:44 -0000 Delivered-To: qmlist-jakarta-archive-commons-dev@jakarta.apache.org Received: (qmail 29802 invoked by uid 97); 27 Dec 2001 19:23:44 -0000 Mailing-List: contact commons-dev-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Jakarta Commons Developers List" Reply-To: "Jakarta Commons Developers List" Delivered-To: mailing list commons-dev@jakarta.apache.org Received: (qmail 29791 invoked from network); 27 Dec 2001 19:23:43 -0000 Message-ID: <3C2B75BF.5050309@apache.org> Date: Thu, 27 Dec 2001 14:25:51 -0500 From: Berin Loritsch User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.7) Gecko/20011221 X-Accept-Language: en-us MIME-Version: 1.0 To: Jakarta Commons Developers List Subject: Re: Database Connection Pool References: <20011227191359.45319.qmail@web20504.mail.yahoo.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Randy Speh wrote: > Thanks for the info. Would you mind telling me the > differences between Avalon and Fulcrum/Commons. > > I just wasn't aware of Avalon for some reason. I've > been submerged in Turbine, Torque, Fulcrum and Commons > code. Honestly, I can only tell you what Avalon does (I wrote the code for the DB pooling). I don't know what Fulcrum is much less what it does. As for Commons, I have only had a cursory look at it, so I am not the one to answer this. > > Thanks, > Randy > --- Berin Loritsch wrote: > >>Randy Speh wrote: >> >> >>>I would be very interested to see what your >>> >>connection >> >>>pooling code looks like. I been trying to choose >>> >>the >> >>>most appropriate connection pooling technique and >>> >>have >> >>>been considering adapting one myself. Although, >>> >>I'd >> >>>really rather use something from the open source >>>community. >>> >>> >> >>Currently there is dbcp in Commons, Turbine >>connection pooling, >>and Avalon connection pooling. >> >>Both DBCP and Avalon provide similar semantics >>inspired by >>the official JDBC DataSource specifications--when >>you "close" >>the connection, it returns the Connection to the >>pool. Turbine >>(if I recall) makes you explicitly return it to the >>pool yourself. >> >>I won't get involved with which is the best pattern. >> >>Beyond that basic difference, there is alot of >>difference in the >>manner that the connection pools are configured. >>Since I don't >>have any real information on DBCP and Turbine >>pooling, I won't >>talk about them. Here is what Avalon's >>Configuration looks like: >> >> >> >> SELECT 1 FROM DUAL >> >> >> oracle.jdbc.driver.OracleDriver >> >>jdbc:oracle:thin:@localhost:1521:ORCL >> scott >> tiger >> >> >>The Pool Controller specifies how many connections >>the pool starts >>with ("min"), the absolute maximum number of >>connections ("max"), >>and how many new connections it creates at a time >>when it needs >>more ("grow"). It is important to note that the >>maximum is absolute. >>The pool will not go beyond that maximum number. >>The reason being >>that some drivers have license restrictions and it >>helps the pool >>to not violate the license. The last part >>("keep-alive") is the >>query used by the pool to determine if the >>connection has been closed >>by the server. We found out that not all databases >>are created >>equal, and while "SELECT 1" works for many >>databases, Oracle requires >>that "1" be selected from the dummy table "DUAL", >>and others like >>Informix require you to select from an application's >>table. >> >>You can determine for yourself if this is >>desirable--and possibly >>DBCP might steal ideas to narrow the differences. >>Who knows.... >> >> >>-- >> >>"They that give up essential liberty to obtain a >>little temporary safety >> deserve neither liberty nor safety." >> - Benjamin Franklin >> >> >>-- >>To unsubscribe, e-mail: >> >>For additional commands, e-mail: >> >> > > > __________________________________________________ > Do You Yahoo!? > Send your FREE holiday greetings online! > http://greetings.yahoo.com > > -- > To unsubscribe, e-mail: > For additional commands, e-mail: > > . > > -- "They that give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." - Benjamin Franklin -- To unsubscribe, e-mail: For additional commands, e-mail: