Hi all,

This is strange. I have poked around Google and the mailing list, but
couldn't really find the exact solution to my problem. 

I am trying to enable jdbc persistence and I am getting the error below:

================================================================================
= Testing:  something (xatest.TestRunner)                                     
=
================================================================================
17:05:14.671 INFO  [org.mule.MuleManager:getInstance] Creating new
MuleManager instance
17:05:14.953 INFO 
[org.springframework.context.support.AbstractApplicationContext:prepareRefresh]
Refreshing [EMAIL PROTECTED]:
display name [EMAIL PROTECTED];
startup date [Fri Oct 05 17:05:14 SGT 2007]; root of context hierarchy
17:05:15.046 INFO 
[org.springframework.beans.factory.xml.XmlBeanDefinitionReader:loadBeanDefinitions]
Loading XML bean definitions from class path resource
[applicationContext.xml]
17:05:15.265 INFO 
[org.springframework.context.support.AbstractApplicationContext:obtainFreshBeanFactory]
Bean factory for application context
[EMAIL PROTECTED]:
[EMAIL PROTECTED]
17:05:16.312 WARN 
[org.apache.activemq.store.jdbc.JDBCPersistenceAdapter:cleanup] Old message
cleanup failed due to: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
Table 'activemq.activemq_acks' doesn't exist
17:05:16.359 ERROR [org.apache.activemq.broker.BrokerService:start] Failed
to start ActiveMQ JMS Message Broker. Reason: java.io.IOException: Failed to
get last broker message id:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'activemq.activemq_acks' doesn't exist
java.io.IOException: Failed to get last broker message id:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'activemq.activemq_acks' doesn't exist
        at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:31)
        at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getLastMessageBrokerSequenceId(JDBCPersistenceAdapter.java:145)
        at
org.apache.activemq.broker.region.DestinationFactoryImpl.getLastMessageBrokerSequenceId(DestinationFactoryImpl.java:148)
        at
org.apache.activemq.broker.region.RegionBroker.<init>(RegionBroker.java:104)
        at
org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:1270)
        at
org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:1209)
        at
org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:508)
        at 
org.apache.activemq.broker.BrokerService.start(BrokerService.java:394)
        at
org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:47)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)
        at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
        at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
        at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)
        at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
        at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:88)
        at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:76)
        at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:72)
        at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:68)
        at
org.apache.activemq.xbean.BrokerFactoryBean.afterPropertiesSet(BrokerFactoryBean.java:84)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)
        at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
        at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
        at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:284)
        at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
        at
org.mule.extras.spring.config.MuleApplicationContext.<init>(MuleApplicationContext.java:59)
        at
org.mule.extras.spring.config.MuleApplicationContext.<init>(MuleApplicationContext.java:50)
        at
org.mule.extras.spring.SpringContainerContext.initialise(SpringContainerContext.java:140)
        at org.mule.MuleManager.setContainerContext(MuleManager.java:1416)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216)
        at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:216)
        at org.apache.commons.digester.Rule.end(Rule.java:230)
        at org.apache.commons.digester.Digester.endElement(Digester.java:1130)
        at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown 
Source)
        at org.apache.xerces.impl.dtd.XMLDTDValidator.endNamespaceScope(Unknown
Source)
        at org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(Unknown
Source)
        at org.apache.xerces.impl.dtd.XMLDTDValidator.endElement(Unknown Source)
        at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown
Source)
        at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown
Source)
        at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
        at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
        at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown 
Source)
        at org.apache.commons.digester.Digester.parse(Digester.java:1685)
        at
org.mule.config.builders.AbstractDigesterConfiguration.process(AbstractDigesterConfiguration.java:101)
        at
org.mule.config.builders.MuleXmlConfigurationBuilder.configure(MuleXmlConfigurationBuilder.java:264)
        at
org.mule.config.builders.MuleXmlConfigurationBuilder.configure(MuleXmlConfigurationBuilder.java:218)
        at 
