Return-Path: Delivered-To: apmail-activemq-users-archive@www.apache.org Received: (qmail 75041 invoked from network); 6 Mar 2007 15:45:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 6 Mar 2007 15:45:08 -0000 Received: (qmail 65550 invoked by uid 500); 6 Mar 2007 15:45:16 -0000 Delivered-To: apmail-activemq-users-archive@activemq.apache.org Received: (qmail 65527 invoked by uid 500); 6 Mar 2007 15:45:16 -0000 Mailing-List: contact users-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@activemq.apache.org Delivered-To: mailing list users@activemq.apache.org Received: (qmail 65518 invoked by uid 99); 6 Mar 2007 15:45:15 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Mar 2007 07:45:15 -0800 X-ASF-Spam-Status: No, hits=0.9 required=10.0 tests=FORGED_YAHOO_RCVD,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates 72.21.53.35 as permitted sender) Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 06 Mar 2007 07:45:02 -0800 Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1HObqB-00070o-3c for users@activemq.apache.org; Tue, 06 Mar 2007 07:44:39 -0800 Message-ID: <9334616.post@talk.nabble.com> Date: Tue, 6 Mar 2007 07:44:39 -0800 (PST) From: =?UTF-8?Q?Mat=C3=ADas_Cobiella?= To: users@activemq.apache.org Subject: Re: [Spam: 5.0] JDBC Master-Slave problem with DB2 In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Nabble-From: matiascobiella@yahoo.com References: <9321910.post@talk.nabble.com> X-Virus-Checked: Checked by ClamAV on apache.org Let me see. I'll try to find the correct syntax.=20 Could you tell me which SQL statement currently are using AMQ for DB2 to ge= t the exclusive lock? James.Strachan wrote: >=20 > This looks like a DB2 issue; the SQL we execute to get an exclusive > lock on the database does not appear to work propertly - we'll > probably have to tweak it for DB2. Fancy helping to figure out the > correct DB2 syntax to get an exclusive lock? >=20 >=20 > On 3/5/07, Mat=C3=ADas Cobiella wrote: >> >> 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= : >> org.apache.commons.dbcp.BasicDataSource@60991f >> 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= : >> org.apache.commons.dbcp.BasicDataSource@f47396 >> INFO TransportServerThreadSupport - Listening for connections at: >> tcp://MT13412:22222 >> >> >> Both Brokers uses this db config: >> >> > class=3D"org.apache.commons.dbcp.BasicDataSource"> >> >> >> >> >> >> >> >> >> 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=C3=ADas. >> -- >> 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. >> >> >=20 >=20 > --=20 >=20 > James > ------- > http://radio.weblogs.com/0112098/ >=20 >=20 --=20 View this message in context: http://www.nabble.com/JDBC-Master-Slave-probl= em-with-DB2-tf3352149s2354.html#a9334616 Sent from the ActiveMQ - User mailing list archive at Nabble.com.