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

Document ID : KB000049776
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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.

Solution:

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>
    <jndi-name>DefaultDS</jndi-name>
    <connection-url>jdbc:sqlserver://mysqlserver:1433;DatabaseName=jbossmessaging
    </connection-url>
    <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
    <user-name>sa</user-name>
    <password>PASSWORD</password>
    <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.

    See http://docs.jboss.org/jbossas/docs/Installation_And_Getting_Started_Guide/5/html/Using_other_Databases.html

  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:

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

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

    Note: See https://issues.jboss.org/browse/JBAS-6333 and https://issues.jboss.org/browse/JBAS-6991.