Re: JDBC Connection pooling

["Mike Silvers" <msilvers@xxxxxxxxxxx>]

Tim,

The most time consuming part of database connections are the opening and
closing of the connections.  This is true whether you are using JDBC, JT400
Toolbox classes, RPG, COBOL, or any other language.  Connection pooling
allows you to open a specific number of connections at the time the first
connection is made.  A connection is taken form the pool, used, and
returned to the pool.  Subsequent use of the connection does not require the
open/close overhead.  This reduces the overall connection times.

Mike

----- Original Message -----
From: "Hatzenbeler, Tim" <thatzenbeler@clinitech.net>
To: <java400-l@midrange.com>
Sent: Monday, March 25, 2002 1:56 PM
Subject: RE: JDBC Connection pooling


> 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.
> _______________________________________________
> 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.
>
>