Uploaded image for project: 'Application Server 7'
  1. Application Server 7
  2. AS7-5985

accessing custom created datasources in JBOSS 7.1 in JBoss AS 7

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 7.1.1.Final
    • None

      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

            rhn-engineering-cdewolf Carlo de Wolf
            srinivas.bijjam Srinivas Reddy Bijjam (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: