Re: AS400 and JDBC Connection in QUSRWRK subsystem for ever

[Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx>]

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/