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 > > > > > >