[jboss-user] [Beginners Corner] - Re: Please help with switching DefaultDS to MySql

[jaikiran]

anonymous wrote : Caused by: java.sql.SQLException: Unexpected token JMS_MESSAGES, requires FROM in statement [DELETE JMS_MESSAGES FROM JMS_MESSAGES, JMS_TRANSACTIONS WHERE JMS_MESSAGES.TXID = JMS_TRANSACTIONS.TXID AND JMS_MESSAGES.TXOP=?]
  | at org.hsqldb.jdbc.Util.throwError(Unknown Source)
  | at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
  | at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) 

Delete the contents of %JBOSS_HOME%\server\xxx\data\hypersonic folder. JBoss (when HSqlDB is used) persists JMS related stuff in files under this folder. Restart JBoss.

anonymous wrote : 19:26:34,619 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS' 
  | 
  | ....
  | 
  | 19:26:34,888 ERROR [MainDeployer] Could not create deployment: file:/C:/jboss-4.2.2.GA/server/default/deploy/mysql-ds.xml
  | org.jboss.deployment.DeploymentException: Trying to install an already registered mbean: jboss.jca:service=LocalTxCM,name=DefaultDS

Looks like you did not delete the hsqldb-ds.xml file from your deploy folder as suggested in that wiki entry
anonymous wrote : 
  | Replace <jndi-name>MySqlDS</jndi-name> with your datasource name. If you choose to make mySQL your default database (DefaultDS), then call this DefaultDS and be sure to delete the example $JBOSS_HOME/server/xxx/deploy/hsqldb-ds.xml which is also configured to be DefaultDS.



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

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