9 Replies Latest reply on Oct 23, 2013 2:01 PM by sri.is03

    how to add oracle datasource in JBossEAP6.1

    sri.is03

      Hi All,

       

      I tried to add a datasource for oracle db in Jboss EAP6.1. But I am getting below error and seeing error while 'Testing a db connection in server'.

       

      Pls let me know if I have missed something.

       

      Step 1-> Added below datasource in standalone.xml file

      Step 2-> Created a module.xml file and placed under \modules folder as com\oracle

      Here is my module.xml file

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

          <resources>

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

          </resources>

          <dependencies>

              <module name="javax.api"/>

          </dependencies>

      </module>

       

      Step 3-> Copied a ojdbc14.jar file in the com\oracle location.

      Step 4-> Started the server by standalone.bat file

                ---------------------------------------    

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

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

                          <driver>oracle</driver>

                          <security>

                              <user-name>username</user-name>

                              <password>password</password>

                          </security>

                      </datasource>

                      <drivers>

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

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

                          </driver>

                      </drivers>

      </datasources>

      ---------------------------------------

       

      Error on console:

      -----------------------------------

      JBAS014775:    New missing/unsatisfied dependencies:

            service jboss.jdbc-driver.oracle (missing) dependents: [service jboss.driver-demander.java:jboss/datasources/OracleDS, service jboss.data-source.java:jboss/datasources/Oracle

      DS]

      ---------------------------------

       

      Below the error seen when we click on 'Test the DB Connection' in server under 'DataSource' link.

       

      Internal Server Error

      {

        "outcome" => "failed",

        "failure-description" => "JBAS010440: failed to invoke operation: JBAS010442: failed to match pool. Check JndiName: java:jboss/datasources/OracleDS",

        "rolled-back" => true

      }

       

      Thanks in advance.