Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!news.glorb.com!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail
From: "Alfred" <alfred@THRWHITE.remove-dii-this>
Subject: Re: Connection Pooling
Message-ID: <4844cb62$1_1@news.bluewin.ch>
X-Comment-To: comp.lang.java.databases
Newsgroups: comp.lang.java.databases
In-Reply-To: <c4cccce5-398e-40e2-9c0e-d347336e6b26@a70g2000hsh.googlegroups.com>
References: <c4cccce5-398e-40e2-9c0e-d347336e6b26@a70g2000hsh.googlegroups.com>
Content-Type: text/plain; charset=IBM437
Content-Transfer-Encoding: 8bit
X-Gateway: time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92]
Lines: 42
Date: Wed, 27 Apr 2011 15:22:05 GMT
NNTP-Posting-Host: 96.60.20.240
X-Complaints-To: news@tds.net
X-Trace: newsreading01.news.tds.net 1303917725 96.60.20.240 (Wed, 27 Apr 2011 10:22:05 CDT)
NNTP-Posting-Date: Wed, 27 Apr 2011 10:22:05 CDT
Organization: TDS.net
Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:158

  To: comp.lang.java.databases
Chase Preuninger wrote:
> What is the best way to create/get a database pool for a serious web
> application?

Because of WEB Application a simple sample for Tomcat.

1.Declare Datasource in your Context.xml, e.g.:
<Resource name="MyDatabase"
     auth="Container" type="javax.sql.DataSource"
     maxActive="10" maxIdle="30" maxWait="10000"
     username="sa"
     password=""
     driverClassName="org.h2.Driver"
     url="jdbc:h2:tcp://localhost:9092/hibernate" />

2.Add a resource-ref to your web.xml:
<resource-ref>
    <res-ref-name>MyDatabase</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>

Tomcat build connection pool by themself. Look for
file tomcat-dbcp.jar in Tomcats lib-directory.

3.Get the connection:
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup(
    "java:comp/env/MyDatabase");
Connection con = ds.getConnection();

4.Close the connection _every_time_ in your SQL source
within _finally_block_. It does not close the connection
but put it back into the pool.

Alfred

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24