IllegalStateException when switching JMS persistence configurations with JBoss EAP

Issue

• After replacing hsqldb-persistence-service.xml with mssql-persistence-service.xml in $JBOSS_HOME/server/$PROFILE/deploy/jboss-messaging.sar we receive this error message:

  ERROR [org.jboss.messaging.util.ExceptionUtil] (main) org.jboss.messaging.core.jmx.JDBCPersistenceManagerService@2c11c55b startService
  java.lang.IllegalStateException: SQL statement DELETE_CHANNEL_MESSAGE_REF is not specified in the SQL properties
          at org.jboss.messaging.core.impl.JDBCSupport.start(JDBCSupport.java:148)
          at org.jboss.messaging.core.impl.JDBCPersistenceManager.start(JDBCPersistenceManager.java:149)
          at org.jboss.messaging.core.jmx.JDBCPersistenceManagerService.startService(JDBCPersistenceManagerService.java:100)
  ...(snip)...
  ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.messaging:service=PersistenceManager state=Create mode=Manual requiredState=Installed
  java.lang.IllegalStateException: SQL statement DELETE_CHANNEL_MESSAGE_REF is not specified in the SQL properties
          at org.jboss.messaging.core.impl.JDBCSupport.start(JDBCSupport.java:148)
          at org.jboss.messaging.core.impl.JDBCPersistenceManager.start(JDBCPersistenceManager.java:149)
          at org.jboss.messaging.core.jmx.JDBCPersistenceManagerService.startService(JDBCPersistenceManagerService.java:100)
          at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
          at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:269)
  ...(snip)...