activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JS75 <jean...@aboveE.com>
Subject SQLException : table or view does not exist
Date Thu, 14 Feb 2008 08:55:22 GMT

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.


Mime
View raw message