I tried the solution mentioned in http://www.nabble.com/forum/ViewPost.jtp?post=6179899&framed=y
Here is the result: $ activemq ACTIVEMQ_HOME: /usr/local/activemq Loading message broker from: xbean:activemq.xml INFO BrokerService - ActiveMQ 4.0.1 JMS Message Broker (localhost) is starting INFO BrokerService - For help or more information please see: http://incubator.apache.org/activemq/ INFO JDBCPersistenceAdapter - Database driver recognized: [apache_derby_embedded_jdbc_driver] WARN DefaultJDBCAdapter - Could not create JDBC tables; they could already exist. Failure was: CREATE INDEX ACTIVEMQ_MSGS_CIDX ON ACTIVEMQ_MSGS (CONTAINER) Message: Exception during creation of file /usr/local/stuff/data/derbydb/seg0/c331.dat for container SQLState: XSDF1 Vendor code: 20000 WARN DefaultJDBCAdapter - Could not create JDBC tables; they could already exist. Failure was: CREATE INDEX ACTIVEMQ_MSGS_EIDX ON ACTIVEMQ_MSGS (EXPIRATION) Message: Exception during creation of file /usr/local/stuff/data/derbydb/seg0/c341.dat for container SQLState: XSDF1 Vendor code: 20000 WARN DefaultJDBCAdapter - Could not create JDBC tables; they could already exist. Failure was: CREATE TABLE ACTIVEMQ_ACKS(CONTAINER VARCHAR(250) NOT NULL, CLIENT_ID VARCHAR(250) NOT NULL, SUB_NAME VARCHAR(250) NOT NULL, SELECTOR VARCHAR(250), LAST_ACKED_ID INTEGER, PRIMARY KEY ( CONTAINER, CLIENT_ID, SUB_NAME)) Message: Exception during creation of file /usr/local/stuff/data/derbydb/seg0/c350.dat for container SQLState: XSDF1 Vendor code: 20000 WARN JDBCPersistenceAdapter - Old message cleanup failed due to: SQL Exception: Table 'ACTIVEMQ_ACKS' does not exist. ERROR BrokerService - Failed to start ActiveMQ JMS Message Broker. Reason: java.io.IOException: Failed to get last broker message id: SQL Exception: Table 'ACTIVEMQ_ACKS' does not exist. java.io.IOException: Failed to get last broker message id: SQL Exception: Table 'ACTIVEMQ_ACKS' does not exist. at org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:30) at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getLastMessageBrokerSequenceId(JDBCPersistenceAdapter.java:131) at org.apache.activemq.broker.region.RegionBroker.<init>(RegionBroker.java:91) at org.apache.activemq.broker.jmx.ManagedRegionBroker.<init>(ManagedRegionBroker.java:89) at org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:934) at org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:888) at org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:458) at org.apache.activemq.broker.BrokerService.start(BrokerService.java:361) at org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:43) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1059) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320) at org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:158) at org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:48) at org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:40) at org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:56) at org.apache.activemq.console.command.StartCommand.startBroker(StartCommand.java:81) at org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:46) at org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:49) at org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:81) at org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:49) at org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:45) 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:585) at org.apache.activemq.console.Main.runTaskClass(Main.java:135) at org.apache.activemq.console.Main.main(Main.java:67) Caused by: SQL Exception: Table 'ACTIVEMQ_ACKS' does not exist. at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doGetLastMessageBrokerSequenceId(DefaultJDBCAdapter.java:164) at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getLastMessageBrokerSequenceId(JDBCPersistenceAdapter.java:128) ... 29 more ERROR: java.lang.RuntimeException: Failed to execute start task. Reason: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.apache.activemq.xbean.XBeanBrokerService' defined in class path resource [activemq.xml]: Initialization of bean failed; nested exception is java.io.IOException: Failed to get last broker message id: SQL Exception: Table 'ACTIVEMQ_ACKS' does not exist. ERROR: java.lang.Exception: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.apache.activemq.xbean.XBeanBrokerService' defined in class path resource [activemq.xml]: Initialization of bean failed; nested exception is java.io.IOException: Failed to get last broker message id: SQL Exception: Table 'ACTIVEMQ_ACKS' does not exist. INFO BrokerService - ActiveMQ Message Broker (localhost, null) is shutting down INFO NetworkConnector - Network Connector default Stopped INFO TransportConnector - Connector default Stopped INFO TransportConnector - Connector stomp Stopped INFO VMTransportFactory - Shutting down VM connectors for broker: localhost INFO BrokerService - ActiveMQ JMS Message Broker (localhost, null) stopped -- View this message in context: http://www.nabble.com/Failed-to-create-database-%27derbydb%27-tf2234864.html#a6197764 Sent from the ActiveMQ - User forum at Nabble.com.
