Thank you for your response. But I have a question. I need manager app to deploy the application, is there a way that can be avoided. As you mentioned I have an application with 20 connections and with manager app it comes back as 40 connections on the db side.
-----Original Message----- From: Mark Thomas <ma...@apache.org> Sent: Monday, May 9, 2022 8:47 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 09/05/2022 16:42, Mohamed Eliyas Abdul Kadar wrote: > Does that mean manager app deployed on the tomcat will also influence > creating of connection pools. Manager does not have ang datasource, even then > will it induce connection pool. Yes. If you define the resource in CATALINA_BASE/conf/context.xml you get one instance of the resource for every web application deployed. Mark > > -----Original Message----- > From: Mark Thomas <ma...@apache.org> > Sent: Thursday, May 5, 2022 10:00 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 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 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
