Re: AS400 and JDBC Connection in QUSRWRK subsystem for ever

Ashish,

which version of JTOpen are you using. I have recently run into a very
similar problem.

I was using websphere datasources/connection pooling using
AS400JDBCConnectionPoolDataSource from jtopen 3.3.

What I found was that the application that I had written died very quickly
because every time you accessed a jsp it was creating a new connection in
the pool, rather than using an existing pooled connection, so very quickly
ran out of connections.

When I installed the latest jtopen on my PC, 4.2, the pooling appeared to
work correctly. The connections were returned to the pool, and the next time
the jsp was accessed, it correctly used an existing connection, rather than
trying to create a new one.

We now need to apply the latest cum PTF to get this installed in the jt400
on the as400, and hopefully that should fix the problem.

cheers
Colin.W


----- Original Message -----
From: "Ashish Kulkarni" <kulkarni_ash1312@xxxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Wednesday, February 04, 2004 9:07 PM
Subject: AS400 and JDBC Connection in QUSRWRK subsystem for ever


> Hi
> I have web application in which i am using
> AS400ConnectionPool and AS400JDBCConnectionPool for
> AS400 and JDBC Connections,
> But i see about 5-6 connections for each user in
> QUSRWRK
> and they seem to be there for ever. They are never
> removed from the system untill i restart the web
> application server or IPL the AS400,
> What may be the reason, why is a new AS400 connection
> of JDBC connection created when one is existing,
> I take care or returning all the connections back to
> pool after each time i use them in program.
> It seems that one connection is created daily but the
> old one is still sitting in system
> How can I manage and solve this problem
> Ashish
>
>
> =====
> A$HI$H
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free web site building tool. Try it!
> http://webhosting.yahoo.com/ps/sb/
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>