It seems that no one gets the idea how to solve this problem. I guessed there should be certain problem in config xml file.
Here is part of my xml file. Is there any problem ? <persistenceAdapter> <journaledJDBC journalLogFiles="5" dataDirectory="../activemq-data" dataSource="#oracle-ds" useDatabaseLock="false"> <adapter><imageBasedJDBCAdaptor/></adapter> </journaledJDBC> </persistenceAdapter> <bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/> <property name="url" value="jdbc:oracle:thin:@localhost:1521:AMQDB"/> <property name="username" value="scott"/> <property name="password" value="tiger"/> <property name="poolPreparedStatements" value="true"/> </bean> JS75 wrote: > > 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-tp15476274s2354p15539347.html Sent from the ActiveMQ - User mailing list archive at Nabble.com.