Hi, I have two brokers in a JDBC MASTER-SLAVE configuration with a DB2 database and I'm having the following problem:
When BrokerA starts it becomes the MASTER: INFO BrokerService - Using Persistence Adapter: JDBCPersistenceAdaptor(org.apache.commons.dbcp.BasicDataSource INFO BrokerService - ActiveMQ null JMS Message Broker (MASTER) is starting INFO BrokerService - For help or more information please see: http://incubator.apache.org/activemq/ INFO ManagementContext - JMX consoles can connect to service:jmx:rmi:///jndi/rmi://localhost:1299/jmxrmi INFO JDBCPersistenceAdapter - Database driver recognized: [ibm_db2_jdbc_universal_driver_architecture] INFO DefaultDatabaseLocker - Attempting to acquire the exclusive lock to become the Master broker INFO DefaultDatabaseLocker - Becoming the master on dataSource: [EMAIL PROTECTED] INFO TransportServerThreadSupport - Listening for connections at: tcp://MT13412:11111 But when BrokerB starts it becomes the MASTER too: INFO BrokerService - Using Persistence Adapter: JDBCPersistenceAdaptor(org.apache.commons.dbcp.BasicDataSource INFO BrokerService - ActiveMQ null JMS Message Broker (SLAVE) is starting INFO BrokerService - For help or more information please see: http://incubator.apache.org/activemq/ INFO ManagementContext - JMX consoles can connect to service:jmx:rmi:///jndi/rmi://localhost:12980/jmxrmi INFO JDBCPersistenceAdapter - Database driver recognized: [ibm_db2_jdbc_universal_driver_architecture] INFO DefaultDatabaseLocker - Attempting to acquire the exclusive lock to become the Master broker INFO DefaultDatabaseLocker - Becoming the master on dataSource: [EMAIL PROTECTED] INFO TransportServerThreadSupport - Listening for connections at: tcp://MT13412:22222 Both Brokers uses this db config: <bean id="db2datasource" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName" value="com.ibm.db2.jcc.DB2Driver"/> <property name="url" value="jdbc:db2://10.250.0.73:60152/DBCCCD"/> <property name="username" value="dbcccd"/> <property name="password" value="cccd00"/> </bean> I think this problem looks like a MySQL issue but for DB2: http://issues.apache.org/activemq/browse/AMQ-992 I'm using the 4.2 SNAPSHOT Am I doing something wrong? Or its a SQL bug for DB2. Thanks in Advance for your help. Matías. -- View this message in context: http://www.nabble.com/JDBC-Master-Slave-problem-with-DB2-tf3352149s2354.html#a9321910 Sent from the ActiveMQ - User mailing list archive at Nabble.com.
