Jboss 7 AS and SQL-Server DataSource.
dkumaran Oct 10, 2011 9:16 AMWe 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.