RE: [EXTERNAL] Re: Connection pool
Thank you Mark and Chris -Original Message- From: Christopher Schultz Sent: Monday, May 9, 2022 12:13 PM 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. Mohamed, On 5/9/22 12:47, Mohamed Eliyas Abdul Kadar wrote: > I need manager app to deploy the application, is there a way that can > be avoided. Yes. > As you mentioned I have an application with 20 connections and with > manager app it comes back as 40 connections on the db side. You need to define the in your application-specific deployment descriptor. Mark replied on 5 May saying: " > 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)." If you need help interpreting what was written above or indeed implementing it, please let us know. But that's the answer: define the pool for a specific application and not in conf/context.xml. -chris > -Original Message- > From: Mark Thomas > 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 >> 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 >>> 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: Ma
RE: [EXTERNAL] Re: Connection pool
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 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 > 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 >> 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 >>> 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. >>>> >>>> >>>> >>> initialSize="10" maxTotal="10" maxIdle="10" maxWaitMillis="1" >>>> 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 >>> rel
RE: [EXTERNAL] Re: Connection pool
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. -Original Message- From: Mark Thomas 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 > 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 >> 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. >>> >>> >>> >> initialSize="10" maxTotal="10" maxIdle="10" maxWaitMillis="1" >>> 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
RE: [EXTERNAL] Re: Connection pool
C:\apache-tomcat-9.0.45\conf which is CATALINA_BASE\conf -Original Message- From: Mark Thomas 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 > 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. >> >> >> >initialSize="10" maxTotal="10" maxIdle="10" maxWaitMillis="1" >> 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)
RE: [EXTERNAL] Re: Connection pool
Please find below : C:\apache-tomcat-9.0.45\conf -Original Message- From: Mark Thomas 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 > 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. >> >> >> >initialSize="10" maxTotal="10" maxIdle="10" maxWaitMillis="1" >> 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
RE: [EXTERNAL] Re: Connection pool
This file is from context.xml for the datasource. 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 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. > > >initialSize="10" maxTotal="10" maxIdle="10" maxWaitMillis="1" > 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
RE: [EXTERNAL] Re: Connection pool
Hi Suvendu Thanks for responding, we are using only one instance of tomcat. The connections still exceed the MaxTotal / max Active value mentioned in the datasource config. -Original Message- From: Suvendu Sekhar Mondal Sent: Wednesday, May 4, 2022 10:27 PM To: Tomcat Users List 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. Hello Mohamed, On Thu, May 5, 2022 at 2:59 AM 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. > > > initialSize="10" maxTotal="10" maxIdle="10" maxWaitMillis="1" > username="PORTAL" password="cde" > driverClassName="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:thin:@cde" factory="SecureDataSource"/> > Can you please check the source IP of the connections just to make sure they all originated from the server where you are running your Tomcat? By any chance are you running multiple instances of Tomcats? Thanks & Regards, Suvendu > Regards > Mohamed > 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 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
Connection pool
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. Regards Mohamed 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)
RE: [EXTERNAL] Re: tomcat timeout
Thank you Chris. From: Christopher Schultz Sent: Friday, April 16, 2021 11:09 AM To: users@tomcat.apache.org Subject: Re: [EXTERNAL] Re: tomcat timeout 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. Mohamed, On 4/15/21 15:58, Mohamed Eliyas Abdul Kadar wrote: > Using chrome browser, I am accessing a web application which is > making a database call. The database call is taking more than 2 mins > , but the request time outs at 50 seconds. Is there a way to increase > this timeout. Your browser is timing out. If you look on the server, I suspect you'll see that the report is still running and the request-processing thread is in an iowait state. If you want to fix the timeout, reconfigure your browser. Mark H. Wood's response suggests something I agree with: don't make the web browser wait for the report to complete. Instead, fire-off the report in a background thread and have the browser poll the server for progress updates. -chris > -Original Message- > From: Mark Thomas mailto:ma...@apache.org>> > Sent: Thursday, April 15, 2021 11:54 AM > To: users@tomcat.apache.org<mailto:users@tomcat.apache.org> > Subject: [EXTERNAL] Re: tomcat timeout > > 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 15/04/2021 19:23, Mohamed Eliyas Abdul Kadar wrote: >> >> I am using tomcat 9.0.41. In my web application, when executing a query to >> fetch data for reporting it is taking time more than 2 minutes. The request >> is getting time out after 50s. Please let me know how to increase the data >> base timeout to 5 mins. > > Nothing to do with Tomcat. That is a client issue. Tomcat will wait for as > long as it takes to wrote the response. > > Mark > > - > To unsubscribe, e-mail: > users-unsubscr...@tomcat.apache.org<mailto:users-unsubscr...@tomcat.apache.org> > For additional commands, e-mail: > users-h...@tomcat.apache.org<mailto: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, 12701 Commonwealth Dr, Fort Myers, FL 33913, > http://www.neogenomics.com<http://www.neogenomics.com> (2021) > > > - > To unsubscribe, e-mail: > users-unsubscr...@tomcat.apache.org<mailto:users-unsubscr...@tomcat.apache.org> > For additional commands, e-mail: > users-h...@tomcat.apache.org<mailto:users-h...@tomcat.apache.org> > - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org<mailto:users-unsubscr...@tomcat.apache.org> For additional commands, e-mail: users-h...@tomcat.apache.org<mailto: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, 12701 Commonwealth Dr, Fort Myers, FL 33913, http://www.neogenomics.com (2021)
RE: [EXTERNAL] Re: tomcat timeout
Thank you Mark. -Original Message- From: Mark H. Wood Sent: Friday, April 16, 2021 7:42 AM To: users@tomcat.apache.org Subject: Re: [EXTERNAL] Re: tomcat timeout On Thu, Apr 15, 2021 at 08:25:12PM +, Mohamed Eliyas Abdul Kadar wrote: > I am generating report for a year, normally this takes 5 mins on weblogic > server. We are migrating to tomcat and it does not show any error. In > developer tools I see timeout for that request. I faced a similar issue some time ago, and decided that it was an application design error. I introduced a progress meter that polls periodically until the report generation completes or fails and, incidentally, gives the user an indication that service of the request is proceeding and has not simply hung or been dropped. Other possibilities: o The request causes a background thread to generate the report and email it when complete. o A first request causes the report to be generated in a holding area, perhaps sending an email when completed; a second request fetches the completed report. I decided that just lengthening timeouts was a losing strategy, because these particular reports can be requested over any portion of a record set that steadily grows in size, and can thus take longer to generate every month. Your situation may be different. -- Mark H. Wood Lead Technology Analyst University Library Indiana University - Purdue University Indianapolis 755 W. Michigan Street Indianapolis, IN 46202 317-274-0749 www.ulib.iupui.edu 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, 12701 Commonwealth Dr, Fort Myers, FL 33913, http://www.neogenomics.com (2021) - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: [EXTERNAL] Re: tomcat timeout
I am generating report for a year, normally this takes 5 mins on weblogic server. We are migrating to tomcat and it does not show any error. In developer tools I see timeout for that request. From: Rob Sargent Sent: Thursday, April 15, 2021 11:48 AM To: users@tomcat.apache.org Subject: [EXTERNAL] Re: tomcat timeout 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 4/15/21 12:23 PM, Mohamed Eliyas Abdul Kadar wrote: > I am using tomcat 9.0.41. In my web application, when executing a query to > fetch data for reporting it is taking time more than 2 minutes. The request > is getting time out after 50s. Please let me know how to increase the data > base timeout to 5 mins. > 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, 12701 Commonwealth Dr, Fort Myers, FL 33913, > http://www.neogenomics.com<http://www.neogenomics.com> (2021) > Are you sure you're not better off focusing on why your query is taking so long. How much data are you reading through and how much are you returning to the web client? - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org<mailto:users-unsubscr...@tomcat.apache.org> For additional commands, e-mail: users-h...@tomcat.apache.org<mailto: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, 12701 Commonwealth Dr, Fort Myers, FL 33913, http://www.neogenomics.com (2021)
RE: [EXTERNAL] Re: tomcat timeout
Using chrome browser, I am accessing a web application which is making a database call. The database call is taking more than 2 mins , but the request time outs at 50 seconds. Is there a way to increase this timeout. -Original Message- From: Mark Thomas Sent: Thursday, April 15, 2021 11:54 AM To: users@tomcat.apache.org Subject: [EXTERNAL] Re: tomcat timeout 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 15/04/2021 19:23, Mohamed Eliyas Abdul Kadar wrote: > > I am using tomcat 9.0.41. In my web application, when executing a query to > fetch data for reporting it is taking time more than 2 minutes. The request > is getting time out after 50s. Please let me know how to increase the data > base timeout to 5 mins. Nothing to do with Tomcat. That is a client issue. Tomcat will wait for as long as it takes to wrote the response. 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, 12701 Commonwealth Dr, Fort Myers, FL 33913, http://www.neogenomics.com (2021) - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: tomcat timeout
I am using tomcat 9.0.41. In my web application, when executing a query to fetch data for reporting it is taking time more than 2 minutes. The request is getting time out after 50s. Please let me know how to increase the data base timeout to 5 mins. 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, 12701 Commonwealth Dr, Fort Myers, FL 33913, http://www.neogenomics.com (2021)
tomcat timeout
I am using tomcat 9.0.41. In my web application, when executing a query to fetch data for reporting it is taking time more than 2 minutes. The request is getting time out after 50s. Please let me know how to increase the data base timeout to 5 mins. 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, 12701 Commonwealth Dr, Fort Myers, FL 33913, http://www.neogenomics.com (2021)
Tomcat 9.0
Hi All I am planning to use Tomcat for my development server. Initially we planned to go with version Tomcat 9.0.41. Now I see newer versions are release on top of that and see the latest version is Tomcat 9.0.45. Please let me know if there is any major fix of Tomcat 9.0.41 made on higher versions or we are good with Tomcat 9.0.44 as Tomcat 9.0.45 is not having any release date. Regards Eliyas 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, 12701 Commonwealth Dr, Fort Myers, FL 33913, http://www.neogenomics.com (2021)