[jboss-user] [Beginners Corner] - Re: Please help with switching DefaultDS to MySql
jaikiran
do-not-reply at jboss.com
Thu Jan 31 04:18:46 EST 2008
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
More information about the jboss-user
mailing list