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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
