1 Reply Latest reply on Jul 8, 2015 7:31 AM by Wolfgang Mayer

    datasource configuration and test connection problem


      Hi All,


      I configured oracle data source and while testing from jboss cli it is giving error like not valid test connection.In the JBOSS Admin console I am not getting the Test Connection button.


      I configured under /root/JBossEAP6.0/jboss-eap-6.0/modules/

      I created folder structure com/oracle/main/




      <?xml version="1.0" ?>



      <module xmlns="urn:jboss:module:1.1" name="com.oracle">




              <resource-root path="ojdbc6.jar"/>





              <module name="javax.api"/>

              <module name="javax.transaction.api"/>




      I added ojdbc6.jar in this folder structure.


      In my domain.xml the following changes are done


      <subsystem xmlns="urn:jboss:domain:datasources:1.1">


                          <datasource jndi-name="java:jboss/datasources/OracleDS" pool-name="OracleDS" enabled="true" use-java-context="true">









                              <driver name="oracle" module="com.oracle">








      These are the correct DB credentials and URL is also correct.


      My domain.xml is under /root/JBossEAP6.0DomainInstance/master/domain/configuration



      I executed the below command and output is as below

      [domain@ /]  /host=masterOne/server=server-one-master/subsystem=datasources:installed-drivers-list


          "outcome" => "success",

          "result" => [{

              "driver-name" => "oracle",

              "deployment-name" => undefined,

              "driver-module-name" => "com.oracle",

              "module-slot" => "main",

              "driver-datasource-class-name" => "",

              "driver-xa-datasource-class-name" => "oracle.jdbc.xa.client.OracleXADataSource",

              "driver-class-name" => "oracle.jdbc.driver.OracleDriver",

              "driver-major-version" => 11,

              "driver-minor-version" => 2,

              "jdbc-compliant" => true




      Please suggest me what are the changes to be done.

        • 1. Re: datasource configuration and test connection problem
          Wolfgang Mayer Master

          Did you configure the jdbc-driver before adding the datasource?


          I'd suggest that you use jboss-cli or web console for adding jdbc-driver and datasources. This should reduce the risk of formal errors.

          It is correct that the Test Connection button is not available in 6.0.

          But you may use jboss-cli for these purposses like: /host=master/server=server-one/subsystem=datasources/data-source=OracleDS:test-connection-in-pool