The persistence manager of JBoss MQ uses the default datasource to create tables to store JMS messages, transaction data and other indexes. The DDLs used by this service are vendor-specific and should be updated accordingly as follows:

From docs/examples/jms, copy oracle-jdbc2-service.xml over to deploy/jms. Then delete the existing hsqldb-jdbc2-service.xml file located in the same folder. Last, make sure to point the service at the right datasource jndi name i.e. “DefaultDS”:

<mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager"
     name="jboss.mq:service=PersistenceManager">
<depends optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
....