[jboss-user] [JBoss Messaging] - Re: MQ migration help

[konami]

"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