RE: Servlet Connection Pooling

["Gary L Peskin" <garyp@xxxxxxxxxxxx>]

When you call AS400Servlet.setUseConnectionPool(true), the system
creates an AS400ConnectionPool.  You can get this pool by calling
AS400Servlet.getConnectionPool().  Once you have the connection pool,
you can call any of the methods on the pool.  See the
AS400ConnectionPool class and its superclass ConnectionPool.  Both
classes are in the com.ibm.as400.access package.  You'll find methods
there like setMaxConnections, setCleanupInterval and stuff like that.

I'm not sure what you mean by changing the IP address.  The connections
are kept in the pool and the IP address (or system name) is an attribute
of a connection, not of the pool.  A pool can hold connections to
multiple AS/400s.  However, once you retrieve an object from the pool,
you really shouldn't change the system name or user id.

Not sure if this answered your question but I hope it helps.

Gary

> -----Original Message-----
> From: java400-l-admin@midrange.com
> [mailto:java400-l-admin@midrange.com] On Behalf Of Mike Silvers
> Sent: Saturday, January 26, 2002 12:48 PM
> To: Java400L List
> Subject: Servlet Connection Pooling
>
>
> All,
>
> Is anyone familiar with using the AS400Servlet class and
> connection pooling? From what I read, you need to set the
> setUseConnectionPool to true and you can get a connection
> from the pool using the getSystem.  The question I have is
> how do I set the attributes of the connection pool object the
> servlet is using?  All I see is a generic method to use the
> connection pool, then a generic method to get a connection.
> Can I change the pool attributes (such as max connections, IP
> address, etc)?
>
> Mike
>
> ================================
>
> Mike Silvers
> AS/400 Senior Programmer/Analyst
> AS/400 IBM Certified RPG IV Developer
> AS/400 IBM Certified Solutions Expert
> Hainey Business Systems
> 8 E. Canal St
> Dover, PA 17315
> Branch Office:  (410) 397-8739
> Phone:  (800) 932-3380
> Fax:  (717) 292-9474
> Web: http://www.hbs-inc.com
> ________________________________
> Providing E-Commerce, EDI, AS/400
> Development and related services
> nationwide.
> ================================
>
>
> _______________________________________________
> 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.
>