Re: JDBC Connection pooling

[David Gibbs <dgibbs@xxxxxxx>]

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