Re: AS400 and JDBC Connection in QUSRWRK subsystem for ever

["Colin Williams" <colin.williams@xxxxxxxxxxxx>]

what properties have you got set for the connection pool, im sure there is
one that relates to idle connnections, and the length of time before they
are cleaned up

cheers
colin.W
----- Original Message -----
From: "Ashish Kulkarni" <kulkarni_ash1312@xxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Wednesday, February 04, 2004 10:38 PM
Subject: Re: AS400 and JDBC Connection in QUSRWRK subsystem for ever


> Hi
> I am using JTOpen4.1 , which i downloaded from web and
> i am using websphere on windows 2000 and not on AS400,
> My problem is that the connection is returned and then
> the same connection is used, but may be after 24 hours
> a new connection is created , but the old one is not
> removed from the QUSRWRK susbsytem
> it remains there for ever
> Ashish
> --- Colin Williams <colin.williams@xxxxxxxxxxxx>
> wrote:
> > 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.
> > >
> > >
> >
> >
> > _______________________________________________
> > 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.
> >
>
>
> __________________________________
> 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.
>
>