[jboss-user] [JBoss Messaging] - Re: JBoss 5.0.0.GA on MySQL, migration problem

[PeterJ]

Configuring messaging to use MySQL instead of Hypersonic is a multi-step process. I imagine you missed a step or two. Here are the steps (hope it didn't forget any):

1) Place the JDBC JAR file into the server/xx/lib directory
2) Remove server/xxx/deploy/messaging/hsqldb-persistence-service.xml file
3) Copy mysql-persistence-service.xml to server/xxx/deploy/messaging/
4) If you don't need clustering, in mysql-persistence-service.xml set "Clustered" to false and comment out the "ChannelFactoryName" attribute.

Are you still using DefaultDS as the data source for messaging? If not, also add these steps:

4) Create a *-ds.xml file for your data source
5) Change DefaultDS to your data source name in  mysql-persistence-service.xml (there are 6 locations)


Also, did you see this:

anonymous wrote : SEE PREVIOUS ERRORS FOR DETAILS

What you posted is the deployment report which rarely contains any information on why things went wrong. Earlier in the console log there should be exception stack traces, with the first one being the most important. If the above instructions do not solve the problem, find and post that first exception (you might ave to increase the buffer size on your terminal window to prevent the exception from scrolling off the buffer).

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4196933#4196933

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4196933