JBoss Community

Not able to configure datasource in jboss as 7

created by Ankita Bairathi in Datasource Configuration - View the full discussion

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:thin sick.tif (DESCRIPTION frown.tif ADDRESS_LIST frown.tif ADDRESS frown.tif PROTOCOL=TCP)(HOST=XXXX.corp.apple.com)(PORT=1803)))(CONNECT_DATA frown.tif SID=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!!!

Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community