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

[Carlo de Wolf (JIRA)]

    [ https://issues.jboss.org/browse/AS7-5985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12736289#comment-12736289 ] 

Carlo de Wolf commented on AS7-5985:
------------------------------------

Please use the https://community.jboss.org/en/jbossas7 forum if you have configuration issues using community AS.

For EAP issues, please file a support case on your subscription at the customer portal https://access.redhat.com/home.
                
> 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
>            Assignee: Carlo de Wolf
>              Labels: 7.0.2
>
>  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