hi all,
trying to use the jnetdirect JDBC libaries to persist the store.
However having grief when booting up. It complains about 'ACTIVEMQ_MSGS'. I
assume this is table it is creating.
It seems to have created the ACTIVEMQ_ACKS table.
I have read the jdbc support page but not much help. I have explicity using
the ImageBasedJDBCAdaptor. My active_mq config is below.
any help most appreciated.
------active mq.xml ----------------
<broker useJmx="false">
<persistenceAdapter
adapterClass="org.apache.activemq.store.jdbc.adapter.ImageBasedJDBCAdaptor"
>
<journaledJDBC journalLogFiles="5" dataDirectory="../data"
dataSource="#mssql-ds"/>
</persistenceAdapter>
<transportConnectors>
<transportConnector uri="tcp://localhost:61616"/>
<transportConnector uri="vm://localhost"/>
<!--transportConnector uri="stomp://localhost:61613"/-->
</transportConnectors>
<!-- MySql DataSource Sample Setup -->
</broker>
<bean id="mssql-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName"
value="com.jnetdirect.jsql.JSQLDriver"/>
<property name="url"
value="jdbc:JSQLConnect://172.31.100.117:1433/database=mig"/>
<property name="username" value="sa"/>
<property name="password" value="sa"/>
<property name="poolPreparedStatements" value="true"/>
</bean>
----------------------------------------------------------------------------------
####<Jun 1, 2006 4:55:41 PM EST> <Error> <HTTP> <coothaproto2> <myserver>
<Thread-8> <kernel identity> <> <101046>
<[ServletContext(id=2578640,name=web,context-path=/web)] Failed to create
broker: org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'org.apache.activemq.xbean.XBeanBrokerService'
defined in ServletContext resource [/WEB-INF/activemq.xml]: Initialization
of bean failed; nested exception is java.io.IOException: Failed to get last
broker message id: com.jnetdirect.jsql.x: Invalid object name
'ACTIVEMQ_MSGS'.>
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'org.apache.activemq.xbean.XBeanBrokerService' defined in
ServletContext resource [/WEB-INF/activemq.xml]: Initialization of bean
failed; nested exception is java.io.IOException: Failed to get last broker
message id: com.jnetdirect.jsql.x: Invalid object name 'ACTIVEMQ_MSGS'.
java.io.IOException: Failed to get last broker message id:
com.jnetdirect.jsql.x: Invalid object name 'ACTIVEMQ_MSGS'.
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.store.journal.JournalPersistenceAdapter.getLastMessageBrokerSequenceId(JournalPersistenceAdapter.java:177)
at
org.apache.activemq.broker.region.RegionBroker.<init>(RegionBroker.java:91)
--
View this message in context:
http://www.nabble.com/SQL-Server+problems+with+%27ACTIVEMQ_MSGS%27-t1715140.html#a4657514
Sent from the ActiveMQ - User forum at Nabble.com.