org.mule.tck.FunctionalTestCase.setupManager(FunctionalTestCase.java:55)
        at org.mule.tck.FunctionalTestCase.doSetUp(FunctionalTestCase.java:38)
        at 
org.mule.tck.AbstractMuleTestCase.setUp(AbstractMuleTestCase.java:231)
        at junit.framework.TestCase.runBare(TestCase.java:128)
        at 
org.mule.tck.AbstractMuleTestCase.runBare(AbstractMuleTestCase.java:179)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:120)
        at org.mule.tck.AbstractMuleTestCase.run(AbstractMuleTestCase.java:149)
        at junit.framework.TestSuite.runTest(TestSuite.java:230)
        at junit.framework.TestSuite.run(TestSuite.java:225)
        at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'activemq.activemq_acks' doesn't exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
        at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
        at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
        at
org.enhydra.jdbc.core.CorePreparedStatement.executeQuery(CorePreparedStatement.java:92)
        at
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doGetLastMessageBrokerSequenceId(DefaultJDBCAdapter.java:148)
        at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getLastMessageBrokerSequenceId(JDBCPersistenceAdapter.java:142)
        ... 76 more
17:05:16.375 ERROR [org.apache.commons.digester.Digester:endElement] End
event threw exception
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at
org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216)
        at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:216)
        at org.apache.commons.digester.Rule.end(Rule.java:230)
        at org.apache.commons.digester.Digester.endElement(Digester.java:1130)
        at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown 
Source)
        at org.apache.xerces.impl.dtd.XMLDTDValidator.endNamespaceScope(Unknown
Source)
        at org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(Unknown
Source)
        at org.apache.xerces.impl.dtd.XMLDTDValidator.endElement(Unknown Source)
        at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown
Source)
        at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown
Source)
        at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
        at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
        at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown 
Source)
        at org.apache.commons.digester.Digester.parse(Digester.java:1685)
        at
org.mule.config.builders.AbstractDigesterConfiguration.process(AbstractDigesterConfiguration.java:101)
        at
org.mule.config.builders.MuleXmlConfigurationBuilder.configure(MuleXmlConfigurationBuilder.java:264)
        at
org.mule.config.builders.MuleXmlConfigurationBuilder.configure(MuleXmlConfigurationBuilder.java:218)
        at 
org.mule.tck.FunctionalTestCase.setupManager(FunctionalTestCase.java:55)
        at org.mule.tck.FunctionalTestCase.doSetUp(FunctionalTestCase.java:38)
        at 
org.mule.tck.AbstractMuleTestCase.setUp(AbstractMuleTestCase.java:231)
        at junit.framework.TestCase.runBare(TestCase.java:128)
        at 
org.mule.tck.AbstractMuleTestCase.runBare(AbstractMuleTestCase.java:179)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:120)
        at org.mule.tck.AbstractMuleTestCase.run(AbstractMuleTestCase.java:149)
        at junit.framework.TestSuite.runTest(TestSuite.java:230)
        at junit.framework.TestSuite.run(TestSuite.java:225)
        at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'jmsBroker' defined in class path resource
[applicationContext.xml]: Invocation of init method failed; nested exception
is org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'org.apache.activemq.xbean.XBeanBrokerService' defined in
class path resource [activemq.xml]: Invocation of init method failed; nested
exception is java.io.IOException: Failed to get last broker message id:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'activemq.activemq_acks' doesn't exist
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1174)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)
        at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
        at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
        at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:284)
        at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
        at
org.mule.extras.spring.config.MuleApplicationContext.<init>(MuleApplicationContext.java:59)
        at
org.mule.extras.spring.config.MuleApplicationContext.<init>(MuleApplicationContext.java:50)
        at
org.mule.extras.spring.SpringContainerContext.initialise(SpringContainerContext.java:140)
        at org.mule.MuleManager.setContainerContext(MuleManager.java:1416)
        ... 42 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'org.apache.activemq.xbean.XBeanBrokerService'
