Getting connection error for Oracle XA datasource while non-XA works
Issue
- After creating an XA datasource, while checking the connection using the below CLI command, we get WARN messages -
CLI command:
/subsystem=datasources/xa-data-source=OracleXA_DS:test-connection-in-pool
WARN [org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService$MyXaMCF] (management-handler-thread - 4) Exception trying to create valid connection checker (disabling):: java.lang.Exception: Unable to load: org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.loadPlugin(BaseWrapperManagedConnectionFactory.java:1027) [ironjacamar-jdbc-1.0.13.Final-redhat-1.jar:1.0.13.Final-redhat-1]
....
....
The Datasource has following entries -
....
<validation>
<valid-connection-checker class-name="org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker"/>
<background-validation-millis>30000000</background-validation-millis>
<stale-connection-checker class-name="org.jboss.resource.adapter.jdbc.vendor.OracleStaleConnectionChecker"/>
<exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"/>
</validation>
....
Environment
- JBoss Enterprise Application Platform (EAP)
- 6.0.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.