RE: [EXTERNAL] Re: Connection pool

[Mohamed Eliyas Abdul Kadar <mo...@neogenomics.com>]

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 <su...@gmail.com>
Sent: Wednesday, May 4, 2022 10:27 PM
To: Tomcat Users List <us...@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.

Hello Mohamed,

On Thu, May 5, 2022 at 2:59 AM Mohamed Eliyas Abdul Kadar <mo...@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org