defined in class path resource [activemq.xml]: Invocation of init method
failed; nested exception is java.io.IOException: Failed to get last broker
message id: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'activemq.activemq_acks' doesn't exist
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1174)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)
        at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
        at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
        at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)
        at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
        at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:88)
        at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:76)
        at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:72)
        at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:68)
        at
org.apache.activemq.xbean.BrokerFactoryBean.afterPropertiesSet(BrokerFactoryBean.java:84)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)
        ... 53 more
Caused by: java.io.IOException: Failed to get last broker message id:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'activemq.activemq_acks' doesn't exist
        at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:31)
        at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getLastMessageBrokerSequenceId(JDBCPersistenceAdapter.java:145)
        at
org.apache.activemq.broker.region.DestinationFactoryImpl.getLastMessageBrokerSequenceId(DestinationFactoryImpl.java:148)
        at
org.apache.activemq.broker.region.RegionBroker.<init>(RegionBroker.java:104)
        at
org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:1270)
        at
org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:1209)
        at
org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:508)
        at 
org.apache.activemq.broker.BrokerService.start(BrokerService.java:394)
        at
org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:47)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)
        ... 67 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table
'activemq.activemq_acks' doesn't exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
        at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
        at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
        at
org.enhydra.jdbc.core.CorePreparedStatement.executeQuery(CorePreparedStatement.java:92)
        at
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doGetLastMessageBrokerSequenceId(DefaultJDBCAdapter.java:148)
        at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getLastMessageBrokerSequenceId(JDBCPersistenceAdapter.java:142)
        ... 76 more
17:05:16.437 INFO  [org.mule.MuleManager:disposeAgents] disposing agents...
17:05:16.437 INFO  [org.mule.MuleManager:disposeAgents] Agents Successfully
Disposed

1. I have MySQL JDBC driver in my classpath,
mysql-connector-java-5.0.7-bin.jar
2. I have tried making things "clean" by removing my
${activemq.home}/activemq-data
3. I have tried uncommenting the mysql-ds in the default config as well as
using my own simple one:

<beans>
        <broker brokerName="BROKER1" useJmx="false" persistent="true"
                xmlns="http://activemq.org/config/1.0";>
                <persistenceAdapter>
                        <jdbcPersistenceAdapter useDatabaseLock="false"
                                dataSource="#jdbc4jms1" 
dataDirectory="target/activemq-data" />
                        <adapter>
                                <imageBasedJDBCAdaptor />
                        </adapter>
                </persistenceAdapter>
                <transportConnectors>
                        <transportConnector name="openwire"
                                uri="tcp://localhost:61616" />
                </transportConnectors>
        </broker>
        
        <bean id="jdbc4jms1"
                class="org.enhydra.jdbc.pool.StandardXAPoolDataSource"
                destroy-method="shutdown">
                <property name="dataSource">
                        <bean
                                
class="org.enhydra.jdbc.standard.StandardXADataSource">
                                <property name="driverName"
                                        value="com.mysql.jdbc.Driver" />
                                <property name="transactionManager">
                                        <ref local="jotm" />
                                </property>
                                <property name="url"
                                        
value="jdbc:mysql://localhost:3306/activemq" />
                        </bean>
                </property>
                <property name="user" value="root" />
                <property name="password" value="" />
        </bean> 
        
        <bean id="jdbc4jms2" class="org.apache.commons.dbcp.BasicDataSource"
                destroy-method="shutdown">
                <property name="driverClassName" value="com.mysql.jdbc.Driver" 
/>
                <property name="url"
                        
value="jdbc:mysql://localhost/activemq?relaxAutoCommit=true" />
                <property name="username" value="root" />
                <property name="password" value="" />
                <property name="poolPreparedStatements" value="true" />
        </bean>
</beans>

Any ideas? 

Cheers,
Yuen-Chi Lian
-- 
View this message in context: 
http://www.nabble.com/Couldn%27t-get-jdbcPersistenceAdapter-working-tf4574013s2354.html#a13056039
Sent from the ActiveMQ - User mailing list archive at Nabble.com.

Reply via email to