4 Replies Latest reply on Aug 1, 2012 3:15 PM by pugsherpa

    When testing datasource: No handler for test-connection-in-pool at address

    loredana

      Hello,

       

      I have configured the oracle datasource, below you can see the configuration:

      standalone.xml

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

           <datasources>

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

                          <connection-url>jdbc:oracle:thin:@localhost:1521:C3S</connection-url>

                          <driver>oracle</driver>

                          <security>

                              <user-name>jboss</user-name>

                              <password>sysadm</password>

                          </security>

                      </datasource>

                      <drivers>

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

                              <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

                              <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>

                          </driver>

                      </drivers>

                  </datasources>

      </subsystem>

      In  $JBOSS_HOME/modules/com/oracle/jdbc/main I have copied the ojdbc6.jar and created the module.xml file.

      module.xml

      <?xml version="1.0" encoding="UTF-8"?>

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

        <resources>

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

        </resources>

        <dependencies>

          <module name="javax.api"/>

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

        </dependencies>

      </module>

       

       

      When I test if the datasource is correctly working

      /subsystem=datasources/datasource=java\:jboss\/datasources\/DefaultDS: test-connection-in-pool

       

      I receive the following message:

       

      {

          "outcome" => "failed",

          "failure-description" => "JBAS014739: No handler for test-connection-in-pool at address [

          (\"subsystem\" => \"datasources\"),

          (\"datasource\" => \"java:jboss/datasources/DefaultDS\")

      ]",

          "rolled-back" => true

      }

       

      Do you know what is wrong? Any suggestion would be greatly appeciated. Thank tou