1 Reply Latest reply on Nov 24, 2011 10:26 AM by wdfink

    Not able to configure datasource  in jboss as 7

    ank.bairathi

      Below is the configuration done.

       

      1) created the folder structure

      jboss-as-7.0.2.Final/modules/com/oracle/ojdbc6/main

       

      2) module.xml

       

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

        <resources>

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

        </resources>

        <dependencies>

          <module name="javax.api"/>

        </dependencies>

      </module>

       

      3) Datasource in standalone-ha.xml

       

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

                      <datasources>

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

                          <connection-url>jdbc:oracle:thinsick.tif(DESCRIPTIONfrown.tifADDRESS_LISTfrown.tifADDRESSfrown.tifPROTOCOL=TCP)(HOST=XXXX.corp.apple.com)(PORT=1803)))(CONNECT_DATAfrown.tifSID=XXXX)(SERVER=DEDICATED)))</connection-url>

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

                          <driver>com.oracle.ojdbc6</driver>

                          <pool>

                              <max-pool-size>100</max-pool-size>

                                                       <min-pool-size>5</min-pool-size>

                          </pool>

                          <security>

                              <user-name>xpuser</user-name>

                              <password>pass</password>

                          </security>

                      </datasource>

                      <drivers>

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

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

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

                          </driver>

                      </drivers>

                  </datasources>

       

       

       

      I am getting below error.

       

      12:19:01,049 INFO  [org.jboss.as.controller] (Controller Boot Thread) Service status report

         New missing/unsatisfied dependencies:

            service jboss.jdbc-driver.com_oracle_ojdbc6 (missing)

       

       

      Please please help!!!