RE: JDBC Connection pooling

Gary has a good point.  If you are going to run on top of an application
server such as WebSphere you should use their connection pooling instead of
using methods on the driver.  That way you let the application server hide
potential implementation differences between various JDBC drivers.

David Wall
Toolbox for Java
iSeries ODBC Driver for Linux




                      "Gary L Peskin"
                      <garyp@firstech.c        To:       
<java400-l@midrange.com>
                      om>                      cc:
                      Sent by:                 Subject:  RE: JDBC Connection 
pooling
                      java400-l-admin@m
                      idrange.com


                      03/25/2002 02:58
                      PM
                      Please respond to
                      java400-l





Marady --

Are you asking how to use connection pooling with iSeries WAS or in some
other environment.  If you're interested in the iSeries WAS
implementation, see
http://publib.boulder.ibm.com/was400/40/AE/english/docs/datcpovr.html,
for example.

HTH,
Gary

> -----Original Message-----
> From: java400-l-admin@midrange.com
> [mailto:java400-l-admin@midrange.com] On Behalf Of
> MaradyPrak@BigLots.com
> Sent: Monday, March 25, 2002 12:00 PM
> To: java400-l@midrange.com
> Subject: Re: JDBC Connection pooling
>
>
>
> Dave,
>
> This is great if I have a long running application that needs
> to hit the database back end multiple times.  Do you know of
> a way to incorporate datasource connection pooling with JNDI
> or something similar.  What I'm interested is something that
> always running and can give out connections to the database
> through the JNDI look-up.  So, my other applications running
> can get connection from the same central naming directory
> services.  This way all  other applications  do not have to
> insatiate the classed with the connections and datasource
> up-front every time.  For example, like the Websphere
> Application server, it have a central datasources, an all the
> applications can use it when ever and never have to worry
> about creating datasource or connection to the database for
> every execution.  I don't know if I'm explaining my-self
> clearly or not.  But let me know if you want me to explain it
> in another way.
>
>
> Kind Regards,
>              Marady Prak - Technical
> Specialist/Administrator, Himalaya System Big Lots, Inc 300
> Phillipi Road Columbus, OH 43228
> Phone: 614-278-7186   Fax: 614-278-4769
> http://www.eonestopshop.com
>
>
>
>
>                     David Gibbs
>                     <dgibbs@mks.com>         To:
> "'JAVA400 List'" <JAVA400-L@midrange.com>
>                     Sent by:                 cc:
>                     java400-l-admin@mi       Subject:     Re:
> JDBC Connection pooling
>                     drange.com
>
>
>                     03/25/2002 01:21
>                     PM
>                     Please respond to
>                     java400-l
>
>
>
>
>
>
> 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.