search cancel

How to move from Hypersonic JBoss 5 messaging database to MSSql or to Oracle in an Identity Manager 12.5 context.


Article ID: 49776


Updated On:


CA Directory CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On CA Security Command Center CA Data Protection (DataMinder) CA User Activity Reporting



Since SP7, IM is running on JBOSS 5.1.x (Open source) & 5.0.x (Enterprise Edition) Now JBOSS 5 Messaging supersedes JBOSS MQ as the default Java Message Service (JMS) provider.

Some Clients have experienced problems to move from HSQL to MSSQL or to Oracle in this new context.

There were some issues with JBOSS failing to start in JMS activation.


Note: This has been tested with IM r12.5 SP8, JBOSS 5.1.0 (non-clustered) on W2K8 and MSSQL 2008 and Oracle 11g R2.

  1. Replace the jboss-5.1.0\server\default\deploy\hsqldb-ds.xml JNDI data source file by your mssql-ds.xml if moving to MSsql or by oracle-ds.xml if you want to move to Oracle.

    e.g. of mssql-ds.xml:

    <?xml version="1.0" encoding="UTF-8"?>
    <datasources> <local-tx-datasource>
    <check-valid-connection-sql>SELECT 1 FROM sysobjects</check-valid-connection-sql> <metadata> <type-mapping>MS SQLSERVER2000</type-mapping> </metadata> </local-tx-datasource> </datasources>

    Note: Change mysqlserver and jbossmessaging in connection-url tag by your values.

    Change <user-name> and <password> tag values by yours.


  2. Replace jboss-5.1.0\server\default\deploy\messaging\hsqldb-persistence-service.xml file by

    mssql-persistence-service.xml file coming from jboss-5.1.0\docs\examples\jms folder.

    Or if you want to move to Oracle then replace hsqldb-persistence-service.xml by oracle-persistence-service.xml also coming from jboss-5.1.0\docs\examples\jms folder.

  3. Edit this server\default\deploy\messaging\mssql-persistence-service.xml file Or oracle-persistence-service.xml in Oracle case.

    Change the depends attribute "ChannelFactoryName" to a simple attribute as following:

    <depends optional-attribute-name="ChannelFactoryName">jboss.jgroups:service=ChannelFactory</depends>

    <attribute name="ChannelFactoryName">jboss.jgroups:service=ChannelFactory</attribute>

    Note: See and


Component: IDMGR