RE: AS400 objects from a connection pool

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Mark,

I can't see where you can control this entirely from the "Web side"
because 
the connection is stateless. You can come pretty close with the native
driver 
but there are no guarantees unless you set the usage to *nomax, which
means 
you touch the AS/400 side anyway. Alternatives would be to build your
own 
connection broker that stays active on the AS/400 but that is a lot of
work.

David Morris

>>> MarkP@xxxxxxxxxxxxxxx 05/09/03 08:06AM >>>
I agree, I need it on the web side too.

Are there any generic pooling mechanisms available that could be used? 
In 
other words, you provide some code that the pool calls when it needs to

add another object to the pool.  Your code could then construct and 
initialize an AS400 connection and give it to the pool to give to the 
requester and later store.

I imagine it wouldn't be too difficult to write your own pool, but it 
would be nice to use something else where all of the threading issues
have 
been thought of and tested.

Mark