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