Re: ms sql jdbc example

Илья Шипицин Fri, 16 Feb 2018 05:29:18 -0800

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&amp;wireFormat.maxFrameSize=104857600
"/>
            <transportConnector name="amqp" uri="amqp://
0.0.0.0:5672?maximumConnections=1000&amp;wireFormat.maxFrameSize=104857600
"/>
            <transportConnector name="stomp" uri="stomp://
0.0.0.0:61613?maximumConnections=1000&amp;wireFormat.maxFrameSize=104857600
"/>
            <transportConnector name="mqtt" uri="mqtt://
0.0.0.0:1883?maximumConnections=1000&amp;wireFormat.maxFrameSize=104857600
"/>
            <transportConnector name="ws" uri="ws://
0.0.0.0:61614?maximumConnections=1000&amp;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
> >
>

Re: ms sql jdbc example

Reply via email to