Return-Path: 
 <users-return-21638-apmail-activemq-users-archive=activemq.apache.org@activemq.apache.org>
Delivered-To: apmail-activemq-users-archive@www.apache.org
Received: (qmail 973 invoked from network); 7 Dec 2009 20:15:47 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 7 Dec 2009 20:15:47 -0000
Received: (qmail 42959 invoked by uid 500); 7 Dec 2009 20:15:47 -0000
Delivered-To: apmail-activemq-users-archive@activemq.apache.org
Received: (qmail 42879 invoked by uid 500); 7 Dec 2009 20:15:46 -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 42867 invoked by uid 99); 7 Dec 2009 20:15:46 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Dec 2009 20:15:46 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.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; Mon, 07 Dec 2009 20:15:36 +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 1NHjzH-0006HI-7m
	for users@activemq.apache.org; Mon, 07 Dec 2009 12:15:15 -0800
Message-ID: <26683387.post@talk.nabble.com>
Date: Mon, 7 Dec 2009 12:15:15 -0800 (PST)
From: ksun <kaiqinsun@gmail.com>
To: users@activemq.apache.org
Subject: How to configure DB datasource programmatically when using JDBC
 Master Slave?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: kaiqinsun@gmail.com
X-Virus-Checked: Checked by ClamAV on apache.org


Hi all,

I am trying to embed AMQ and also use shared JDBC Master Slave. The DB
setting is as below:

    <persistenceAdapter>
        <jdbcPersistenceAdapter dataDirectory="${activemq.base}/data"
dataSource="#mssql-ds"/>
    </persistenceAdapter>

    <bean id="mssql-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
       <property name="driverClassName"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
       <property name="url" 
  
value="jdbc:sqlserver://10.2.52.158:1433;databaseName=activemq;user=amqdba;password=amqdbtest"/>
   </bean>

As I know, if I use the above setup, it needs Spring Jars to resolve the
configuration. 

So could I configure these above DB info programmatically totally? Or there
is no way to do that, you only can do it in xml file?

Thanks in advance,

Kevin
-- 
View this message in context: http://old.nabble.com/How-to-configure-DB-datasource-programmatically-when-using-JDBC-Master-Slave--tp26683387p26683387.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.