Hello Mohamed, On Thu, May 5, 2022 at 2:59 AM Mohamed Eliyas Abdul Kadar <mohamed.ka...@neogenomics.com> 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"/> >
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
