Wiki source code of Oracle - Perte de connexion
Last modified by Aurelie Bertrand on 2020/08/27 14:56
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | 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. | ||
| 2 | Copy the the file sqldriverrepository.xml to the config folder of the appData of DigDash, and edit this copy: | ||
| 3 | |||
| 4 | Add the line “<property name=”FORBID_POOL_CONNECTION” value=”true” /> in the tag properties | ||
| 5 | |||
| 6 | |||
| 7 | {{code}} | ||
| 8 | <SQLDriver id="ORACLE" name="Oracle" | ||
| 9 | url="oracle:thin:@" | ||
| 10 | manufacturer="Oracle" | ||
| 11 | class="oracle.jdbc.driver.OracleDriver" | ||
| 12 | urlsample="$ui.DataBase.OracleSampleUrl" | ||
| 13 | availability="both"> | ||
| 14 | <properties> | ||
| 15 | <property name="FORBID_POOL_CONNECTION" value="true"/> | ||
| 16 | </properties> | ||
| 17 | </SQLDriver> | ||
| 18 | {{/code}} | ||
| 19 | |||
| 20 | You’ll have to restart the server |