[jboss-user] [Installation, Configuration & DEPLOYMENT] - Replacing Hypersonic with MSSQL 2005

[yarugn]

Hello all,

First post, so please be gentle :)

This is JBoss 4.0.5GA. I need to use this version as an enterprise application we are using is only qualified on this version of JBoss.

I'm trying to replace Hypersonic with MSSQL. I have got it working for a server instance that is a copy of "default". However, when I try exactly the same process on an instance that is a copy of "all" I run into an error message:

2008-10-22 16:52:24,146 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:

--- Incompletely deployed packages ---
org.jboss.deployment.DeploymentInfo at 7d090637 { url=file:/opt/jboss-4.0.5.GA/server/ps1/deploy/jms/hsqldb-jdbc-state-service.xml }
  deployer: org.jboss.deployment.SARDeployer at 9cb0f4
  status: Deployment FAILED reason: Trying to install an already registered mbean: jboss.mq:service=StateManager
  state: FAILED
  watch: file:/opt/jboss-4.0.5.GA/server/ps1/deploy/jms/hsqldb-jdbc-state-service.xml
  altDD: null
  lastDeployed: 1224690696016
  lastModified: 1224690696000
  mbeans:

org.jboss.deployment.DeploymentInfo at af9cbd21 { url=file:/opt/jboss-4.0.5.GA/server/ps1/deploy/jms/mssql-jdbc2-service.xml }
  deployer: org.jboss.deployment.SARDeployer at 9cb0f4
  status: Deployment FAILED reason: Trying to install an already registered mbean: jboss.mq:service=DestinationManager
  state: FAILED
  watch: file:/opt/jboss-4.0.5.GA/server/ps1/deploy/jms/mssql-jdbc2-service.xml
  altDD: null
  lastDeployed: 1224690696025
  lastModified: 1224690696000
  mbeans:

org.jboss.deployment.DeploymentInfo at 2e1a665a { url=file:/opt/jboss-4.0.5.GA/server/ps1/deploy/atg-sqlserver-dw-ds.xml }
  deployer: org.jboss.deployment.XSLSubDeployer at 1da366c
  status: Deployment FAILED reason: Trying to install an already registered mbean: jboss.jca:service=LocalTxCM,name=ATGDWDS
  state: FAILED
  watch: file:/opt/jboss-4.0.5.GA/server/ps1/deploy/atg-sqlserver-dw-ds.xml
  altDD: null
  lastDeployed: 1224690697448
  lastModified: 1224690697000
  mbeans:

--- MBeans waiting for other MBeans ---
ObjectName: jboss.mq:service=PersistenceManager
  State: FAILED
  Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions.  Message recovery may not be accurate; - nested throwable: (com.microsoft.
sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.)
  I Depend On:
    jboss.jca:service=DataSourceBinding,name=DefaultDS
  Depends On Me:
    jboss.mq:service=DestinationManager

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.mq:service=PersistenceManager
  State: FAILED
  Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions.  Message recovery may not be accurate; - nested throwable: (com.microsoft.
sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.)
  I Depend On:
    jboss.jca:service=DataSourceBinding,name=DefaultDS
  Depends On Me:
    jboss.mq:service=DestinationManager

The steps I took were:

1) Installed the correct JDBC driver
2) Deploy a new datasource descriptor (<jndi-name>DefaultDS</jndi-name>)
3) Removed deploy/hsqldb-ds.xml
4) Removed hsqldb.jar and hsqldb-plugin.jar from the server's lib directory
5) Copied /docs/examples/jms/mssql-jdbc2-service.xml to each server instance's deploy/jms directory. Then changed the DataSourceBinding name to DefaultDS:
...
<depends optional-attribute-
name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=DefaultDS
...

Anyone know why the process above works for "default", but not "all"? Also, is there a solution for this error?

Why is the contents of the "default/deploy/jms" different then "all/deploy/jms"?

ls -al /opt/jboss-4.0.5.GA/server/default/deploy/jms/
total 113
drwxr-xr-x  3 jboss jboss   400 2006-10-23 18:00 .
drwxr-xr-x 11 jboss jboss  1136 2006-10-23 18:00 ..
-rw-r--r--  1 jboss jboss  5449 2006-10-23 18:00 hsqldb-jdbc2-service.xml
-rw-r--r--  1 jboss jboss  3680 2006-10-23 18:00 hsqldb-jdbc-state-service.xml
-rw-r--r--  1 jboss jboss  4113 2006-10-23 18:00 jbossmq-destinations-service.xml
drwxr-xr-x  4 jboss jboss   112 2006-10-23 18:00 jbossmq-httpil.sar
-rw-r--r--  1 jboss jboss  3901 2006-10-23 18:00 jbossmq-service.xml
-rw-r--r--  1 jboss jboss  2416 2006-10-23 18:00 jms-ds.xml
-rw-r--r--  1 jboss jboss 76000 2006-10-23 18:00 jms-ra.rar
-rw-r--r--  1 jboss jboss   600 2006-10-23 18:00 jvm-il-service.xml
-rw-r--r--  1 jboss jboss  4096 2006-10-23 18:00 uil2-service.xml

ls -al /opt/jboss-4.0.5.GA/server/all/deploy/jms/
total 81
drwxr-xr-x  2 jboss jboss   120 2006-10-23 17:59 .
drwxr-xr-x 15 jboss jboss  1400 2006-10-23 18:00 ..
-rw-r--r--  1 jboss jboss  2684 2006-10-23 17:59 hajndi-jms-ds.xml
-rw-r--r--  1 jboss jboss 76000 2006-10-23 17:59 jms-ra.rar

For what it is worth, I went through these steps with an Oracle database before and don't recall seeing these errors.

Thanks in advance for any replies!

Nes

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4183932#4183932

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4183932