1 Reply Latest reply on Mar 8, 2013 11:13 AM by Sans Kum

    Jboss 7 AS and SQL-Server DataSource.

    kumaran d Newbie

      We are moving our application from Jboss 5.0 to Jboss 7 AS. In our application we were using SQL Server backend and using the jtds.ds.jar in JBoss 5.0



      As part of creating the datasource and deploy the application i have followed the below steps.


      Deploying  the SQL-Server jar


           1. Start the Jboss 7AS using standalone.bat.

           2. Go to the admin "Manage Deployment" console  (

           3. Deploy the sqljdbc4.jar


      Creating the Datasource


           1. Go to Datasource web-console (

           2. Create the Datasource named TESTDS


      and i can see in the console


      17:50:58,878 INFO  [org.jboss.as.connector] (MSC service thread 1-1) Starting JCA Subsystem (JBoss IronJacamar 1.0.0.CR2)

      17:50:58,987 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) Bound data source [java:TESTDS]

      17:50:58,987 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) Bound data source [java:jboss/datasources/ExampleDS]

      17:50:59,175 INFO  [org.jboss.as.deployment] (MSC service thread 1-1) Started FileSystemDeploymentService for directoryD:\Project\jboss-as-7.0.0.Final\standalone\deployments

      17:50:59,190 INFO  [org.jboss.as] (Controller Boot Thread) JBoss AS 7.0.0.Final "Lightning" started in 3171ms - Started

      101 of 156 services (55 services are passive or on-demand)

      17:52:14,659 INFO  [org.jboss.as.server.deployment] (HttpManagementService-threads - 4) Content added at location D:\Pro


      17:52:33,909 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) Starting deployment of "sqljdbc4.jar"

      17:52:35,394 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) Deploying JDBC-compliant driver class com.microsoft.sqlserver.jdbc.SQLServerDriver (version 3.0)

      17:52:35,409 INFO  [org.jboss.as.server.controller] (HttpManagementService-threads - 4) Deployed "sqljdbc4.jar"

      17:54:17,456 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) Bound data source [TESTDS]



      Deploying the application


           1. Go to Deployment console  (

           2. Deploy the application which expects the TESTDS to available ..


      but i am getting the below error message in the console.


      18:11:24,487 INFO  [org.jboss.weld.Version] (MSC service thread 1-3) WELD-000900 1.1.2 (AS7)

      18:11:24,519 INFO  [org.jboss.weld] (MSC service thread 1-3) Starting weld service

      18:11:25,222 INFO  [org.jboss.as.server.controller] (HttpManagementService-threads - 10) Deployment of "core-api-1

      .0.0.1-SNAPSHOT.war" was rolled back with failure message {"Services with missing/unavailable dependencies" =>


      s.deployment.unit.\"core-api-\".jndiDependencyService missing [ jboss.naming.context.java.modu

      le.\"core-api-\".\"core-api-\".env/persistence/TestJpaUnit ]","jboss.persis

      tenceunit.\"core-api-\" missing [ jboss.naming.context.java.java:TESTDS ]"]}

      18:11:25,237 INFO  [org.jboss.weld] (MSC service thread 1-3) Stopping weld service

      18:11:34,472 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) Stopped deployment core-api-

      NAPSHOT.war in 9257ms



      please help me out in creating the proper DataSource and it's binding...  and please point out if i missing any steps.