0 Replies Latest reply on Jul 4, 2012 11:43 AM by bottleneck

    Error with DataSource definition

    bottleneck

      Hi,

       

      The issue I have been facing lately (inspite of following the documentation and suggestions) is the same one stated at https://community.jboss.org/message/640246?_sscc=t

      Had posted my reply there but was skeptical about whether or not any answered post would be looked at. Hence starting a new discussiont.

       

       

      After following the steps mentioned in the earlier post and the AS doumentation, the datasource creation somehow doesn't work for me.


      I'm trying to create an oracle data source by creating a module and defining a data-source in the standalone.xml, though, with no success.

       

      Here's stating my configurations.

       

      1. module.xml ( @ jboss-as-web-7.0.2.Final\modules\com\oracle\ojdbc6\main )

      <?xml version="1.0" encoding="UTF-8"?>
      <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>

       

      2. ojdbc6.jar ( @ jboss-as-web-7.0.2.Final\modules\com\oracle\ojdbc6\main )

       

      3. Data-source definiation in standalone.xml
      ....
      <datasource jndi-name="java:/OracleDS" pool-name="OracleDS">
        <connection-url>jdbc:oracle:thin:@host:port:SID</connection-url>
        <driver>ojdbc6</driver>
        <pool>
         <min-pool-size>5</min-pool-size>
         <max-pool-size>10</max-pool-size>
         <prefill>true</prefill>
        </pool>
        <security>
         <user-name>Username</user-name>
         <password>password</password>
        </security>
      </datasource>
      <drivers>
        <driver name="ojdbc6" module="com.oracle.ojdbc6">
         <xa-datasource-class>
          oracle.jdbc.xa.client.OracleXADataSource
         </xa-datasource-class>
        </driver>
        <driver name="h2" module="com.h2database.h2">
         <xa-datasource-class>
          org.h2.jdbcx.JdbcDataSource
         </xa-datasource-class>
        </driver>
      </drivers>

      I know this might sound stupid, but I still get the error when server starts saying -  New missing/unsatisfied dependencies:service jboss.jdbc-driver.ojdbc6 (missing)

      Would appreciate if you could point out my mistake, if any.

       

      Have attached the error trace snapshot