[mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 3:37 PM
To: Tomcat Users List
Subject: Re: Tomcat 4.1 Connection Pooling...
Just a thought (and I apologize if this was already mentioned.I
missed the very beginning of the thread), but I would also make sure you
have the latest
Nalgonda [mailto:[EMAIL PROTECTED]
Sent: 28 September 2004 20:04
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
how can i check that and how to resolve it...
-Original Message-
From: Dale, Matt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 3:06 PM
To
ra, Yoav [mailto:[EMAIL PROTECTED]
> Sent: September 28, 2004 1:55 PM
> To: Tomcat Users List
> Subject: RE: Tomcat 4.1 Connection Pooling...
>
> Hi,
> Hmm ;) There's a good reason there's no close method on
> javax.sql.DataSource. There's also a good reaso
Message-
>>From: Phillip Qin [mailto:[EMAIL PROTECTED]
>>Sent: Tuesday, September 28, 2004 1:27 PM
>>To: 'Tomcat Users List'
>>Subject: RE: Tomcat 4.1 Connection Pooling...
>>
>>For connecion pooling, when you close the connection, you don't
&
Even though this resource is not in "Global" scope?
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: September 28, 2004 1:55 PM
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
Hi,
Hmm ;) There's a good reason there'
ur DB
> for a breakdown of where the 200 processes are coming from.
>
> Yoav Shapira
> Millennium Research Informatics
>
>
>
>
> >-Original Message-
> >From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, September 28, 2004
section so the connection never got closed.
Once I put a finally block in with a con.close() then it solved my problem.
Ta
Matt
-Original Message-
From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
Sent: 28 September 2004 20:04
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling
just in case, here's a link to Oracle's developer jdbc section
http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/files/jdbc30/index.html
just make sure the apps are calling java.sql.Connection.close() when
they are done. the PooledConnection underneath will pass the
connection back
Millennium Research Informatics
>-Original Message-
>From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, September 28, 2004 3:04 PM
>To: Tomcat Users List
>Subject: RE: Tomcat 4.1 Connection Pooling...
>
>how can i check that and how to resolve it...
>
how can i check that and how to resolve it...
-Original Message-
From: Dale, Matt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 3:06 PM
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
Perhaps your application is hanging on to the database connections
Perhaps your application is hanging on to the database connections and not returning
them to the pool?
-Original Message-
From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
Sent: 28 September 2004 19:43
To: Tomcat Users List; Peter Lin
Subject: RE: Tomcat 4.1 Connection Pooling...
I have
, September 28, 2004 2:23 PM
To: Tomcat Users List
Subject: Re: Tomcat 4.1 Connection Pooling...
Yoav is correct, you should be using the newer driver and not the
older one. good thing I asked which version the driver is.
that's a really old bug in the old driver. I remember reporting th
.
>
> Yoav Shapira
> Millennium Research Informatics
>
>
>
>
> >-Original Message-
> >From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, September 28, 2004 2:09 PM
> >To: Tomcat Users List; Peter Lin
> >Subject: RE: Tomcat 4.1
thanks..
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 2:17 PM
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
Hi,
You're wrong. You can and should use classes12.zip (renamed to
classes12.jar) with Orac
;Sent: Tuesday, September 28, 2004 2:09 PM
>To: Tomcat Users List; Peter Lin
>Subject: RE: Tomcat 4.1 Connection Pooling...
>
>I am using Oracle 8i, and Oracle drivers i use is Oracle111.jar, and
use
>DBCp for connection Pooling with Tomcat4.1,
>i thought classes112 is for 9i...correct me i
: Tomcat Users List
Subject: Re: Tomcat 4.1 Connection Pooling...
I thought Oracle fixed that bug in their connectionPooling driver back
in 2001. Am I missing something? Are you using some other driver to
create a pool of jdbc connections to Oracle? sorry for the question if
it's already been ans
D]
> >Sent: Tuesday, September 28, 2004 1:27 PM
> >To: 'Tomcat Users List'
> >Subject: RE: Tomcat 4.1 Connection Pooling...
> >
> >For connecion pooling, when you close the connection, you don't
> actually
> >close the physical link. After
ntextDestroyed).
>
>If you have defined loadonstartup servlet in your web.xml, in the
destroy
>method, explicitly close your data source.
>
>-Original Message-
>From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
>Sent: September 28, 2004 1:06 PM
>To: Tomcat User
itly close your data source.
-Original Message-
From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
Sent: September 28, 2004 1:06 PM
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
I was not aware that i should explicitly close the datasource, but i am
making sure that i clo
g to do with your problem.
Yoav Shapira
Millennium Research Informatics
>-Original Message-
>From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, September 28, 2004 1:01 PM
>To: Tomcat Users List
>Subject: RE: Tomcat 4.1 Connection Pooling...
>
>O.k thanks i
PROTECTED]
Sent: Tuesday, September 28, 2004 1:06 PM
To: 'Tomcat Users List'
Subject: RE: Tomcat 4.1 Connection Pooling...
This error happens when there are too many connections opened. There are too
many connections opened because before you shut down your application, you
don't e
04 12:55 PM
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
But my application runs fine even with out that entry in web.xml, i am using
Tomcats ConnectionPooling to connect to database..I only have scalability
issue, when i test my application with multiple users i get the O
sage-
>From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, September 28, 2004 12:55 PM
>To: Tomcat Users List
>Subject: RE: Tomcat 4.1 Connection Pooling...
>
>But my application runs fine even with out that entry in web.xml, i am
>using
>Tomcats ConnectionPooling
nda [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, September 28, 2004 12:55 PM
>To: Tomcat Users List
>Subject: RE: Tomcat 4.1 Connection Pooling...
>
>But my application runs fine even with out that entry in web.xml, i am
>using
>Tomcats ConnectionPooling to connect to database..I only
com.mypublisher.oemapi.DAO.DBAccess.getConnection(DBAccess.java:43)
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 12:53 PM
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
Hi,
Yes, it's needed if you're using server-provided connection poo
;To: Tomcat Users List
>Subject: RE: Tomcat 4.1 Connection Pooling...
>
>Is it necessary to add this in web.xml, i have configured datasource
for
>connectonpool only in server.xml...
>
>
>web.xml
>---
>
>jdbc/myoracle
>javax.sql.DataSource
>Container
AM
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
Thanks.
Maybe its the parameter configuration can you send me your configuration for
connection pooling...
I am using these parameters...
maxActive :20
>maxIdle :10
>maxWait :1
>removeAbandoned :true -- what e
4 11:05 AM
>To: Tomcat Users List
>Subject: RE: Tomcat 4.1 Connection Pooling...
>
>Thanks.
>Maybe its the parameter configuration can you send me your
configuration
>for
>connection pooling...
>I am using these parameters...
>maxActive :20
>>maxIdle :10
>>maxWa
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 10:55 AM
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
Hi,
Nope, I can't help unfortunately. I used Tomcat 4.1 for years
connecting to Oracle 8i and 9i, and I continu
never seen the error you describe.
Yoav Shapira
Millennium Research Informatics
>-Original Message-
>From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, September 22, 2004 10:44 AM
>To: Tomcat Users List
>Subject: RE: Tomcat 4.1 Connection Pooling...
>
&g
Hi Yoav Shapira,
Can you put some light on this pooling stuff...
Thanks.
Shilpa.
-Original Message-
From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 9:31 AM
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
Hi Cary,
I am running my
Can anyone give me advice on the set up of Tomcat4.1 connection pooling
parameters...
-Original Message-
From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 9:31 AM
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
Hi Cary,
I am running
From: Cary Conover [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 10:09 PM
To: Tomcat Users List
Subject: RE: Tomcat 4.1 Connection Pooling...
Shilpa,
What OS are you running this configuration on? If it is AIX I would
investigate to see how the system is configured for the numb
Shilpa,
What OS are you running this configuration on? If it is AIX I would investigate to
see how the system is configured for the number of processes per user on the system.
If it is configured as a Workstation it is defaulted to 128 processes / login. If it
is configured as a server it i
Can someone please suggest how to achieve connection Pooling in tomcat 4.1.
As per the docs i have
1) configured server.xml to include the resource parameters ( datasource,
connection pool size etc)
2) In application code , retrieve connection using datasource
3) Every Method call to database retri
35 matches
Mail list logo
