On 05/05/2022 17:51, Mohamed Eliyas Abdul Kadar wrote:
C:\apache-tomcat-9.0.45\conf which is CATALINA_BASE\conf
The contents of the context.xml file placed in that located is inherited
by every web application deployed to Tomcat. So, if you have three web
applications deployed you will get three instances of your connection
pool each with a maximum of 20 connections. That means your database
server may see up to 60 connections.
If you want one pool of 20 connections shared between all the deployed
web applications then you need to define that pool as a global resource
in server.xml and then use a ResourceLink in CATALINA_BASE/conf/context.xml
Alternatively, you can define individual pools in each of the web
application's individual context.xml file (META-INF/context.xml).
Mark
-----Original Message-----
From: Mark Thomas <ma...@apache.org>
Sent: Thursday, May 5, 2022 8:43 AM
To: users@tomcat.apache.org
Subject: Re: [EXTERNAL] Re: Connection pool
CAUTION: This email originated from outside the organization. DO NOT click
links or open attachments unless you recognize the sender and know the content
is safe.
On 05/05/2022 16:39, Mohamed Eliyas Abdul Kadar wrote:
This file is from context.xml for the datasource.
Repeating my previous question:
What is the full path to this context.xml file relative to CATALINA_BASE?
Mark
C:\apache-tomcat-9.0.45\bin>startup.bat
Using CATALINA_BASE: "C:\apache-tomcat-9.0.45"
Using CATALINA_HOME: "C:\apache-tomcat-9.0.45"
Using CATALINA_TMPDIR: "C:\apache-tomcat-9.0.45\temp"
Using JRE_HOME: "C:\Program Files\Java\jdk1.8.0_281"
Using CLASSPATH:
"C:\apache-tomcat-9.0.45\bin\bootstrap.jar;C:\apache-tomcat-9.0.45\bin\tomcat-juli.jar"
Using CATALINA_OPTS: ""
-----Original Message-----
From: Mark Thomas <ma...@apache.org>
Sent: Wednesday, May 4, 2022 11:38 PM
To: users@tomcat.apache.org
Subject: [EXTERNAL] Re: Connection pool
CAUTION: This email originated from outside the organization. DO NOT click
links or open attachments unless you recognize the sender and know the content
is safe.
On 04/05/2022 22:29, Mohamed Eliyas Abdul Kadar wrote:
Hi All
I am trying to limit the db connections on the oracle side by limiting the size
of connection pool in the datasource config as below. I tried setting the max
size to 20 by maxTotal/ maxActive either of them didn't work. The db side
connection was always more than 30. Please advise.
<Resource name="jdbc/portal" auth="Container" type="javax.sql.DataSource"
initialSize="10" maxTotal="10" maxIdle="10" maxWaitMillis="10000"
username="PORTAL" password="cde"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@cde" factory="SecureDataSource"/>
Which file is the above configuration snippet taken from? Full path relative to
CATALINA_BASE please.
Mark
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org This
communication and its attachments contain confidential information and
is intended only for the named addressee. If you are not the named
addressee you should not disseminate, distribute or copy this
communication. Please notify the sender immediately if you have
received this communication by mistake and delete or destroy this
communication. Communications cannot be guaranteed to be secured or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this communication which arise as a result of
transmission. If verification is required please request a hard-copy
version. NeoGenomics Laboratories, 9490 NeoGenomics Way, Fort Myers,
FL 33912, http://www.neogenomics.com (2022)
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
This communication and its attachments contain confidential information and is
intended only for the named addressee. If you are not the named addressee you
should not disseminate, distribute or copy this communication. Please notify
the sender immediately if you have received this communication by mistake and
delete or destroy this communication. Communications cannot be guaranteed to be
secured or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents of this
communication which arise as a result of transmission. If verification is
required please request a hard-copy version. NeoGenomics Laboratories, 9490
NeoGenomics Way, Fort Myers, FL 33912, http://www.neogenomics.com (2022)
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
