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"/> 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)
