RE: JDBC Connection pooling

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
David, thanks for sharing your code... But I have a question...  What are
the benifits of connection pooling, and when would I use them?

thanks, tim

> -----Original Message-----
> From: David Gibbs [SMTP:dgibbs@mks.com]
> Sent: Monday, March 25, 2002 10:22 AM
> To:   'JAVA400 List'
> Subject:      Re: JDBC Connection pooling
>
> Mike Silvers said:
> > Does anyone have a working example of using JDBC connection pooling?  I
> > have done several searches on the web and found article after article,
> > but I would like to see a real working example of JDBC connection
> > pooling..
>
> Yes, as a mater of fact, I just figured this out a few weeks ago.
>
> I think that the reason you couldn't find much is, connection pooling is
> not
> part of Java 2 1.3 (I think).  It might be in 1.4, but I'm not sure.  JDBC
> connection pooling is database and/or environment specific.
>
> Here's what I did to create a JDBC connection pool using JT400...
>
> // build your connection pool ...
>
> AS400JDBCConnectionPoolDataSource dataSource =
>       new AS400JDBCConnectionPoolDataSource(hostId, userid, password);
> dataSource.setLibraries(fileLibrary);
> dataSource.setTransactionIsolation("none");
> AS400JDBCConnectionPool pool = new AS400JDBCConnectionPool(dataSource);
> pool.setMaxConnections(poolSize);
>
> // to get a connection
> Connection con = pool.getConnection();
>
> // to give the connection back
> con.close();
>
> david
>
> --
> David Gibbs
> Sr. Software Engineer / R&D / MKS Inc., www.mks.com
> Lombard, IL, USA; tel: 630-495-2108; fax: 630-495-3591
> Build Better Software
>
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.