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.XmlBeanDefinitionStoreException:
> 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.XmlBeanDefinitionStoreException:
> > > 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
> > >
> >
>
