Question
Infosys
IN
Last activity: 2 Aug 2017 5:35 EDT
External DB connection failure: Unable to fetch connection in 10 seconds-
When i tried to set up connection to external Database, i am getting connection issue as mentioned below error:
| Status Value: Problem encountered when getting a database connection: code: 0 SQLState: <none> Message: [http-nio-8080-exec-49] Timeout: Pool empty. Unable to fetch a connection in 10 seconds, none available[size:10; busy:10; idle:0; lastwait:10000]. DatabaseException caused by prior exception: org.apache.tomcat.jdbc.pool.PoolExhaustedException: [http-nio-8080-exec-49] Timeout: Pool empty. Unable to fetch a connection in 10 seconds, none available[size:10; busy:10; idle:0; lastwait:10000]. | SQL Code: 0 | SQL State: null |
|
Fail
|
Pegasystems Inc.
IN
Please compare once with my local enviornment's tomcat .
Please compare once with my local enviornment's tomcat .
Infosys
IN
PFB context file DB configuration
<Resource maxWait="10000" maxIdle="10" maxActive="10" url="jdbc:sqlserver://DB126CLUST.cpwn.infra.net:1433;databaseName=OSSDatabase;SelectMethod=cursor;SendStringParametersAsUnicode=false;integratedSecurity=true" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" type="javax.sql.DataSource" auth="Container" name="jdbc/ossDB" logAbandoned="false" removeAbandonedTimeout="600" removeAbandoned="false" validationQuery="SELECT 1" testOnBorrow="true" minIdle="2" initialSize="2" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"/>
Pegasystems Inc.
IN
Could you please once try with below value:
maxActive="100"
maxIdle="30"
Could you please once try with below value:
maxActive="100"
maxIdle="30"
maxWait="10000"
Thank you
-Abhishek