Try the configuration in the answer to this question:
https://stackoverflow.com/questions/8604229/setting-up-activemq-with-journaled-mysql-jdbc-persistence?rq=1
On Feb 16, 2018 6:58 AM, "Илья Шипицин" <chipits...@gmail.com> wrote:
> 2018-02-16 16:57:21,051 | INFO | Refreshing
> org.apache.activemq.xbean.XBeanBrokerFactory$1@6fd02e5: startup date [Fri
> Feb 16 16:57:21 MSK 2018]; root of context hierarc
> hy | org.apache.activemq.xbean.XBeanBrokerFactory$1 | main
> 2018-02-16 16:57:22,099 | WARN | Exception encountered during context
> initialization - cancelling refresh attempt:
> org.springframework.beans.factory.BeanCreationExcepti
> on: Error creating bean with name
> 'org.apache.activemq.xbean.XBeanBrokerService#0' defined in class path
> resource [activemq.xml]: Cannot create inner bean '(inner bean)#
> 156b88f5' of type [org.apache.activemq.store.jdbc.JDBCPersistenceAdapter]
> while setting bean property 'persistenceAdapter'; nested exception is
> org.springframework.beans
> .factory.BeanCreationException: Error creating bean with name '(inner
> bean)#156b88f5' defined in class path resource [activemq.xml]: Cannot
> resolve reference to bean 'ms
> sql-ds' while setting bean property 'dataSource'; nested exception is
> org.springframework.beans.factory.CannotLoadBeanClassException: Cannot
> find
> class [org.apache.commo
> ns.dbcp.BasicDataSource] for bean with name 'mssql-ds' defined in class
> path resource [activemq.xml]; nested exception is
> java.lang.ClassNotFoundException: org.apache.co
> mmons.dbcp.BasicDataSource | org.apache.activemq.xbean.
> XBeanBrokerFactory$1
> | main
> 2018-02-16 16:57:22,109 | ERROR | Failed to load: class path resource
> [activemq.xml], reason: Error creating bean with name
> 'org.apache.activemq.xbean.XBeanBrokerService
> #0' defined in class path resource [activemq.xml]: Cannot create inner bean
> '(inner bean)#156b88f5' of type
> [org.apache.activemq.store.jdbc.JDBCPersistenceAdapter] while
> setting bean property 'persistenceAdapter'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name '(inner bean)#156
> b88f5' defined in class path resource [activemq.xml]: Cannot resolve
> reference to bean 'mssql-ds' while setting bean property 'dataSource';
> nested exception is org.sprin
> gframework.beans.factory.CannotLoadBeanClassException: Cannot find class
> [org.apache.commons.dbcp.BasicDataSource] for bean with name 'mssql-ds'
> defined in class path re
> source [activemq.xml]; nested exception is
> java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSource
> |
> org.apache.activemq.xbean.XBeanBrokerFactory | mai
> n
>
>
> 2018-02-16 18:53 GMT+05:00 Thiago Veronezi <thi...@veronezi.org>:
>
> > Oh, I meant for you to test the config above, but replacing "postgres-ds"
> > with your "mssql-ds".
> > We will just test the connection without the journaling thing.
> >
> > []s,
> > Thiago.
> >
> >
> > On Fri, Feb 16, 2018 at 11:45 AM, Илья Шипицин <chipits...@gmail.com>
> > wrote:
> >
> > > sorry, I do not have postgresql here.
> > >
> > > I can set up a vm for you with ms sql if you wish
> > >
> > > 2018-02-16 18:44 GMT+05:00 Thiago Veronezi <thi...@veronezi.org>:
> > >
> > > > Hi,
> > > >
> > > > I don't have a mssql server handy for testing it. Can you try
> > something?
> > > >
> > > > I have postgres configured with this...
> > > >
> > > > <persistenceAdapter>
> > > > <jdbcPersistenceAdapter dataSource="#postgres-ds">
> > > > </jdbcPersistenceAdapter>
> > > > </persistenceAdapter>
> > > >
> > > >
> > > > Can you try the same?
> > > >
> > > > []s,
> > > > Thiago.
> > > >
> > > >
> > > >
> > > >
> > > > On Fri, Feb 16, 2018 at 11:28 AM, Илья Шипицин <chipits...@gmail.com
> >
> > > > wrote:
> > > >
> > > > > log:
> > > > >
> > > > > 2018-02-16 16:27:55,841 | INFO | Refreshing
> > > > > org.apache.activemq.xbean.XBeanBrokerFactory$1@6fd02e5: startup
> date
> > > > [Fri
> > > > > Feb 16 16:27:55 MSK 2018]; root of context hierarchy |
> > > > > org.apache.activemq.xbean.XBeanBrokerFactory$1 | main
> > > > > 2018-02-16 16:27:56,249 | ERROR | Failed to load: class path
> resource
> > > > > [activemq.xml], reason: Line 38 in XML document from class path
> > > resource
> > > > > [activemq.xml] is invalid; nested exception is
> > > > > org.xml.sax.SAXParseException; lineNumber: 3
> > > > > 8; columnNumber: 102; cvc-complex-type.2.4.a: Invalid content was
> > found
> > > > > starting with element 'journaledJDBC'. One of '{"
> > > > > http://activemq.apache.org/schema/core":jdbcPersistenceAdapter, "
> > > > > http://activemq.apache.org/schema/core":journalP
> > > > > ersistenceAdapter, "http://activemq.apache.org/schema/core
> ":kahaDB,
> > "
> > > > > http://activemq.apache.org/schema/core":levelDB, "
> > > > > http://activemq.apache.org/schema/core":mKahaDB, "
> > > > > http://activemq.apache.org/schema/core":memoryPersistenceAdapter,
> > > > > "http://activemq.apache.org/schema/core":replicatedLevelDB,
> > > > WC[##other:"
> > > > > http://activemq.apache.org/schema/core"]}' is expected. |
> > > > > org.apache.activemq.xbean.XBeanBrokerFactory | main
> > > > > org.springframework.beans.factory.xml.
> XmlBeanDefinitionStoreExceptio
> > n:
> > > > > Line
> > > > > 38 in XML document from class path resource [activemq.xml] is
> > invalid;
> > > > > nested exception is org.xml.sax.SAXParseException; lineNumber: 38;
> > > > > columnNumber: 102; c
> > > > > vc-complex-type.2.4.a: Invalid content was found starting with
> > element
> > > > > 'journaledJDBC'. One of
> > > > > '{"http://activemq.apache.org/schema/core":jdbcPersistenceAdapter,
> > > > > "http://activemq.apache.org/schema/core":
> journalPersistenceAdapter,
> > > "htt
> > > > > p://activemq.apache.org/schema/core":kahaDB, "
> > > > > http://activemq.apache.org/schema/core":levelDB, "
> > > > > http://activemq.apache.org/schema/core":mKahaDB, "
> > > > > http://activemq.apache.org/schema/core":memoryPersistenceAdapter,
> "
> > > > > http://activemq.apach
> > > > > e.org/schema/core":replicatedLevelDB, WC[##other:"
> > > > > http://activemq.apache.org/schema/core"]}' is expected.
> > > > > at
> > > > > org.springframework.beans.factory.xml.XmlBeanDefinitionReader.
> > > > > doLoadBeanDefinitions(XmlBeanDefinitionReader.java:
> > > > > 399)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> > > > > at
> > > > > org.springframework.beans.factory.xml.XmlBeanDefinitionReader.
> > > > > loadBeanDefinitions(XmlBeanDefinitionReader.java:
> > > > 336)[spring-beans-4.3.9.
> > > > > RELEASE.jar:4.3.9.RELEASE]
> > > > > at
> > > > > org.springframework.beans.factory.xml.XmlBeanDefinitionReader.
> > > > > loadBeanDefinitions(XmlBeanDefinitionReader.java:
> > > > 304)[spring-beans-4.3.9.
> > > > > RELEASE.jar:4.3.9.RELEASE]
> > > > > at
> > > > > org.apache.xbean.spring.context.ResourceXmlApplicationContext.
> > > > > loadBeanDefinitions(ResourceXmlApplicationContext.
> > > > > java:111)[xbean-spring-4.2.jar:4.2]
> > > > > at
> > > > > org.apache.xbean.spring.context.ResourceXmlApplicationContext.
> > > > > loadBeanDefinitions(ResourceXmlApplicationContext.
> > > > > java:104)[xbean-spring-4.2.jar:4.2]
> > > > >
> > > > >
> > > > > config:
> > > > >
> > > > > <beans
> > > > > xmlns="http://www.springframework.org/schema/beans";
> > > > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> > > > > xsi:schemaLocation="http://www.springframework.org/schema/beans
> > > > > http://www.springframework.org/schema/beans/spring-beans.xsd
> > > > > http://activemq.apache.org/schema/core
> > > > > http://activemq.apache.org/schema/core/activemq-core.xsd";>
> > > > >
> > > > > <bean
> > > > > class="org.springframework.beans.factory.config.
> > > > > PropertyPlaceholderConfigurer">
> > > > > <property name="locations">
> > > > > <value>file:${activemq.conf}/
> > > credentials.properties</value>
> > > > > </property>
> > > > > </bean>
> > > > >
> > > > > <bean id="logQuery" class="io.fabric8.insight.log.
> > > > log4j.Log4jLogQuery"
> > > > > lazy-init="false" scope="singleton"
> > > > > init-method="start" destroy-method="stop">
> > > > > </bean>
> > > > >
> > > > > <broker xmlns="http://activemq.apache.org/schema/core";
> > > > > brokerName="localhost" dataDirectory="${activemq.data}">
> > > > >
> > > > > <destinationPolicy>
> > > > > <policyMap>
> > > > > <policyEntries>
> > > > > <policyEntry topic=">" >
> > > > > <pendingMessageLimitStrategy>
> > > > > <constantPendingMessageLimitStrategy
> > > limit="1000"/>
> > > > > </pendingMessageLimitStrategy>
> > > > > </policyEntry>
> > > > > </policyEntries>
> > > > > </policyMap>
> > > > > </destinationPolicy>
> > > > >
> > > > >
> > > > > <managementContext>
> > > > > <managementContext createConnector="false"/>
> > > > > </managementContext>
> > > > >
> > > > > <persistenceAdapter>
> > > > > <journaledJDBC journalLogFiles="5"
> > > > > dataDirectory="../activemq-data" dataSource="#mssql-ds">
> > > > > <adapter><imageBasedJDBCAdaptor/></adapter>
> > > > > </journaledJDBC>
> > > > > </persistenceAdapter>
> > > > >
> > > > > <systemUsage>
> > > > > <systemUsage>
> > > > > <memoryUsage>
> > > > > <memoryUsage percentOfJvmHeap="70" />
> > > > > </memoryUsage>
> > > > > <storeUsage>
> > > > > <storeUsage limit="100 gb"/>
> > > > > </storeUsage>
> > > > > <tempUsage>
> > > > > <tempUsage limit="50 gb"/>
> > > > > </tempUsage>
> > > > > </systemUsage>
> > > > > </systemUsage>
> > > > >
> > > > > <transportConnectors>
> > > > > <!-- DOS protection, limit concurrent connections to
> 1000
> > > and
> > > > > frame size to 100MB -->
> > > > > <transportConnector name="openwire" uri="tcp://
> > > > > 0.0.0.0:61616?maximumConnections=1000&wireFormat.maxFrameSize=
> > > > > 104857600
> > > > > "/>
> > > > > <transportConnector name="amqp" uri="amqp://
> > > > > 0.0.0.0:5672?maximumConnections=1000&wireFormat.maxFrameSize=
> > > > 104857600
> > > > > "/>
> > > > > <transportConnector name="stomp" uri="stomp://
> > > > > 0.0.0.0:61613?maximumConnections=1000&wireFormat.maxFrameSize=
> > > > > 104857600
> > > > > "/>
> > > > > <transportConnector name="mqtt" uri="mqtt://
> > > > > 0.0.0.0:1883?maximumConnections=1000&wireFormat.maxFrameSize=
> > > > 104857600
> > > > > "/>
> > > > > <transportConnector name="ws" uri="ws://
> > > > > 0.0.0.0:61614?maximumConnections=1000&wireFormat.maxFrameSize=
> > > > > 104857600
> > > > > "/>
> > > > > </transportConnectors>
> > > > >
> > > > > <shutdownHooks>
> > > > > <bean xmlns="http://www.springframework.org/schema/
> beans
> > "
> > > > > class="org.apache.activemq.hooks.SpringContextHook" />
> > > > > </shutdownHooks>
> > > > >
> > > > > </broker>
> > > > >
> > > > > <bean id="mssql-ds" class="org.apache.commons.
> > > dbcp.BasicDataSource"
> > > > > destroy-method="close">
> > > > > <property name="driverClassName"
> > > > > value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
> > > > > <property name="url"
> > > > > value="jdbc:sqlserver://HOST:PORT;databaseName=DBNAME"/>
> > > > > <property name="username" value="USER"/>
> > > > > <property name="password" value="PASSWORD"/>
> > > > > </bean>
> > > > >
> > > > > <import resource="jetty.xml"/>
> > > > >
> > > > > </beans>
> > > > >
> > > > >
> > > > > 2018-02-16 17:53 GMT+05:00 Thiago Veronezi <thi...@veronezi.org>:
> > > > >
> > > > > > Can you share your configuration file?
> > > > > >
> > > > > > []s,
> > > > > > Thiago.
> > > > > >
> > > > > >
> > > > > > On Fri, Feb 16, 2018 at 8:44 AM, Илья Шипицин <
> > chipits...@gmail.com>
> > > > > > wrote:
> > > > > >
> > > > > > > hello,
> > > > > > >
> > > > > > > I'm trying to set up apache-activemq-5.15.3 + ms sql using the
> > > > > following
> > > > > > > guide:
> > > > > > >
> > > > > > > http://activemq.apache.org/sqlserver.html (2005 part)
> > > > > > >
> > > > > > >
> > > > > > > I downloaded jdbc driver + changed config as in example,
> however,
> > > I'm
> > > > > > > getting the following error:
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > 2018-02-16 12:39:45,340 | INFO | Refreshing
> > > > > > > org.apache.activemq.xbean.XBeanBrokerFactory$1@6fd02e5:
> startup
> > > date
> > > > > > [Fri
> > > > > > > Feb 16 12:39:45 MSK 2018]; root of context hierarc
> > > > > > > hy | org.apache.activemq.xbean.XBeanBrokerFactory$1 | main
> > > > > > > 2018-02-16 12:39:46,335 | ERROR | Failed to load: class path
> > > resource
> > > > > > > [activemq.xml], reason: Line 83 in XML document from class path
> > > > > resource
> > > > > > > [activemq.xml] is invalid;
> > > > > > > nested exception is org.xml.sax.SAXParseException; lineNumber:
> > 83;
> > > > > > > columnNumber: 94; cvc-complex-type.2.4.a: Invalid content was
> > found
> > > > > > > starting with element 'journaledJ
> > > > > > > DBC'. One of '{"http://activemq.apache.org/schema/core":
> > > > > > > jdbcPersistenceAdapter,
> > > > > > > "http://activemq.apache.org/schema/core":
> > > journalPersistenceAdapter,
> > > > "
> > > > > > > http://activemq.apac
> > > > > > > he.org/schema/core":kahaDB, "http://activemq.apache.org/
> > > schema/core
> > > > > > > ":levelDB,
> > > > > > > "http://activemq.apache.org/schema/core":mKahaDB, "
> > > > > > > http://activemq.apache.org/schema/core":
> > > > > > > memoryPersistenceAdapter,
> > > > > > > "http://activemq.apache.org/schema/core":replicatedLevelDB,
> > > > > > > WC[##other:"http://activemq.apache.org/schema/core"]}' is
> > > expected.
> > > > |
> > > > > > > org.apache.ac
> > > > > > > tivemq.xbean.XBeanBrokerFactory | main
> > > > > > > org.springframework.beans.factory.xml.
> > > XmlBeanDefinitionStoreExceptio
> > > > n:
> > > > > > > Line
> > > > > > > 83 in XML document from class path resource [activemq.xml] is
> > > > invalid;
> > > > > > > nested exception is or
> > > > > > > g.xml.sax.SAXParseException; lineNumber: 83; columnNumber: 94;
> > > > > > > cvc-complex-type.2.4.a: Invalid content was found starting with
> > > > element
> > > > > > > 'journaledJDBC'. One of '{"http://
> > > > > > > activemq.apache.org/schema/core":jdbcPersistenceAdapter, "
> > > > > > > http://activemq.apache.org/schema/core":
> > journalPersistenceAdapter,
> > > "
> > > > > > > http://activemq.apache.org/schema/core":kah
> > > > > > > aDB, "http://activemq.apache.org/schema/core":levelDB, "
> > > > > > > http://activemq.apache.org/schema/core":mKahaDB, "
> > > > > > > http://activemq.apache.org/schema/core":
> memoryPersistenceAdapte
> > > > > > > r, "http://activemq.apache.org/schema/core":replicatedLevelDB,
> > > > > > > WC[##other:"
> > > > > > > http://activemq.apache.org/schema/core"]}' is expected.
> > > > > > > at
> > > > > > > org.springframework.beans.factory.xml.XmlBeanDefinitionReader.
> > > > > > > doLoadBeanDefinitions(XmlBeanDefinitionReader.java:
> > > > > > > 399)[spring-beans-4.3.9.RELEASE.jar:4.3.9.REL
> > > > > > > EASE]
> > > > > > > at
> > > > > > > org.springframework.beans.factory.xml.XmlBeanDefinitionReader.
> > > > > > > loadBeanDefinitions(XmlBeanDefinitionReader.java:
> > > > > > 336)[spring-beans-4.3.9.
> > > > > > > RELEASE.jar:4.3.9.RELEA
> > > > > > > SE]
> > > > > > > at
> > > > > > > org.springframework.beans.factory.xml.XmlBeanDefinitionReader.
> > > > > > > loadBeanDefinitions(XmlBeanDefinitionReader.java:
> > > > > > 304)[spring-beans-4.3.9.
> > > > > > > RELEASE.jar:4.3.9.RELEA
> > > > > > > SE]
> > > > > > > at
> > > > > > > org.apache.xbean.spring.context.ResourceXmlApplicationContext.
> > > > > > > loadBeanDefinitions(ResourceXmlApplicationContext.
> > > > > > > java:111)[xbean-spring-4.2.jar:4.2]
> > > > > > > at
> > > > > > > org.apache.xbean.spring.context.ResourceXmlApplicationContext.
> > > > > > > loadBeanDefinitions(ResourceXmlApplicationContext.
> > > > > > > java:104)[xbean-spring-4.2.jar:4.2]
> > > > > > > at
> > > > > > > org.springframework.context.support.
> > AbstractRefreshableApplication
> > > > > > > Context.refreshBeanFactory(AbstractRefreshableApplication
> > > > > > > Context.java:129)[spring-context-4.
> > > > > > > 3.9.RELEASE.jar:4.3.9.RELEASE]
> > > > > > >
> > > > > > > any working example how to setup ms sql jdbc ?
> > > > > > >
> > > > > > > Cheers,
> > > > > > > Ilya Shipitsin
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
