Return-Path: 
 <users-return-16861-apmail-activemq-users-archive=activemq.apache.org@activemq.apache.org>
Delivered-To: apmail-activemq-users-archive@www.apache.org
Received: (qmail 54540 invoked from network); 12 Nov 2008 00:38:44 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 12 Nov 2008 00:38:44 -0000
Received: (qmail 395 invoked by uid 500); 12 Nov 2008 00:38:51 -0000
Delivered-To: apmail-activemq-users-archive@activemq.apache.org
Received: (qmail 373 invoked by uid 500); 12 Nov 2008 00:38:51 -0000
Mailing-List: contact users-help@activemq.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@activemq.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@activemq.apache.org>
List-Post: <mailto:users@activemq.apache.org>
List-Id: <users.activemq.apache.org>
Reply-To: users@activemq.apache.org
Delivered-To: mailing list users@activemq.apache.org
Received: (qmail 362 invoked by uid 99); 12 Nov 2008 00:38:51 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Nov 2008 16:38:50 -0800
X-ASF-Spam-Status: No, hits=4.0 required=10.0
	tests=DNS_FROM_OPENWHOIS,FORGED_YAHOO_RCVD,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Nov 2008 00:37:30 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1L03kK-0001qY-OJ
	for users@activemq.apache.org; Tue, 11 Nov 2008 16:38:12 -0800
Message-ID: <20451739.post@talk.nabble.com>
Date: Tue, 11 Nov 2008 16:38:12 -0800 (PST)
From: skomarla <skomarla@yahoo.com>
To: users@activemq.apache.org
Subject: use of useDatabaseLock with jdbcPersistenceAdapter
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: skomarla@yahoo.com
X-Virus-Checked: Checked by ClamAV on apache.org


Hello everyone,

I'm experimenting with the jdbcPersistenceAdapter and want to understand the
intent of the attribute useDatabaseLock.  I couldn't dig up anything beyond
"Sets whether or not an exclusive database lock should be used to enable
JDBC Master/Slave. Enabled by default. "

I understand the master/slave aspect by setting it to true, but if i set it
to false, do i get an active/active setup in a cluster?

1) activemq 5.1.0 rar is embedded in JBoss 4.2.2
2) here is the relevant portions of broker-config.xml

<beans xmlns="http://activemq.apache.org/schema/core">
<bean xmlns=""
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"/>

  <bean xmlns="" id="jms-ds"
class="org.springframework.jndi.JndiObjectFactoryBean">
    <property name="jndiName">
       <value>java:/my-xa-ds</value>
    </property>
  </bean>

  <broker useJmx="true" brokerName="localhost">

<managementContext>
  <managementContext createConnector="false"/>
</managementContext>

   <persistenceAdapter>
      <jdbcPersistenceAdapter dataSource="#jms-ds"/>
   </persistenceAdapter>

    <transportConnectors>
      <transportConnector name="localhost" uri="tcp://skomarla:61616"/>
    </transportConnectors>
    <networkConnectors>
      <networkConnector uri="static://(tcp://localhost:61616)"/>
    </networkConnectors>
  </broker>

</beans>

When I have the file configured as above, AMQ obtains the master lock
(SQLServer 2005) and everything is fine and the db is used to store
messages. If I set useDatabaseLock="false" and use a persistent queue, all
the messages still end up in the db.. is this essentially allowing me to get
a master/master.. or rather active/active setup when if I cluster?

If no to the above, what can I do to achieve a master-master setup using a
common database. I've read up on networking the brokers and letting each
broker handle the message or pass it on, but that opens the potential of
message loss in the case of persistence failure (db or disk).  I don't want
to setup master/slave for each broker in the network since that doubles the
# of machines needed.

I know this is really two different questions, but thanks for any input.
-- 
View this message in context: http://www.nabble.com/use-of-useDatabaseLock-with-jdbcPersistenceAdapter-tp20451739p20451739.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.