3 Replies Latest reply on Dec 2, 2010 8:40 AM by Preben Asmussen

    Error creating tables on Oracle jdbc store

    Preben Asmussen Newbie

      Hi

       

      There seems to be an error when using Oracle 10.3. as jdbc store with fuse messagebroker version 5.4.1

       

      I have confirmed that it works with messagebroker version 5.3.1

       

      Stacktrace:

      2010-11-30 09:48:44,108 | WARN  | Old message cleanup failed due to: java.sql.SQLException: ORA-00904: "ACTIVEMQ_ACKS"."PRIORITY": invalid identifier

      | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main

      2010-11-30 09:48:44,108 | WARN  | Failure Details: ORA-00904: "ACTIVEMQ_ACKS"."PRIORITY": invalid identifier

      | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main

      java.sql.SQLException: ORA-00904: "ACTIVEMQ_ACKS"."PRIORITY": invalid identifier

       

           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

           at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)

           at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)

           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)

           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)

           at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)

           at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

           at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

           at org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doDeleteOldMessages(DefaultJDBCAdapter.java:757)

           at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.cleanup(JDBCPersistenceAdapter.java:338)

           at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.start(JDBCPersistenceAdapter.java:301)

           at org.apache.activemq.broker.BrokerService.start(BrokerService.java:485)

           at org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:60)

           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

           at java.lang.reflect.Method.invoke(Method.java:597)

           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1536)

           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)

           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)

           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)

           at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)

           at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)

           at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)

           at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)

           at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)

           at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:574)

           at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)

           at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)

           at org.apache.xbean.spring.context.ResourceXmlApplicationContext.(XBeanBrokerFactory.java:117)

           at org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext(XBeanBrokerFactory.java:115)

           at org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:71)

           at org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:71)

           at org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:54)

           at org.apache.activemq.console.command.StartCommand.startBroker(StartCommand.java:115)

           at org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:91)

           at org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:57)

           at org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:143)

           at org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:57)

           at org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:85)

           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

           at java.lang.reflect.Method.invoke(Method.java:597)

           at org.apache.activemq.console.Main.runTaskClass(Main.java:251)

           at org.apache.activemq.console.Main.main(Main.java:107)