activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JS75 <jean...@aboveE.com>
Subject Re: SQLException : table or view does not exist
Date Mon, 18 Feb 2008 05:54:17 GMT

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.


Mime
View raw message