How long the appian JDBC keeps the database connection alive? and How long it will be cached ?

This might be helpful:  [mention:2ffa5d917e2f45bb94517bf2415f9eaf:6b577b8c04704e209d29b6772bf67243] 

I think this only way to control this is via the tomcatResources.xml

initialSize="5"
maxActive="200"
defaultTransactionIsolation="READ_COMMITTED"
maxWait="30000"
minIdle="5"
minEvictableIdleTimeMillis="90000"
timeBetweenEvictionRunsMillis="450000"

AFAIK, it is determined by database connection pool’s settings