Oracle - Fix connexion loss
Last modified by Aurelie Bertrand on 2020/08/27 14:56
A bad management of Oracle’s connection pool by Tomcat may cause a loss of the connection. The solution would be to block Oracle from using the available connection pool.
Copy the the file sqldriverrepository.xml to the config folder of the appData of DigDash, and edit this copy:
Add the line “<property name=”FORBID_POOL_CONNECTION” value=”true” /> in the tag properties
<SQLDriver id="ORACLE" name="Oracle"
url="oracle:thin:@"
manufacturer="Oracle"
class="oracle.jdbc.driver.OracleDriver"
urlsample="$ui.DataBase.OracleSampleUrl"
availability="both">
<properties>
<property name="FORBID_POOL_CONNECTION" value="true"/>
</properties>
</SQLDriver>
url="oracle:thin:@"
manufacturer="Oracle"
class="oracle.jdbc.driver.OracleDriver"
urlsample="$ui.DataBase.OracleSampleUrl"
availability="both">
<properties>
<property name="FORBID_POOL_CONNECTION" value="true"/>
</properties>
</SQLDriver>
You’ll have to restart the server