How to change the default JDBC idle timeout value in BW.
Article ID: KB0090851
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
By default, JDBC default idle timeout is set to 5 minutes. It can be changed using the following property:
java.property.bw.engine.dbConnection.idleTimeout
Ex: change the default JDBC idle timeout to 60 minutes:
java.property.bw.engine.dbConnection.idleTimeout 60
Add this in the designer.tra file if doing tests in TEST mode.
For deployment you can add this in the C:\tibco\bw\5.x\lib\com\tibco\deployment\bwengine.xml
KEYWORDS: JDBC, idle, timeout, property
By default, JDBC default idle timeout is set to 5 minutes. It can be changed using the following property:
java.property.bw.engine.dbConnection.idleTimeout
Ex: change the default JDBC idle timeout to 60 minutes:
java.property.bw.engine.dbConnection.idleTimeout 60
Add this in the designer.tra file if doing tests in TEST mode.
For deployment you can add this in the C:\tibco\bw\5.x\lib\com\tibco\deployment\bwengine.xml
KEYWORDS: JDBC, idle, timeout, property
Issue/Introduction
How to change the default JDBC idle timeout value in BW.
Feedback
Yes
No
Powered by
