activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sL07 <lu...@asteriski.com>
Subject SQL-Server problems with 'ACTIVEMQ_MSGS'
Date Thu, 01 Jun 2006 07:09:39 GMT

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.


Mime
View raw message