Question

1
Replies
468
Views
PradeepPydi Member since 2017 206 posts
Anthem
Posted: July 2, 2018
Last activity: July 3, 2018
Closed

Recommended Connection pool settings @ Tomcat8 @PRPC731 @SQL Server.

Hi Team,

Could you please provide the recommended Connection pool settings for the below mentioned environment configuration.

PRPC731,Tomcat 8.5.13 and SQL Server.

Also find the current context.xml connection pool settings below.

<Resource maxWaitMillis="10000" maxIdle="30" maxTotal="100" password="ABCD" username="ABCD" url="jdbc:sqlserver://ABCD.CORP.AGP.ADS\PEGA;databaseName=ABCD;SelectMethod=cursor;SendStringParametersAsUnicode=false" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" type="javax.sql.DataSource" auth="Container" factory="dbencryption.EncryptedDataSourceFactory" name="jdbc/PegaRULES"/>

Please suggest if we need to add up any additional settings or change in values.

Low-Code App Development Testing Applications System Administration
Moderation Team has archived post
Share this page LinkedIn