Return-Path: 
 <activemq-users-return-102-apmail-geronimo-activemq-users-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-activemq-users-archive@www.apache.org
Received: (qmail 54649 invoked from network); 16 Mar 2006 10:43:16 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 16 Mar 2006 10:43:16 -0000
Received: (qmail 70500 invoked by uid 500); 16 Mar 2006 10:43:15 -0000
Delivered-To: apmail-geronimo-activemq-users-archive@geronimo.apache.org
Received: (qmail 70434 invoked by uid 500); 16 Mar 2006 10:43:15 -0000
Mailing-List: contact activemq-users-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:activemq-users-help@geronimo.apache.org>
List-Unsubscribe: <mailto:activemq-users-unsubscribe@geronimo.apache.org>
List-Post: <mailto:activemq-users@geronimo.apache.org>
List-Id: <activemq-users.geronimo.apache.org>
Reply-To: activemq-users@geronimo.apache.org
Delivered-To: mailing list activemq-users@geronimo.apache.org
Received: (qmail 70272 invoked by uid 99); 16 Mar 2006 10:43:14 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Mar 2006 02:43:14 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of james.strachan@gmail.com
 designates 64.233.182.204 as permitted sender)
Received: from [64.233.182.204] (HELO nproxy.gmail.com) (64.233.182.204)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Mar 2006 02:43:13 -0800
Received: by nproxy.gmail.com with SMTP id l37so227118nfc
        for <activemq-users@geronimo.apache.org>;
 Thu, 16 Mar 2006 02:42:52 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=etGQECQW2dSe+UCMvi94gpo0WbXuzED4SBySGdTPuZvKLySXbBSsNDPheIvXq0bZvUHW5zm+5ruCY5XLhhquiSwkRUATe5PYkzcS2zNHt1BHccDpO/5CoPWP07iWEvPuur4WzAeTTM0z90oYuBO6jczzb2FWLMjv9HrmxsDScAg=
Received: by 10.48.239.5 with SMTP id m5mr759069nfh;
        Thu, 16 Mar 2006 02:42:51 -0800 (PST)
Received: by 10.48.209.20 with HTTP; Thu, 16 Mar 2006 02:42:51 -0800 (PST)
Message-ID: <ec6e67fd0603160242u2770c6f3wf180cfdc361d4@mail.gmail.com>
Date: Thu, 16 Mar 2006 10:42:51 +0000
From: "James Strachan" <james.strachan@gmail.com>
To: activemq-users@geronimo.apache.org
Subject: Re: How to configure persistence in MySQL
In-Reply-To: <933f2a180603160203g275f4110vdb1fd7b7a9f5aa78@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_3867_6170986.1142505771834"
References: <933f2a180603160203g275f4110vdb1fd7b7a9f5aa78@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_3867_6170986.1142505771834
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

This sounds a little odd - could you send the entire XML file you were usin=
g
please? Only there were some namespace changes from 3.x to 4.x and I just
want to check that it really is recognising the persistent configuration

James

On 3/16/06, Javier Leyba <xleyba@gmail.com> wrote:
>
> I'm a little bit confused. Let me tell you what I understood and
> please tell me what am I doing wrong.
>
> I want to have a journal persistence for faster performance but that
> could be automatically stored in a MySQL DB.
>
> Then I've defined:
>
> Code:
>
> <persistenceAdapter>
>                          <journaledJDBC journalLogFiles=3D"5"
> dataDirectory=3D"../activemq-data" dataSource=3D"#mysql-ds"
> useJournal=3D"true" useQuickJournal=3D"false">
>                                  <adapter><bytesJDBCAdapter/></adapter>
>                          </journaledJDBC>
>
>      </persistenceAdapter>
>    </broker>
>
>          <bean id=3D"mysql-ds"
> class=3D"org.apache.commons.dbcp.BasicDataSource"
> destroy-method=3D"close">
>              <property name=3D"driverClassName" value=3D"com.mysql.jdbc.D=
river
> "/>
>              <property name=3D"url"
> value=3D"jdbc:mysql://172.31.112.16/activeMQ?relaxAutoCommit=3Dtrue"/>
>              <property name=3D"username" value=3D"activeMQ"/>
>              <property name=3D"password" value=3D"activeMQ"/>
>              <property name=3D"poolPreparedStatements" value=3D"true"/>
>      </bean>
>
>
>
>
>
>
> After run some tests creating topics and messages and couldn't see
> tables created or data in my MySQL DB.
>
> Then I decided to test using just a jdbc persistence in my MySQL DB
> then I replaced above code with:
>
> Code:
>
>
> <persistenceAdapter>
>              <jdbcPersistenceAdapter dataSource=3D"#mysql-ds"
> cleanupPeriod=3D"60000">
>                  <adapter><bytesJDBCAdapter/></adapter>
>              </jdbcPersistenceAdapter>
>
>          </persistenceAdapter>
>      </broker>
>
>      <bean id=3D"mysql-ds"
> class=3D"org.apache.commons.dbcp.BasicDataSource"
> destroy-method=3D"close">
>              <property name=3D"driverClassName" value=3D"com.mysql.jdbc.D=
river
> "/>
>              <property name=3D"url"
> value=3D"jdbc:mysql://172.31.112.16/activeMQ?relaxAutoCommit=3Dtrue"/>
>              <property name=3D"username" value=3D"activeMQ"/>
>              <property name=3D"password" value=3D"activeMQ"/>
>              <property name=3D"poolPreparedStatements" value=3D"true"/>
>      </bean>
>
>
>
>
>
>
> But when I started broker I saw in console out:
>
>
> Code:
>
>
> INFO  DefaultListableBeanFactory     - Creating shared instance of
> singleton bean 'mysql-ds'
> INFO  BrokerService                  - ActiveMQ 4.0-M4 JMS Message
> Broker (nova1) is starting
> INFO  BrokerService                  - For help or more information
> please see: <a href=3D"http://www.logicblaze.com" target=3D"_blank"
> rel=3D"nofollow">http://www.logicblaze.com</a>
> INFO  JDBCPersistenceAdapter         - Database driver recognized:
> [apache_derby_embedded_jdbc_driver]
> INFO   - Journal Recovery Started from: Active Journal: using 2 x
> 20.0 Megs at: activemq-data/nova1/journal
> INFO  JournalPersistenceAdapter      - Journal Recovered: 0
> message(s) in transactions recovered.
>
>
>
>
>
>
> it's using a JournalPersistenceAdapter !!! ???
>
> I've checked activemq start script and commented the line:
>
> Code:
>
>
> if [ -z "$ACTIVEMQ_OPTS" ] ; then
>    #### ACTIVEMQ_OPTS=3D"-Xmx512M -Dderby.system.home=3D../data
> -Dderby.storage.fileSyncTransactionLog=3Dtrue"
>      ACTIVEMQ_OPTS=3D""
> fi
>
>
>
>
>
>
> Then I started broker againg and saw the same message !!!
>
> Why my broker is using allways JournalPersistenceAdapter and how could
> I get a persistence where data were saved in Journal and MySQL DB ?
>
>
> Thanks in advance
>
> J
>



--

James
-------
http://radio.weblogs.com/0112098/

------=_Part_3867_6170986.1142505771834--