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 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
