× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.
>
>



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.