RE: AS400 and JDBC Connection in QUSRWRK subsystem for ever -- JAVA400-L

Ashish,

Sorry, I assumed you were doing database pooling using the datasources in
websphere

Maybe im missing something, but if your using specific user ids and
passwords, do you need to pool the connections, 
Or is one user doing multiple things at the same time.

Arent you going to end up with a lot of pools, at least 1 pool for each
user?

Cheers
Colin.W

-----Original Message-----
From: Ashish Kulkarni [mailto:kulkarni_ash1312@xxxxxxxxx] 
Sent: 05 February 2004 16:19
To: Java Programming on and around the iSeries / AS400
Subject: 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
_______________________________________________
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 e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is The Nest, Rosary Road Norwich NR1 1TF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.