[jboss-user] [Beginner's Corner] New message: "Re: MySQL 5.1 with JBoss ESB 5.0.0"

[Peter Johnson]

User development,

A new message was posted in the thread "MySQL 5.1 with JBoss ESB 5.0.0":

http://community.jboss.org/message/532531#532531

Author  : Peter Johnson
Profile : http://community.jboss.org/people/peterj

Message:
--------------------------------------------------------------
2010-03-16 08:55:48,519 WARN  [org.jboss.deployers.structure.spi.helpers.AbstractDeploymentContext] (main) Unable to register deployment mbean jboss.messaging:service=PersistenceManager
javax.management.InstanceAlreadyExistsException: jboss.deployment:id="jboss.messaging:service=PersistenceManager",type=Component already registered.
 
I'm not sure if that is a probllem or not. Try grepping the config files for jboss.messaging:service=PersistenceManager to see if you have multiple of them declared. 
 
2010-03-16 08:56:18,212 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONDITION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1
 
This sounds like you did not replace the server/xxx/deploy/messaging/hsqldb-persistence-service.xml with the one for MySQL, which you can find at docs/examples/jms/mysql-persistence-service.xml. (Or do you have both files in .../deploy/messaging? That could explain the first warning - you should have only one of these files.)

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/532531#532531