'Wildfly datasource jdbc connection became invalid suddenly from valid
I have configured jdbc datasource connection. It was valid previously but after some days it became invalid. If I restart server, then again It starts getting valid. What could be possible issue here. I have deployed ojdbc7.jar in console for connectivity to oracle database. I am able to connect through sql developer also but in wildfly only it became invalid after few days. Everytime, I cant restart server to solve this issue. I am using wildfly-21.0.2.Final Please need help here.
standalone.xml
<datasource jndi-name="java:/CLCIDataOra" pool-name="CLCIDataOra">
<connection-url>jdbc:oracle:thin:@{hostname}:1524:{sid}</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver>oracle</driver>
<security>
<user-name>{username}</user-name>
<password>{password}</password>
</security>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
<background-validation>true</background-validation>
<background-validation-millis>60000</background-validation-millis>
<stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"/>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
</validation>
</datasource>
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
