RE: AS400 and JDBC Connection in QUSRWRK subsystem for ever

Hi
yes i need one AS400 Connection for each user, for
JDBC i am using Connection pooling and create 1
connection for many users, but for AS400 i need one
connection for each user atleast,
Since the RPG program needs  user id for some security
purpose, so i cannot use a generic user id and
password for connection pooling as i can use in JDBC
Connection
So i will end up with one connection for each user,
but the advantage is that the one connection will be
used when the user logs off and login again and again
But i assumed this AS400 connections will die after a
while, but it is not happening
Also my main problem is that the activation groups are
never killed and so files are open and locked
So any suggestions on it

Ashish
--- Colin Williams <colin.williams@xxxxxxxxxxxx>
wrote:
> 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.
> 
> _______________________________________________
> 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.
> 


=====
A$HI$H

__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html