Dear All:
First, I try to start my embedded broker with config xml in MQ4.1.
It starts successfully, if I set db-source as SQL server 2005.
But I got exception below for oracle.
14-02-2008 16:48:58 ERROR [broker.BrokerService] - Failed to start ActiveMQ
JMS Message Broker. Reason: java.io.IOException: Failed to get last broker
message id: java.sql.SQLException: ORA-00942: table or view does not exist
java.io.IOException: Failed to get last broker message id:
java.sql.SQLException: ORA-00942: table or view does not 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.store.journal.JournalPersistenceAdapter.getLastMessageBrokerSequenceId(JournalPersistenceAdapter.java:185)
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)
I check out oracle db, and I only find one table ACTIVEMQ_ACK. (There should
be three tables?)
Does anyone get any idea why ?
Sincerely,
Jean
--
View this message in context:
http://www.nabble.com/SQLException-%3A-table-or-view-does-not-exist-tp15476274s2354p15476274.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
