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  (http://127.0.0.1:9990/console/App.html)

     3. Deploy the sqljdbc4.jar

 

Creating the Datasource

 

     1. Go to Datasource web-console (http://127.0.0.1:9990/console/App.html#server/datasources)

     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

ject\jboss-as-7.0.0.Final\standalone\data\content\7c\34c3a05707ae897d1b8fe4319736aef38670c6\content

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  (http://127.0.0.1:9990/console/App.html#deployment-list)

     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" =>

["jbos

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

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

tenceunit.\"core-api-1.0.0.1-SNAPSHOT.war#TestJpaUnit\" 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-1.0.0.1-S

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.