[jboss-dev-forums] [JBoss AS7 Development] - Data Source Configuration in AS 7

[Prasad Deshpande]

Prasad Deshpande [http://community.jboss.org/people/prasad.deshpande] commented on the document

"Data Source Configuration in AS 7"

To view all comments on this document, visit: http://community.jboss.org/docs/DOC-16657#comment-6030

--------------------------------------------------
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>
--------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-dev-forums/attachments/20110407/2c5594ec/attachment.html