RemoveHSQLDB in Jboss 5.X.X

Version : jboss-eap-5.0 (enterprise-installer-5.0.0.GA.jar)

Performed these steps on default profile

• Remove the libraries hsqldb.jar and hsqldb-plugin.jar from jboss/common/lib/.

• Remove the descriptor for the HSQLDB datasource DefaultDS by deleting deploy/hsqldb-ds.xml;

• In conf/login-config.xml, comment out the declaration with the name "HsqlDbRealm";

Several services rely on the datasource defaultDS which point to HsqlDbRealm

• JBoss Messaging

• EJB Services (EJB Timer Service)

• Key Generator Services

We should remove above services, otherwise you will end up in dependency errors. Below are the steps to remove them

Remove JBoss Messaging

In server//deploy/ remove:

• messaging
• jms-ra.rar

In server//deployers/ remove:

• messaging-definitions-jboss-beans.xml

Remove EJB3 services

In server//deploy/ remove:

• ejb3-connections-jboss-beans.xml
• ejb3-container-jboss-beans.xml
• ejb3-interceptors-aop.xml
• ejb3-timerservice-jboss-beans.xml
• profile-service-secured.jar

In server//deployers/ remove

• jboss-ejb3-endpoint-deployer.jar

Remove EJB2 services

In server//deploy/ remove:

• ejb2-container-jboss-beans.xml
• ejb2-timer-service.xml (Note that EJB3 deployments may fail without this service. See this forum post)

Remove Key Generator

In server//deploy/ remove:

• uuid-key-generator.sar

Remove JBoss Mail

In server//deploy/ remove:

• mail-service.xml
• mail-ra.rar