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