[jboss-jira] [JBoss JIRA] (AS7-5985) accessing custom created datasources in JBOSS 7.1 in JBoss AS 7

[Srinivas Reddy Bijjam (JIRA)]

Srinivas Reddy Bijjam created AS7-5985:
------------------------------------------

             Summary: accessing custom created datasources in JBOSS 7.1 in JBoss AS 7
                 Key: AS7-5985
                 URL: https://issues.jboss.org/browse/AS7-5985
             Project: Application Server 7
          Issue Type: Bug
    Affects Versions: 7.1.1.Final
         Environment: Windows XP and JBoss AS 7.2 Alpha1-SNAPSHOT
            Reporter: Srinivas Reddy Bijjam
            Priority: Critical


 I deployed my application in JBoss AS 7.2.0.Alpha1-SNAPSHOT and under standalone\deployments folders I placed
       -- test.ear
       --connector.xml
 I am getting this exception
[org.jboss.as.server] (ServerService Thread Pool -- 35) JBAS018559: Deployed "test.ear"
[org.jboss.as.server] (ServerService Thread Pool -- 35) JBAS018559: Deployed "connectors.xml"
[org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report
JBAS014775:    New missing/unsatisfied dependencies:
      service jboss.data-source.java:/dataSource-oraclePool (missing) dependents: [service jboss.deployment.subunit."test.ear"."testcmp.jar".component.DIInstObj.jdbc.store-manager.INIT,  JBAS014799: ... and 53 more ]
 
My database configuration in standalone-full.xml
<subsystem xmlns="urn:jboss:domain:datasources:1.1">
            <datasources>
                <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
                    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
                    <driver>h2</driver>
                    <security>
                        <user-name>sa</user-name>
                        <password>sa</password>
                    </security>
                </datasource>
                 <drivers>
                    <driver name="h2" module="com.h2database.h2">
                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                    </driver>
                    <driver name="ojdbc6" module="com.oracle.ojdbc6">
                        <driver-class>oracle.jdbc.OracleDriver</driver-class>
                        <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
                    </driver>
                    <driver name="sqljdbc4" module="com.sqlServer.jdbc">
                        <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
                    </driver>
                </drivers>
            </datasources>
        </subsystem>
 
connector-ds.xml

?xml version="1.0" encoding="UTF-8"?>
<datasources>
<xa-datasource enabled="true" jndi-name="java:/dataSource-oraclePool" pool-name="dataSource-oraclePool" type="javax.sql.DataSource" use-java-context="true">
<xa-datasource-property name="URL">jdbc:oracle:thin:@localhost:1521:orcl</xa-datasource-property>
<driver>ojdbc6</driver>
<xa-pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>20</max-pool-size>
<prefill>true</prefill>
<is-same-rm-override>false</is-same-rm-override>
<no-tx-separate-pools>true</no-tx-separate-pools>
</xa-pool>
<security>
<user-name>test</user-name>
<password>test</password>
</security>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
</xa-datasource>
</datasources>
 
my jboss-deployment-structure.xml
 
<jboss-deployment-structure>
<ear-subdeployments-isolated>false</ear-subdeployments-isolated>
<deployment>
        <dependencies>
                    <module name="javaee.api" export="true"/>
                    <module name="sun.jdk" export="true"/>
   <module name="javax.api" export="true"/>
                    <module name="com.oracle.ojdbc6" export="true"/>
                    <module name="com.sqlServer.jdbc" export="true"/>
        </dependencies>
   </deployment>  
</jboss-deployment-structure>
 
Regards
Srini

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira