JBoss Community

Data Source Configuration in AS 7

new comment by Prasad Deshpande View all comments on this document

Can anyone please give me an example for Oracle DS (XA & standard) at the same time? I tried using example, but I get error:

 

10:02:22,640 ERROR [org.jboss.as] (MSC service thread 1-2) JBoss AS 7.0.0.Beta2 "Fools' Day" started (with errors) in 2328ms - Started 92 of 119 services (3 services failed or missing dependencies, 24 servic

es are passive or on-demand)

    Services missing dependencies:

        service jboss.data-source.java:/jdbc/eFpNonXADataSource

        service jboss.data-source.reference-factory.java:/jdbc/eFpNonXADataSource

        service jboss.naming.context.java.java:/jdbc/eFpNonXADataSource

 

Here is my module

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

  <resources>

    <resource-root path="files"/>

    <resource-root path="ojdbc-14.0.jar"/>

  </resources>

  <dependencies>

    <module name="javax.api"/>

  </dependencies>

</module>

 

module does get deployed:

10:26:30,811 INFO  [org.jboss.as.connector.subsystems.datasources] Deploying JDBC-compliant driver class oracle.jdbc.driver.OracleDriver (version 10.2)

 

Here is my DS definition:

<datasource jndi-name="jdbc/eFpNonXADataSource" pool-name="eFpNonXADataSource" enabled="true" use-java-context="true">

    <connection-url>jdbc:oracle:thin:@xp003452:1521:PROCESS</connection-url>

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

    <driver>oracle.jdbc.driver.OracleDriver#14.0</driver>

    <pool><min-pool-size>10</min-pool-size><max-pool-size>30</max-pool-size></pool>

    <security><user-name>P</user-name><password>P</password></security>

</datasource>

           <drivers>

                <driver module="oracle.jdbc.driver"/>

            </drivers>