1 2 Previous Next 15 Replies Latest reply on Nov 2, 2007 3:56 PM by earniedyke

    Problem starting Messaging in ESB 4.2.1.GA

    earniedyke

      Greetings all,

      I have ESB 4.2.1.GA installed and I am trying to configure it to use MySQL 5.0.41 on windows. I downloaded and copied mysql-persistence-service.xml to server\default\deploy\jboss-messaging.sar. I am getting an error in Messaging startup however that I have been unable to resolve.

      Any and all help will be greatly appreciated.

      Earnie!

      2007-11-02 14:44:47,031 ERROR [org.jboss.messaging.util.ExceptionUtil] org.jboss.messaging.core.jmx.JDBCPersistenceManagerService@f16568 startService
      java.lang.IllegalArgumentException: No such SQL statement: DELETE_MESSAGE
       at org.jboss.messaging.core.impl.JDBCSupport.getSQLStatement(JDBCSupport.java:183)
       at org.jboss.messaging.core.impl.JDBCSupport.start(JDBCSupport.java:123)
       at org.jboss.messaging.core.impl.JDBCPersistenceManager.start(JDBCPersistenceManager.java:141)
       at org.jboss.messaging.core.jmx.JDBCPersistenceManagerService.startService(JDBCPersistenceManagerService.java:91)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
       at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
       at $Proxy0.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:417)
       at org.jboss.system.ServiceController.start(ServiceController.java:435)
       at org.jboss.system.ServiceController.start(ServiceController.java:435)
       at org.jboss.system.ServiceController.start(ServiceController.java:435)
       at org.jboss.system.ServiceController.start(ServiceController.java:435)
       at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
       at $Proxy4.start(Unknown Source)
       at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
       at $Proxy30.start(Unknown Source)
       at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
       at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
       at $Proxy9.deploy(Unknown Source)
       at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
       at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
       at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
       at $Proxy0.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:417)
       at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
       at $Proxy4.start(Unknown Source)
       at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
       at $Proxy5.deploy(Unknown Source)
       at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
       at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
       at org.jboss.Main.boot(Main.java:200)
       at org.jboss.Main$1.run(Main.java:508)
       at java.lang.Thread.run(Thread.java:595)
      


      And here's the mysql-persistence-service.xml:

      <?xml version="1.0" encoding="UTF-8"?>
      
      <!--
       MySql persistence deployment descriptor.
      
       Tested with MySQL 4.1.22
      
       $Id$
       -->
      
      <server>
      
       <!-- Persistence Manager MBean configuration
       ======================================== -->
      
       <mbean code="org.jboss.messaging.core.jmx.JDBCPersistenceManagerService"
       name="jboss.messaging:service=PersistenceManager"
       xmbean-dd="xmdesc/JDBCPersistenceManager-xmbean.xml">
      
       <depends>jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
      
       <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
      
       <!-- The datasource to use for the persistence manager -->
      
       <attribute name="DataSource">java:/DefaultDS</attribute>
      
       <!-- If true will attempt to create tables and indexes on every start-up -->
      
       <attribute name="CreateTablesOnStartup">true</attribute>
      
       <!-- If true then will use JDBC batch updates -->
      
       <attribute name="UsingBatchUpdates">true</attribute>
      
       <attribute name="SqlProperties"><![CDATA[
       CREATE_DUAL=CREATE TABLE JBM_DUAL (DUMMY INTEGER, PRIMARY KEY (DUMMY)) ENGINE = INNODB
       CREATE_MESSAGE_REFERENCE=CREATE TABLE JBM_MSG_REF (CHANNEL_ID BIGINT, MESSAGE_ID BIGINT, TRANSACTION_ID BIGINT, STATE CHAR(1), ORD BIGINT, PAGE_ORD BIGINT, DELIVERY_COUNT INTEGER, SCHED_DELIVERY BIGINT, PRIMARY KEY(CHANNEL_ID, MESSAGE_ID)) ENGINE = INNODB
       CREATE_IDX_MESSAGE_REF_TX=CREATE INDEX JBM_MSG_REF_TX ON JBM_MSG_REF (TRANSACTION_ID)
       CREATE_IDX_MESSAGE_REF_ORD=CREATE INDEX JBM_MSG_REF_ORD ON JBM_MSG_REF (ORD)
       CREATE_IDX_MESSAGE_REF_PAGE_ORD=CREATE INDEX JBM_MSG_REF_PAGE_ORD ON JBM_MSG_REF (PAGE_ORD)
       CREATE_IDX_MESSAGE_REF_MESSAGE_ID=CREATE INDEX JBM_MSG_REF_MESSAGE_ID ON JBM_MSG_REF (MESSAGE_ID)
       CREATE_IDX_MESSAGE_REF_SCHED_DELIVERY=CREATE INDEX JBM_MSG_REF_SCHED_DELIVERY ON JBM_MSG_REF (SCHED_DELIVERY)
       CREATE_MESSAGE=CREATE TABLE JBM_MSG (MESSAGE_ID BIGINT, RELIABLE CHAR(1), EXPIRATION BIGINT, TIMESTAMP BIGINT, PRIORITY TINYINT, TYPE TINYINT, INS_TIME BIGINT, HEADERS MEDIUMBLOB, PAYLOAD LONGBLOB, PRIMARY KEY (MESSAGE_ID)) ENGINE = INNODB
       CREATE_IDX_MESSAGE_TIMESTAMP=CREATE INDEX JBM_MSG_REF_TIMESTAMP ON JBM_MSG (TIMESTAMP)
       CREATE_TRANSACTION=CREATE TABLE JBM_TX (NODE_ID INTEGER, TRANSACTION_ID BIGINT, BRANCH_QUAL VARBINARY(254), FORMAT_ID INTEGER, GLOBAL_TXID VARBINARY(254), PRIMARY KEY (TRANSACTION_ID)) ENGINE = INNODB
       CREATE_COUNTER=CREATE TABLE JBM_COUNTER (NAME VARCHAR(255), NEXT_ID BIGINT, PRIMARY KEY(NAME)) ENGINE = INNODB
       INSERT_DUAL=INSERT INTO JBM_DUAL VALUES (1)
       CHECK_DUAL=SELECT 1 FROM JBM_DUAL
       INSERT_MESSAGE_REF=INSERT INTO JBM_MSG_REF (CHANNEL_ID, MESSAGE_ID, TRANSACTION_ID, STATE, ORD, PAGE_ORD, DELIVERY_COUNT, SCHED_DELIVERY) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
       DELETE_MESSAGE_REF=DELETE FROM JBM_MSG_REF WHERE MESSAGE_ID=? AND CHANNEL_ID=? AND STATE='C'
       UPDATE_MESSAGE_REF=UPDATE JBM_MSG_REF SET TRANSACTION_ID=?, STATE='-' WHERE MESSAGE_ID=? AND CHANNEL_ID=? AND STATE='C'
       UPDATE_PAGE_ORDER=UPDATE JBM_MSG_REF SET PAGE_ORD = ? WHERE MESSAGE_ID=? AND CHANNEL_ID=?
       COMMIT_MESSAGE_REF1=UPDATE JBM_MSG_REF SET STATE='C', TRANSACTION_ID = NULL WHERE TRANSACTION_ID=? AND STATE='+'
       COMMIT_MESSAGE_REF2=DELETE FROM JBM_MSG_REF WHERE TRANSACTION_ID=? AND STATE='-'
       ROLLBACK_MESSAGE_REF1=DELETE FROM JBM_MSG_REF WHERE TRANSACTION_ID=? AND STATE='+'
       ROLLBACK_MESSAGE_REF2=UPDATE JBM_MSG_REF SET STATE='C', TRANSACTION_ID = NULL WHERE TRANSACTION_ID=? AND STATE='-'
       LOAD_PAGED_REFS=SELECT MESSAGE_ID, DELIVERY_COUNT, PAGE_ORD, SCHED_DELIVERY FROM JBM_MSG_REF WHERE CHANNEL_ID = ? AND PAGE_ORD BETWEEN ? AND ? ORDER BY PAGE_ORD
       LOAD_UNPAGED_REFS=SELECT MESSAGE_ID, DELIVERY_COUNT, SCHED_DELIVERY FROM JBM_MSG_REF WHERE STATE = 'C' AND CHANNEL_ID = ? AND PAGE_ORD IS NULL ORDER BY ORD
       LOAD_REFS=SELECT MESSAGE_ID, DELIVERY_COUNT, SCHED_DELIVERY FROM JBM_MSG_REF WHERE STATE = 'C' AND CHANNEL_ID = ? ORDER BY ORD
       UPDATE_REFS_NOT_PAGED=UPDATE JBM_MSG_REF SET PAGE_ORD = NULL WHERE PAGE_ORD BETWEEN ? AND ? AND CHANNEL_ID=?
       SELECT_MIN_MAX_PAGE_ORD=SELECT MIN(PAGE_ORD), MAX(PAGE_ORD) FROM JBM_MSG_REF WHERE CHANNEL_ID = ?
       SELECT_EXISTS_REF_MESSAGE_ID=SELECT MESSAGE_ID FROM JBM_MSG_REF WHERE MESSAGE_ID = ?
       UPDATE_DELIVERY_COUNT=UPDATE JBM_MSG_REF SET DELIVERY_COUNT = ? WHERE CHANNEL_ID = ? AND MESSAGE_ID = ?
       UPDATE_CHANNEL_ID=UPDATE JBM_MSG_REF SET CHANNEL_ID = ? WHERE CHANNEL_ID = ?
       LOAD_MESSAGES=SELECT MESSAGE_ID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, HEADERS, PAYLOAD, TYPE FROM JBM_MSG
       INSERT_MESSAGE=INSERT INTO JBM_MSG (MESSAGE_ID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, TYPE, INS_TIME, HEADERS, PAYLOAD) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
       INSERT_MESSAGE_CONDITIONAL=INSERT INTO JBM_MSG (MESSAGE_ID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, TYPE, INS_TIME) SELECT ?, ?, ?, ?, ?, ?, ? FROM JBM_DUAL WHERE NOT EXISTS (SELECT MESSAGE_ID FROM JBM_MSG WHERE MESSAGE_ID = ?)
       UPDATE_MESSAGE_4CONDITIONAL=UPDATE JBM_MSG SET HEADERS=?, PAYLOAD=? WHERE MESSAGE_ID=?
       INSERT_MESSAGE_CONDITIONAL_FULL=INSERT INTO JBM_MSG (MESSAGE_ID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, TYPE, INS_TIME, HEADERS, PAYLOAD) SELECT ?, ?, ?, ?, ?, ?, ?, ?, ? FROM JBM_DUAL WHERE NOT EXISTS (SELECT MESSAGE_ID FROM JBM_MSG WHERE MESSAGE_ID = ?)
       MESSAGE_ID_COLUMN=MESSAGE_ID
       DELETE_MESSAGE=DELETE FROM JBM_MSG WHERE MESSAGE_ID = ? AND NOT EXISTS (SELECT * FROM JBM_MSG_REF WHERE JBM_MSG_REF.MESSAGE_ID = ?)
       REAP_MESSAGES=DELETE FROM JBM_MSG WHERE INS_TIME < ? AND NOT EXISTS (SELECT * FROM JBM_MSG_REF WHERE JBM_MSG_REF.MESSAGE_ID = JBM_MSG.MESSAGE_ID)
       INSERT_TRANSACTION=INSERT INTO JBM_TX (NODE_ID, TRANSACTION_ID, BRANCH_QUAL, FORMAT_ID, GLOBAL_TXID) VALUES(?, ?, ?, ?, ?)
       DELETE_TRANSACTION=DELETE FROM JBM_TX WHERE NODE_ID = ? AND TRANSACTION_ID = ?
       SELECT_PREPARED_TRANSACTIONS=SELECT TRANSACTION_ID, BRANCH_QUAL, FORMAT_ID, GLOBAL_TXID FROM JBM_TX WHERE NODE_ID = ?
       SELECT_MESSAGE_ID_FOR_REF=SELECT MESSAGE_ID, CHANNEL_ID FROM JBM_MSG_REF WHERE TRANSACTION_ID = ? AND STATE = '+' ORDER BY ORD
       SELECT_MESSAGE_ID_FOR_ACK=SELECT MESSAGE_ID, CHANNEL_ID FROM JBM_MSG_REF WHERE TRANSACTION_ID = ? AND STATE = '-' ORDER BY ORD
       UPDATE_COUNTER=UPDATE JBM_COUNTER SET NEXT_ID = ? WHERE NAME=?
       SELECT_COUNTER=SELECT NEXT_ID FROM JBM_COUNTER WHERE NAME=? FOR UPDATE
       INSERT_COUNTER=INSERT INTO JBM_COUNTER (NAME, NEXT_ID) VALUES (?, ?)
       SELECT_ALL_CHANNELS=SELECT DISTINCT(CHANNEL_ID) FROM JBM_MSG_REF
       UPDATE_TX=UPDATE JBM_TX SET NODE_ID=? WHERE NODE_ID=?
       ]]></attribute>
      
       <!-- The maximum number of parameters to include in a prepared statement -->
      
       <attribute name="MaxParams">500</attribute>
      
       </mbean>
      
       <!-- Messaging Post Office MBean configuration
       ========================================= -->
      
       <mbean code="org.jboss.messaging.core.jmx.MessagingPostOfficeService"
       name="jboss.messaging:service=PostOffice"
       xmbean-dd="xmdesc/MessagingPostOffice-xmbean.xml">
      
       <depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends>
      
       <depends>jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
      
       <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
      
       <!-- The name of the post office -->
      
       <attribute name="PostOfficeName">JMS post office</attribute>
      
       <!-- The datasource used by the post office to access it's binding information -->
      
       <attribute name="DataSource">java:/DefaultDS</attribute>
      
       <!-- If true will attempt to create tables and indexes on every start-up -->
      
       <attribute name="CreateTablesOnStartup">true</attribute>
      
       <attribute name="SqlProperties"><![CDATA[
      CREATE_POSTOFFICE_TABLE=CREATE TABLE JBM_POSTOFFICE (POSTOFFICE_NAME VARCHAR(255), NODE_ID INTEGER, QUEUE_NAME VARCHAR(255), COND VARCHAR(1023), SELECTOR VARCHAR(1023), CHANNEL_ID BIGINT, CLUSTERED CHAR(1), ALL_NODES CHAR(1), PRIMARY KEY(POSTOFFICE_NAME, NODE_ID, QUEUE_NAME)) ENGINE = INNODB
      INSERT_BINDING=INSERT INTO JBM_POSTOFFICE (POSTOFFICE_NAME, NODE_ID, QUEUE_NAME, COND, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
      DELETE_BINDING=DELETE FROM JBM_POSTOFFICE WHERE POSTOFFICE_NAME=? AND NODE_ID=? AND QUEUE_NAME=?
      LOAD_BINDINGS=SELECT QUEUE_NAME, COND, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE POSTOFFICE_NAME=? AND NODE_ID=?
       ]]></attribute>
      
       <!-- This post office is clustered. If you don't want a clustered post office then set to false -->
      
       <attribute name="Clustered">true</attribute>
      
       <!-- All the remaining properties only have to be specified if the post office is clustered.
       You can safely comment them out if your post office is non clustered -->
      
       <!-- The JGroups group name that the post office will use -->
      
       <attribute name="GroupName">${jboss.messaging.groupname:MessagingPostOffice}</attribute>
      
       <!-- Max time to wait for state to arrive when the post office joins the cluster -->
      
       <attribute name="StateTimeout">5000</attribute>
      
       <!-- Max time to wait for a synchronous call to node members using the MessageDispatcher -->
      
       <attribute name="CastTimeout">50000</attribute>
      
       <!-- JGroups stack configuration for the data channel - used for sending data across the cluster -->
      
       <!-- By default we use the TCP stack for data -->
       <attribute name="DataChannelConfig">
       <config>
       <TCP start_port="7900"
       loopback="true"
       recv_buf_size="20000000"
       send_buf_size="640000"
       discard_incompatible_packets="true"
       max_bundle_size="64000"
       max_bundle_timeout="30"
       use_incoming_packet_handler="true"
       use_outgoing_packet_handler="false"
       down_thread="false" up_thread="false"
       enable_bundling="false"
       use_send_queues="false"
       sock_conn_timeout="300"
       skip_suspected_members="true"/>
       <MPING timeout="4000"
       bind_to_all_interfaces="true"
       mcast_addr="${jboss.messaging.datachanneludpaddress:228.6.6.6}"
       mcast_port="${jboss.messaging.datachanneludpport:45567}"
       ip_ttl="8"
       num_initial_members="2"
       num_ping_requests="1"/>
       <MERGE2 max_interval="100000"
       down_thread="false" up_thread="false" min_interval="20000"/>
       <FD_SOCK down_thread="false" up_thread="false"/>
       <VERIFY_SUSPECT timeout="1500" down_thread="false" up_thread="false"/>
       <pbcast.NAKACK max_xmit_size="60000"
       use_mcast_xmit="false" gc_lag="0"
       retransmit_timeout="300,600,1200,2400,4800"
       down_thread="false" up_thread="false"
       discard_delivered_msgs="true"/>
       <pbcast.STABLE stability_delay="1000" desired_avg_gossip="50000"
       down_thread="false" up_thread="false"
       max_bytes="400000"/>
       <pbcast.GMS print_local_addr="true" join_timeout="3000"
       down_thread="false" up_thread="false"
       join_retry_timeout="2000" shun="false"
       view_bundling="true"/>
       </config>
       </attribute>
      
       <!-- JGroups stack configuration to use for the control channel - used for control messages -->
      
       <!-- We use udp stack for the control channel -->
       <attribute name="ControlChannelConfig">
       <config>
       <UDP
       mcast_addr="${jboss.messaging.controlchanneludpaddress:228.7.7.7}"
       mcast_port="${jboss.messaging.controlchanneludpport:45568}"
       tos="8"
       ucast_recv_buf_size="20000000"
       ucast_send_buf_size="640000"
       mcast_recv_buf_size="25000000"
       mcast_send_buf_size="640000"
       loopback="false"
       discard_incompatible_packets="true"
       max_bundle_size="64000"
       max_bundle_timeout="30"
       use_incoming_packet_handler="true"
       use_outgoing_packet_handler="false"
       ip_ttl="2"
       down_thread="false" up_thread="false"
       enable_bundling="false"/>
       <PING timeout="2000"
       down_thread="false" up_thread="false" num_initial_members="3"/>
       <MERGE2 max_interval="100000"
       down_thread="false" up_thread="false" min_interval="20000"/>
       <FD_SOCK down_thread="false" up_thread="false"/>
       <FD timeout="10000" max_tries="5" down_thread="false" up_thread="false" shun="true"/>
       <VERIFY_SUSPECT timeout="1500" down_thread="false" up_thread="false"/>
       <pbcast.NAKACK max_xmit_size="60000"
       use_mcast_xmit="false" gc_lag="0"
       retransmit_timeout="300,600,1200,2400,4800"
       down_thread="false" up_thread="false"
       discard_delivered_msgs="true"/>
       <UNICAST timeout="300,600,1200,2400,3600"
       down_thread="false" up_thread="false"/>
       <pbcast.STABLE stability_delay="1000" desired_avg_gossip="50000"
       down_thread="false" up_thread="false"
       max_bytes="400000"/>
       <pbcast.GMS print_local_addr="true" join_timeout="3000" use_flush="true" flush_timeout="3000"
       down_thread="false" up_thread="false"
       join_retry_timeout="2000" shun="false"
       view_bundling="true"/>
       <FRAG2 frag_size="60000" down_thread="false" up_thread="false"/>
       <pbcast.STATE_TRANSFER down_thread="false" up_thread="false" use_flush="true" flush_timeout="3000"/>
       <pbcast.FLUSH down_thread="false" up_thread="false" timeout="20000" auto_flush_conf="false"/>
       </config>
       </attribute>
      
       </mbean>
      
       <!-- Messaging JMS User Manager MBean config
       ======================================= -->
      
       <mbean code="org.jboss.jms.server.plugin.JDBCJMSUserManagerService"
       name="jboss.messaging:service=JMSUserManager"
       xmbean-dd="xmdesc/JMSUserManager-xmbean.xml">
       <depends>jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
       <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
       <attribute name="DataSource">java:/DefaultDS</attribute>
       <attribute name="CreateTablesOnStartup">true</attribute>
       <attribute name="SqlProperties"><![CDATA[
      CREATE_USER_TABLE=CREATE TABLE JBM_USER (USER_ID VARCHAR(32) NOT NULL, PASSWD VARCHAR(32) NOT NULL, CLIENTID VARCHAR(128), PRIMARY KEY(USER_ID)) ENGINE = INNODB
      CREATE_ROLE_TABLE=CREATE TABLE JBM_ROLE (ROLE_ID VARCHAR(32) NOT NULL, USER_ID VARCHAR(32) NOT NULL, PRIMARY KEY(USER_ID, ROLE_ID)) ENGINE = INNODB
      SELECT_PRECONF_CLIENTID=SELECT CLIENTID FROM JBM_USER WHERE USER_ID=?
      POPULATE.TABLES.1=INSERT INTO JBM_USER (USER_ID,PASSWD,CLIENTID) VALUES ('dilbert','dogbert','dilbert-id')
       ]]></attribute>
       </mbean>
      
      </server>
      


        • 1. Re: Problem starting Messaging in ESB 4.2.1.GA
          beve

          Hi,

          I think we have had this issue on the ESB User forum today: http://www.jboss.com/index.html?module=bb&op=viewtopic&t=122818&postdays=0&postorder=asc&start=10

          Can you take a look and see if this applies to your case aswell?

          Regards,

          Daniel

          • 2. Re: Problem starting Messaging in ESB 4.2.1.GA
            earniedyke

            Thanks Daniel for the quick response. I read the posts and it seems to me the problem was resolved by installing mysql 5.0. I am already running 5.0 :-(

            Any other suggestions?

            Earnie!

            • 3. Re: Problem starting Messaging in ESB 4.2.1.GA
              timfox

              Hi-

              Where did you get your mysql-persistence-service.xml from? Looks like you're using an old version.

              Also what version of JBM are you using?

              Thx

              • 4. Re: Problem starting Messaging in ESB 4.2.1.GA
                beve

                Yeah, the problem was that we had the wrong version of mysql-persistence-service.xml but when using this version of it things worked:

                <?xml version="1.0" encoding="UTF-8"?>
                
                <!--
                 MySql persistence deployment descriptor.
                
                 Tested with MySQL 4.1.22
                
                 $Id$
                 -->
                
                <server>
                
                 <!-- Persistence Manager MBean configuration
                 ======================================== -->
                
                 <mbean code="org.jboss.messaging.core.jmx.JDBCPersistenceManagerService"
                 name="jboss.messaging:service=PersistenceManager"
                 xmbean-dd="xmdesc/JDBCPersistenceManager-xmbean.xml">
                
                 <depends>jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
                
                 <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
                
                 <!-- The datasource to use for the persistence manager -->
                
                 <attribute name="DataSource">java:/DefaultDS</attribute>
                
                 <!-- If true will attempt to create tables and indexes on every start-up -->
                
                 <attribute name="CreateTablesOnStartup">true</attribute>
                
                 <!-- If true then will use JDBC batch updates -->
                
                 <attribute name="UsingBatchUpdates">true</attribute>
                
                 <attribute name="SqlProperties"><![CDATA[
                 CREATE_DUAL=CREATE TABLE JBM_DUAL (DUMMY INTEGER, PRIMARY KEY (DUMMY)) ENGINE = INNODB
                 CREATE_MESSAGE_REFERENCE=CREATE TABLE JBM_MSG_REF (CHANNEL_ID BIGINT, MESSAGE_ID BIGINT, TRANSACT
                ION_ID BIGINT, STATE CHAR(1), ORD BIGINT, PAGE_ORD BIGINT, DELIVERY_COUNT INTEGER, SCHED_DELIVERY BI
                GINT, PRIMARY KEY(CHANNEL_ID, MESSAGE_ID)) ENGINE = INNODB
                 CREATE_IDX_MESSAGE_REF_TX=CREATE INDEX JBM_MSG_REF_TX ON JBM_MSG_REF (TRANSACTION_ID)
                 CREATE_IDX_MESSAGE_REF_ORD=CREATE INDEX JBM_MSG_REF_ORD ON JBM_MSG_REF (ORD)
                 CREATE_IDX_MESSAGE_REF_PAGE_ORD=CREATE INDEX JBM_MSG_REF_PAGE_ORD ON JBM_MSG_REF (PAGE_ORD)
                 CREATE_IDX_MESSAGE_REF_MESSAGE_ID=CREATE INDEX JBM_MSG_REF_MESSAGE_ID ON JBM_MSG_REF (MESSAGE_ID)
                
                 CREATE_IDX_MESSAGE_REF_SCHED_DELIVERY=CREATE INDEX JBM_MSG_REF_SCHED_DELIVERY ON JBM_MSG_REF (SCH
                ED_DELIVERY)
                 CREATE_MESSAGE=CREATE TABLE JBM_MSG (MESSAGE_ID BIGINT, RELIABLE CHAR(1), EXPIRATION BIGINT, TIME
                STAMP BIGINT, PRIORITY TINYINT, TYPE TINYINT, INS_TIME BIGINT, HEADERS MEDIUMBLOB, PAYLOAD LONGBLOB,
                 PRIMARY KEY (MESSAGE_ID)) ENGINE = INNODB
                 CREATE_IDX_MESSAGE_TIMESTAMP=CREATE INDEX JBM_MSG_REF_TIMESTAMP ON JBM_MSG (TIMESTAMP)
                 CREATE_TRANSACTION=CREATE TABLE JBM_TX (NODE_ID INTEGER, TRANSACTION_ID BIGINT, BRANCH_QUAL VARBI
                NARY(254), FORMAT_ID INTEGER, GLOBAL_TXID VARBINARY(254), PRIMARY KEY (TRANSACTION_ID)) ENGINE = INN
                ODB
                 CREATE_COUNTER=CREATE TABLE JBM_COUNTER (NAME VARCHAR(255), NEXT_ID BIGINT, PRIMARY KEY(NAME)) EN
                GINE = INNODB
                 INSERT_DUAL=INSERT INTO JBM_DUAL VALUES (1)
                 CHECK_DUAL=SELECT 1 FROM JBM_DUAL
                 INSERT_MESSAGE_REF=INSERT INTO JBM_MSG_REF (CHANNEL_ID, MESSAGE_ID, TRANSACTION_ID, STATE, ORD, P
                AGE_ORD, DELIVERY_COUNT, SCHED_DELIVERY) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
                 DELETE_MESSAGE_REF=DELETE FROM JBM_MSG_REF WHERE MESSAGE_ID=? AND CHANNEL_ID=? AND STATE='C'
                 UPDATE_MESSAGE_REF=UPDATE JBM_MSG_REF SET TRANSACTION_ID=?, STATE='-' WHERE MESSAGE_ID=? AND CHAN
                NEL_ID=? AND STATE='C'
                 UPDATE_PAGE_ORDER=UPDATE JBM_MSG_REF SET PAGE_ORD = ? WHERE MESSAGE_ID=? AND CHANNEL_ID=?
                 COMMIT_MESSAGE_REF1=UPDATE JBM_MSG_REF SET STATE='C', TRANSACTION_ID = NULL WHERE TRANSACTION_ID=
                ? AND STATE='+'
                 COMMIT_MESSAGE_REF2=DELETE FROM JBM_MSG_REF WHERE TRANSACTION_ID=? AND STATE='-'
                 ROLLBACK_MESSAGE_REF1=DELETE FROM JBM_MSG_REF WHERE TRANSACTION_ID=? AND STATE='+'
                 ROLLBACK_MESSAGE_REF2=UPDATE JBM_MSG_REF SET STATE='C', TRANSACTION_ID = NULL WHERE TRANSACTION_I
                D=? AND STATE='-'
                 LOAD_PAGED_REFS=SELECT MESSAGE_ID, DELIVERY_COUNT, PAGE_ORD, SCHED_DELIVERY FROM JBM_MSG_REF WHER
                E CHANNEL_ID = ? AND PAGE_ORD BETWEEN ? AND ? ORDER BY PAGE_ORD
                 LOAD_UNPAGED_REFS=SELECT MESSAGE_ID, DELIVERY_COUNT, SCHED_DELIVERY FROM JBM_MSG_REF WHERE STATE
                = 'C' AND CHANNEL_ID = ? AND PAGE_ORD IS NULL ORDER BY ORD
                 LOAD_REFS=SELECT MESSAGE_ID, DELIVERY_COUNT, SCHED_DELIVERY FROM JBM_MSG_REF WHERE STATE = 'C' AN
                D CHANNEL_ID = ? ORDER BY ORD
                 UPDATE_REFS_NOT_PAGED=UPDATE JBM_MSG_REF SET PAGE_ORD = NULL WHERE PAGE_ORD BETWEEN ? AND ? AND C
                HANNEL_ID=?
                 SELECT_MIN_MAX_PAGE_ORD=SELECT MIN(PAGE_ORD), MAX(PAGE_ORD) FROM JBM_MSG_REF WHERE CHANNEL_ID = ?
                
                 SELECT_EXISTS_REF_MESSAGE_ID=SELECT MESSAGE_ID FROM JBM_MSG_REF WHERE MESSAGE_ID = ?
                 UPDATE_DELIVERY_COUNT=UPDATE JBM_MSG_REF SET DELIVERY_COUNT = ? WHERE CHANNEL_ID = ? AND MESSAGE_
                ID = ?
                 UPDATE_CHANNEL_ID=UPDATE JBM_MSG_REF SET CHANNEL_ID = ? WHERE CHANNEL_ID = ?
                 LOAD_MESSAGES=SELECT MESSAGE_ID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, HEADERS, PAYLOAD, TYP
                E FROM JBM_MSG
                 INSERT_MESSAGE=INSERT INTO JBM_MSG (MESSAGE_ID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, TYPE,
                INS_TIME, HEADERS, PAYLOAD) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
                 INSERT_MESSAGE_CONDITIONAL=INSERT INTO JBM_MSG (MESSAGE_ID, RELIABLE, EXPIRATION, TIMESTAMP, PRIO
                RITY, TYPE, INS_TIME) SELECT ?, ?, ?, ?, ?, ?, ? FROM JBM_DUAL WHERE NOT EXISTS (SELECT MESSAGE_ID F
                ROM JBM_MSG WHERE MESSAGE_ID = ?)
                 UPDATE_MESSAGE_4CONDITIONAL=UPDATE JBM_MSG SET HEADERS=?, PAYLOAD=? WHERE MESSAGE_ID=?
                 INSERT_MESSAGE_CONDITIONAL_FULL=INSERT INTO JBM_MSG (MESSAGE_ID, RELIABLE, EXPIRATION, TIMESTAMP,
                 PRIORITY, TYPE, INS_TIME, HEADERS, PAYLOAD) SELECT ?, ?, ?, ?, ?, ?, ?, ?, ? FROM JBM_DUAL WHERE NO
                T EXISTS (SELECT MESSAGE_ID FROM JBM_MSG WHERE MESSAGE_ID = ?)
                 MESSAGE_ID_COLUMN=MESSAGE_ID
                 REAP_MESSAGES=DELETE FROM JBM_MSG WHERE INS_TIME < ? AND NOT EXISTS (SELECT * FROM JBM_MSG_REF WHERE JBM_MSG_REF.MESSAGE_ID = JBM_MSG.MESSAGE_ID)
                 DELETE_MESSAGE=DELETE FROM JBM_MSG WHERE MESSAGE_ID = ? AND NOT EXISTS (SELECT * FROM JBM_MSG_REF
                 WHERE JBM_MSG_REF.MESSAGE_ID = ?)
                 INSERT_TRANSACTION=INSERT INTO JBM_TX (NODE_ID, TRANSACTION_ID, BRANCH_QUAL, FORMAT_ID, GLOBAL_TX
                ID) VALUES(?, ?, ?, ?, ?)
                 DELETE_TRANSACTION=DELETE FROM JBM_TX WHERE NODE_ID = ? AND TRANSACTION_ID = ?
                 SELECT_PREPARED_TRANSACTIONS=SELECT TRANSACTION_ID, BRANCH_QUAL, FORMAT_ID, GLOBAL_TXID FROM JBM_
                TX WHERE NODE_ID = ?
                 SELECT_MESSAGE_ID_FOR_REF=SELECT MESSAGE_ID, CHANNEL_ID FROM JBM_MSG_REF WHERE TRANSACTION_ID = ?
                 AND STATE = '+' ORDER BY ORD
                 SELECT_MESSAGE_ID_FOR_ACK=SELECT MESSAGE_ID, CHANNEL_ID FROM JBM_MSG_REF WHERE TRANSACTION_ID = ?
                 AND STATE = '-' ORDER BY ORD
                 UPDATE_COUNTER=UPDATE JBM_COUNTER SET NEXT_ID = ? WHERE NAME=?
                 SELECT_COUNTER=SELECT NEXT_ID FROM JBM_COUNTER WHERE NAME=? FOR UPDATE
                 INSERT_COUNTER=INSERT INTO JBM_COUNTER (NAME, NEXT_ID) VALUES (?, ?)
                 SELECT_ALL_CHANNELS=SELECT DISTINCT(CHANNEL_ID) FROM JBM_MSG_REF
                 UPDATE_TX=UPDATE JBM_TX SET NODE_ID=? WHERE NODE_ID=?
                 ]]></attribute>
                
                 <!-- The maximum number of parameters to include in a prepared statement -->
                
                 <attribute name="MaxParams">500</attribute>
                
                 </mbean>
                
                 <!-- Messaging Post Office MBean configuration
                 ========================================= -->
                
                 <mbean code="org.jboss.messaging.core.jmx.MessagingPostOfficeService"
                 name="jboss.messaging:service=PostOffice"
                 xmbean-dd="xmdesc/MessagingPostOffice-xmbean.xml">
                
                 <depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer</depends>
                
                 <depends>jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
                
                 <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
                
                 <!-- The name of the post office -->
                
                 <attribute name="PostOfficeName">JMS post office</attribute>
                
                 <!-- The datasource used by the post office to access it's binding information -->
                
                 <attribute name="DataSource">java:/DefaultDS</attribute>
                
                 <!-- If true will attempt to create tables and indexes on every start-up -->
                
                 <attribute name="CreateTablesOnStartup">true</attribute>
                
                 <attribute name="SqlProperties"><![CDATA[
                CREATE_POSTOFFICE_TABLE=CREATE TABLE JBM_POSTOFFICE (POSTOFFICE_NAME VARCHAR(255), NODE_ID INTEGER,
                QUEUE_NAME VARCHAR(255), COND VARCHAR(1023), SELECTOR VARCHAR(1023), CHANNEL_ID BIGINT, CLUSTERED CH
                AR(1), ALL_NODES CHAR(1), PRIMARY KEY(POSTOFFICE_NAME, NODE_ID, QUEUE_NAME)) ENGINE = INNODB
                INSERT_BINDING=INSERT INTO JBM_POSTOFFICE (POSTOFFICE_NAME, NODE_ID, QUEUE_NAME, COND, SELECTOR, CHA
                NNEL_ID, CLUSTERED, ALL_NODES) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
                DELETE_BINDING=DELETE FROM JBM_POSTOFFICE WHERE POSTOFFICE_NAME=? AND NODE_ID=? AND QUEUE_NAME=?
                LOAD_BINDINGS=SELECT QUEUE_NAME, COND, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFIC
                E WHERE POSTOFFICE_NAME=? AND NODE_ID=?
                 ]]></attribute>
                
                 <!-- This post office is clustered. If you don't want a clustered post office then set to false -->
                
                 <attribute name="Clustered">true</attribute>
                
                 <!-- All the remaining properties only have to be specified if the post office is clustered.
                 You can safely comment them out if your post office is non clustered -->
                
                 <!-- The JGroups group name that the post office will use -->
                
                 <attribute name="GroupName">${jboss.messaging.groupname:MessagingPostOffice}</attribute>
                
                 <!-- Max time to wait for state to arrive when the post office joins the cluster -->
                
                 <attribute name="StateTimeout">5000</attribute>
                
                 <!-- Max time to wait for a synchronous call to node members using the MessageDispatcher -->
                
                 <attribute name="CastTimeout">50000</attribute>
                
                 <!-- JGroups stack configuration for the data channel - used for sending data across the cluster -->
                
                 <!-- By default we use the TCP stack for data -->
                 <attribute name="DataChannelConfig">
                 <config>
                 <TCP start_port="7900"
                 loopback="true"
                 recv_buf_size="20000000"
                 send_buf_size="640000"
                 discard_incompatible_packets="true"
                 max_bundle_size="64000"
                 max_bundle_timeout="30"
                 use_incoming_packet_handler="true"
                 use_outgoing_packet_handler="false"
                 down_thread="false" up_thread="false"
                 enable_bundling="false"
                 use_send_queues="false"
                 sock_conn_timeout="300"
                 skip_suspected_members="true"/>
                 <MPING timeout="4000"
                 bind_to_all_interfaces="true"
                 mcast_addr="${jboss.messaging.datachanneludpaddress:228.6.6.6}"
                 mcast_port="${jboss.messaging.datachanneludpport:45567}"
                 ip_ttl="8"
                 num_initial_members="2"
                 num_ping_requests="1"/>
                 <MERGE2 max_interval="100000"
                 down_thread="false" up_thread="false" min_interval="20000"/>
                 <FD_SOCK down_thread="false" up_thread="false"/>
                 <VERIFY_SUSPECT timeout="1500" down_thread="false" up_thread="false"/>
                 <pbcast.NAKACK max_xmit_size="60000"
                 use_mcast_xmit="false" gc_lag="0"
                 retransmit_timeout="300,600,1200,2400,4800"
                 down_thread="false" up_thread="false"
                 discard_delivered_msgs="true"/>
                 <pbcast.STABLE stability_delay="1000" desired_avg_gossip="50000"
                 down_thread="false" up_thread="false"
                 max_bytes="400000"/>
                 <pbcast.GMS print_local_addr="true" join_timeout="3000"
                 down_thread="false" up_thread="false"
                 join_retry_timeout="2000" shun="false"
                 view_bundling="true"/>
                 </config>
                 </attribute>
                
                 <!-- JGroups stack configuration to use for the control channel - used for control messages -->
                
                 <!-- We use udp stack for the control channel -->
                 <attribute name="ControlChannelConfig">
                 <config>
                 <UDP
                 mcast_addr="${jboss.messaging.controlchanneludpaddress:228.7.7.7}"
                 mcast_port="${jboss.messaging.controlchanneludpport:45568}"
                 tos="8"
                 ucast_recv_buf_size="20000000"
                 ucast_send_buf_size="640000"
                 mcast_recv_buf_size="25000000"
                 mcast_send_buf_size="640000"
                 loopback="false"
                 discard_incompatible_packets="true"
                 max_bundle_size="64000"
                 max_bundle_timeout="30"
                 use_incoming_packet_handler="true"
                 use_outgoing_packet_handler="false"
                 ip_ttl="2"
                 down_thread="false" up_thread="false"
                 enable_bundling="false"/>
                 <PING timeout="2000"
                 down_thread="false" up_thread="false" num_initial_members="3"/>
                 <MERGE2 max_interval="100000"
                 down_thread="false" up_thread="false" min_interval="20000"/>
                 <FD_SOCK down_thread="false" up_thread="false"/>
                 <FD timeout="10000" max_tries="5" down_thread="false" up_thread="false" shun="true"/>
                 <VERIFY_SUSPECT timeout="1500" down_thread="false" up_thread="false"/>
                 <pbcast.NAKACK max_xmit_size="60000"
                 use_mcast_xmit="false" gc_lag="0"
                 retransmit_timeout="300,600,1200,2400,4800"
                 down_thread="false" up_thread="false"
                 discard_delivered_msgs="true"/>
                 <UNICAST timeout="300,600,1200,2400,3600"
                 down_thread="false" up_thread="false"/>
                 <pbcast.STABLE stability_delay="1000" desired_avg_gossip="50000"
                 down_thread="false" up_thread="false"
                 max_bytes="400000"/>
                 <pbcast.GMS print_local_addr="true" join_timeout="3000" use_flush="true" flush_timeout="3000"
                 down_thread="false" up_thread="false"
                 join_retry_timeout="2000" shun="false"
                 view_bundling="true"/>
                 <FRAG2 frag_size="60000" down_thread="false" up_thread="false"/>
                 <pbcast.STATE_TRANSFER down_thread="false" up_thread="false" use_flush="true" flush_timeout="3000"/>
                 <pbcast.FLUSH down_thread="false" up_thread="false" timeout="20000" auto_flush_conf="false"/>
                 </config>
                 </attribute>
                
                 </mbean>
                
                 <!-- Messaging JMS User Manager MBean config
                 ======================================= -->
                
                 <mbean code="org.jboss.jms.server.plugin.JDBCJMSUserManagerService"
                 name="jboss.messaging:service=JMSUserManager"
                 xmbean-dd="xmdesc/JMSUserManager-xmbean.xml">
                 <depends>jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
                 <depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager</depends>
                 <attribute name="DataSource">java:/DefaultDS</attribute>
                 <attribute name="CreateTablesOnStartup">true</attribute>
                 <attribute name="SqlProperties"><![CDATA[
                CREATE_USER_TABLE=CREATE TABLE JBM_USER (USER_ID VARCHAR(32) NOT NULL, PASSWD VARCHAR(32) NOT NULL,
                CLIENTID VARCHAR(128), PRIMARY KEY(USER_ID)) ENGINE = INNODB
                CREATE_ROLE_TABLE=CREATE TABLE JBM_ROLE (ROLE_ID VARCHAR(32) NOT NULL, USER_ID VARCHAR(32) NOT NULL,
                 PRIMARY KEY(USER_ID, ROLE_ID)) ENGINE = INNODB
                SELECT_PRECONF_CLIENTID=SELECT CLIENTID FROM JBM_USER WHERE USER_ID=?
                POPULATE.TABLES.1=INSERT INTO JBM_USER (USER_ID,PASSWD,CLIENTID) VALUES ('dilbert','dogbert','dilber
                t-id')
                 ]]></attribute>
                 </mbean>
                
                </server>
                


                Can you check that your version of this file has the same contents as pasted above?

                Thanks,

                Daniel

                • 5. Re: Problem starting Messaging in ESB 4.2.1.GA
                  earniedyke

                  I downloaded jboss-messaging-1.4-0.SP1.zip an hour ago and extracted it. I moved the DELETE_MESSAGE line up one 1 in the file to see if the error changed. That's the only thing I have done to it.

                  Earnie!

                  • 6. Re: Problem starting Messaging in ESB 4.2.1.GA
                    timfox

                     

                    "earniedyke" wrote:
                    I downloaded jboss-messaging-1.4-0.SP1.zip an hour ago and extracted it. I moved the DELETE_MESSAGE line up one 1 in the file to see if the error changed. That's the only thing I have done to it.



                    You must be using an older version of the config. Try copying over the version from SP1 again.

                    • 7. Re: Problem starting Messaging in ESB 4.2.1.GA
                      timfox

                       

                      "beve" wrote:
                      Yeah, the problem was that we had the wrong version of mysql-persistence-service.xml but when using this version of it things worked:


                      The correct version to use for 1.4.0.SP1 is the version in the examples/config directory of the 1.4.0.SP1 distribution.

                      • 8. Re: Problem starting Messaging in ESB 4.2.1.GA
                        earniedyke

                        OK, but according to the ESB 4.2.1.GA release notes, the version of Messaging is 1.4.0.GA. Is that perhaps the problem? I can't find 1.4.0.GA to download though.

                        Earnie!

                        • 9. Re: Problem starting Messaging in ESB 4.2.1.GA
                          timfox

                          I don't know what version of JBM ESB is using. You better ask the ESB guys that. :)

                          But the correct config to use is the one from the examples/config directory of whatever version it is using.

                          I would certainly recommend using 1.4.0.SP1 over 1.4.0.GA though. Upgrading is very simple and explained in the release announcment for 1.4.0.SP1 on this forum.

                          • 10. Re: Problem starting Messaging in ESB 4.2.1.GA
                            beve

                            Hi Tim,

                            the file contents pasted in this post is from 1.4.0.SP1 and from the examples/config directory.

                            JBossESB is using 1.4.0.GA.

                            I just thought that as the error message was the same as in the other thread you were having the same issue.

                            /Daniel

                            • 11. Re: Problem starting Messaging in ESB 4.2.1.GA
                              timfox

                              1.4.0.SP1 config won't work with 1.4.0.GA and vice versa.

                              You need to make sure you're using the correct version.

                              • 12. Re: Problem starting Messaging in ESB 4.2.1.GA
                                earniedyke

                                Tim,

                                I found 1.4.0.GA and downloaded it, copied over mysql-persistence-service.xml and it is working now. Must be very particular about things. Thanks for the help!!!!

                                Earnie!

                                • 13. Re: Problem starting Messaging in ESB 4.2.1.GA
                                  timfox

                                   

                                  "earniedyke" wrote:
                                  Tim,

                                  I found 1.4.0.GA and downloaded it, copied over mysql-persistence-service.xml and it is working now. Must be very particular about things. Thanks for the help!!!!


                                  That's great. :)

                                  However I wouldn't recommend using 1.4.0.GA since it's been superceded by 1.4.0.SP1.

                                  1.4.0.GA works pretty well but we have made some important bug fixes since then.

                                  The reason 1.4.0.GA is not on the download list is we don't want to encourage people to use older versions.

                                  • 14. Re: Problem starting Messaging in ESB 4.2.1.GA
                                    beve

                                     

                                    1.4.0.SP1 config won't work with 1.4.0.GA and vice versa.


                                    Ah, ok! Good to know. Thanks!



                                    1 2 Previous Next