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

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.