Re: AS400 and JDBC Connection in QUSRWRK subsystem for ever

Hi
I dont set any parameters
this is what i do
// to create a new connection
 AS400ConnectionPool testPool = new
AS400ConnectionPool();

 AS400 as400 = testPool.getConnection(system,
userid,password);
//to get connection and
 testPool.returnConnectionToPool(as400);
//to return the connection to pool after user uses it,


is there a better way of doing it, i have to use user
specific connection and not use a generic user id and
password,

Ashish


--- Colin Williams <colin.williams@xxxxxxxxxxxx>
wrote:
> 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.
> >
> >
> 
> 
> _______________________________________________
> 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! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html