[jboss-user] [JBoss Messaging] - Re: MQ migration help
konami
do-not-reply at jboss.com
Wed Feb 11 00:29:22 EST 2009
"tnine" wrote :
|
| Steps to migrate DefaultDS to MySQL and set up messaging.
|
|
| | * Download the latest MySQL client jar and put it in server/lib
| | * Set up the following in a mysql-ds.xml file, and remove the hsqldb-ds.xml file
| |
| |
| |
| | | <datasources>
| | | <local-tx-datasource>
| | | <jndi-name>DefaultDS</jndi-name>
| | | <connection-url>
| | | jdbc:mysql://localhost:3306/jboss
| | | </connection-url>
| | | <driver-class>com.mysql.jdbc.Driver</driver-class>
| | | <user-name>jboss</user-name>
| | | <password>password</password>
| | | <exception-sorter-class-name>
| | | org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
| | | </exception-sorter-class-name>
| | | <metadata>
| | | <type-mapping>mySQL</type-mapping>
| | | </metadata>
| | | <!-- Required for Messaging to work correctly -->
| | | <transaction-isolation>
| | | TRANSACTION_READ_COMMITTED
| | | </transaction-isolation>
| | | </local-tx-datasource>
| | |
| | | </datasources>
| | |
| |
| | * Download the messaging distribution that has the same version as the one in your application server. For the JEMS 1.2.1.CR4 installer, I installed messaging version 1.4.0.SP3 (build: CVSTag=JBossMessaging_1_4_0_
| | SP3 date=200712131418)
| |
| | * Copy mysql-persistence-service.xml from examples/config of your messaging download to server/deploy/jboss-messaging.sar, and either delete or rename hsqldb-persistence-service.xml.bak
| |
| | * Restart the server, and everything should work!
| |
Thanks for the tip. It worked for me.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4208826#4208826
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4208826
More information about the jboss-user
mailing list