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.