[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
: Shilpa Nalgonda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 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
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
---
resource-ref
res-ref-namejdbc/myoracle/res-ref-name
res-typejavax.sql.DataSource/res-type
res-authContainer/res-auth
/resource
)
at
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 pooling
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 have
scalability
issue, when i test my
[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 have
scalability
issue, when
: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 ORAcle
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 explicitly close
.
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'll do that, but what exactly you mean by
Tomcat tries
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 close all
, explicitly 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
of a
server-provided JNDI resource, you'll be in a murky space at best.
Yoav Shapira
Millennium Research Informatics
-Original 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
To: 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 answered
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 if i am wrong...
-Original Message
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 Oracle 8i
-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 Connection Pooling...
I am using Oracle 8i, and Oracle drivers i use is Oracle111.jar, and
use
DBCp for connection
, 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 the
bug
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
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
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...
-Original Message-
From: Dale, Matt
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
in that 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
processes are coming from.
Yoav Shapira
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
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's no close method
: Tomcat 4.1 Connection Pooling...
For connecion pooling, when you close the connection, you don't
actually
close the physical link. After several shutdown/sartup of your
application,
open connection accumulates and exceeds Oracle's 200 thus you receive
that
SQLException.
To solve your problem, I
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 reason the J2EE spec calls for
the container, not the user, to manage the lifecycle of JNDI resources
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
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 number of processes
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
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
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...
Hi Yoav Shapira,
Can you put some light
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 continue to do so now
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 exactly is MaxIdle parameter
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
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
35 matches
Mail list logo
