[Beginners Corner] - Re: Please help with switching DefaultDS to MySql
by 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
18 years, 2 months
[Clustering/JBoss] - Using mod_jk in AS 4.2.1.GA
by ReKie
Hi all,
I am trying to build a cluster using IIS 6.0 and JBoss AS 4.2.1.GA. I read the clustering guides for 4.2.x and 5.0 beta (which are allmost the same) as well as the relevant wikipages.
In all documents I find to tell JBoss to use mod_jk to edit a specific jboss-service.xml
anonymous wrote : Edit the
| JBOSS_HOME/server/all/deploy/jbossweb-tomcat50.sar/META-INF/jboss-service.
| xml file (replace /all with your own server name). Locate the
| element with a name of UseJK, and set its value to true:
Unfortunately in JBoss 4.2.1.GA ther is no jbossweb-tomcat50.sar, and so of course no jboss-service.xml.
Am I missing something??? Did I not look close enough? Or is there an other way to tell JBoss to make use of mod_jk?
Thank you
Reinhard
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4125020#4125020
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4125020
18 years, 2 months