You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by JS75 <je...@aboveE.com> on 2008/02/14 09:55:22 UTC
SQLException : table or view does not exist
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.
Re: SQLException : table or view does not exist
Posted by JS75 <je...@aboveE.com>.
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.