I am using JBoss 3.2.5. I want to change the database from hsql to MySql.For that I create mysql-ds.xml and remove hsqldb-ds.xml and also made changes in login-config.xml and other files as required.
Changes are as follows:
1.login-config.xml:add the following:
<application-policy name = "MySqlDbRealm">

<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name =
"principal">the_mysql_username</module-option>
<module-option name =
"userName">the_mysql_username</module-option>

<module-option name
="password">the_mysql_pass</module-option>
<module-option name =
"managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option>
</login-module>

</application-policy>


2.Replace hsqldb-jdbc-state-service.xml to mysql-jdbc-state-service.xml

3.Modify the file
[jboss-location]\server\default\conf\standardjbosscmp-jdbc.xml :

<datasource-mapping>mySQL</datasource-mapping>

4.Modify the file [jboss-location]\server\default\conf\standardjaws.xml:
java:/MySqlDS

Note:In mysql-ds.xml I used: <jndi-name>DefaultDS</jndi-name>




I got the following error message on console:

2007-08-06 13:16:15,859 ERROR [DLQHandler] Initialization failed DLQHandler
javax.jms.JMSException: Error creating the dlq connection: XAConnectionFactory n
ot bound
at org.jboss.ejb.plugins.jms.DLQHandler.createService(DLQHandler.java:17
1)
at org.jboss.system.ServiceMBeanSupport.jbossInternalCreate(ServiceMBean
Support.java:237)
at org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:
164)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker.innerCreate(JMSContaine
rInvoker.java:542)
at org.jboss.ejb.plugins.jms.JMSContainerInvoker.startService(JMSContain
erInvoker.java:764)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS
upport.java:271)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMB
eanSupport.java:221)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.
java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl
ler.java:837)


Please give me the advice to remove the above error for JBoss 3.2.5 . Thanks in advance