Re: How to configure persistence in MySQL

[Javier Leyba]

On 3/16/06, James Strachan <[EMAIL PROTECTED]> wrote:
> This sounds a little odd - could you send the entire XML file you were using
> 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
>


Thanks for your reply.


This is my activemq.xml:

-------------
<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://activemq.org/config/1.0";>

    <broker brokerName="nova1" persistent="true" useJmx="true">
        <transportConnectors>
            <transportConnector uri="tcp://172.30.27.1:62003"/>
        </transportConnectors>

        <networkConnectors>
            <networkConnector
uri="static:(failover:tcp://172.30.27.1:62005,tcp://172.31.112.9:62001)"
/>
        </networkConnectors>

        <persistenceAdapter>

            <jdbcPersistenceAdapter dataSource="#mysql-ds"
cleanupPeriod="60000">
                <adapter><bytesJDBCAdapter/></adapter>
            </jdbcPersistenceAdapter>

        </persistenceAdapter>


    </broker>

    <bean id="mysql-ds"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
            <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
            <property name="url"
value="jdbc:mysql://172.31.112.16/activeMQ?relaxAutoCommit=true"/>
            <property name="username" value="activeMQ"/>
            <property name="password" value="activeMQ"/>
            <property name="poolPreparedStatements" value="true"/>
    </bean>
</beans>

-----------------



Thanks in advance

J