camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Thorburn <nzi...@gmail.com>
Subject Re: sql component and delay
Date Mon, 24 Mar 2014 23:18:48 GMT
It should be "&amp;consumer.delay=5000". Since you're using XML, you'll
need to escape the & character.

- Andrew


On Tue, Mar 25, 2014 at 12:08 PM, Lydie <lprevost@completegenomics.com>wrote:

> When I do that:
>                     <from
>
>  uri="sql:{{sql.oracle.selectPull2}}?consumer.onConsume={{sql.oracle.markProcessed}}&consumer.delay=5000"
> />
>
> I get the following error:
>
> org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException:
> Line 78 in XML document from class path resource
> [META-INF/spring/camel-context.xml] is invalid; nested exception is
> org.xml.sax.SAXParseException; lineNumber: 78; columnNumber: 103; The
> reference to entity "consumer.delay" must end with the ';' delimiter.
>                at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:396)
>                at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:334)
>                at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302)
>                at
> org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174)
>                at
> org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209)
>                at
> org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180)
>                at
> org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:243)
>                at
> org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:127)
>                at
> org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:93)
>                at
> org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131)
>                at
> org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:530)
>                at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:444)
>                at
> org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
>                at
> org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
>                at
> com.cgi.horizon.integration.TestHorizonIntegration.createApplicationContext(TestHorizonIntegration.java:40)
>                at
> org.apache.camel.test.spring.CamelSpringTestSupport.doCreateApplicationContext(CamelSpringTestSupport.java:89)
>                at
> org.apache.camel.test.spring.CamelSpringTestSupport.doPreSetup(CamelSpringTestSupport.java:79)
>                at
> org.apache.camel.test.junit4.CamelTestSupport.setUp(CamelTestSupport.java:216)
>                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
>                at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
> Source)
>                at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
>                at java.lang.reflect.Method.invoke(Unknown Source)
>                at
> org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
>                at
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
>                at
> org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
>                at
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
>                at
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
>                at
> org.junit.rules.TestWatcher$1.evaluate(TestWatcher.java:55)
>                at org.junit.rules.RunRules.evaluate(RunRules.java:20)
>                at
> org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
>                at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
>                at
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
>                at
> org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
>                at
> org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
>                at
> org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
>                at
> org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
>                at
> org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
>                at
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
>                at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
>                at
> org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
>                at
> org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
>                at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
>                at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
>                at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
>                at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
> Caused by: org.xml.sax.SAXParseException; lineNumber: 78; columnNumber:
> 103; The reference to entity "consumer.delay" must end with the ';'
> delimiter.
>                at
> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLScanner.scanAttributeValue(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanAttribute(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
>                at
> com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
>                at
> com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown
> Source)
>                at
> org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:75)
>                at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:388)
>                ... 44 more
>
>
>
> Same thing with :
>                     <from
>
>  uri="sql:{{sql.oracle.selectPull2}}?consumer.onConsume={{sql.oracle.markProcessed}}&consumer.delay=5000;"
> />
> Any idea?
>
>
> Lydie
>
>
>
>
>
> From: Claus Ibsen-2 [via Camel] [mailto:
> ml-node+s465427n5749170h21@n5.nabble.com]
> Sent: Friday, March 21, 2014 12:10 AM
> To: Lydie Prevost
> Subject: Re: sql component and delay
>
> Hi
>
> If you want to use 2 or more options, then use & to separate them,
> just as uri parameters you see in the web browser address bar etc.
>
> See more details at
> http://camel.apache.org/how-do-i-configure-endpoints.html
>
> So it should be
>
> ?consumer.onConsume={{sql.oracle.markPart}}&consumer.delay=5000
>
>
> On Thu, Mar 20, 2014 at 11:31 PM, Lydie <[hidden
> email]</user/SendEmail.jtp?type=node&node=5749170&i=0>> wrote:
>
> > Hello,
> >
> > I am trying to pull data from  a database and mark rows as processed :
> >
> >
> > This is working
> > I am trying to use a specific delay in between each poll:
> >
> > ?consumer.onConsume={{sql.oracle.markPart}} ?consumer.delay=5000
> >
> >
> > How can I do both?
> > I tried:
> >
> >
> >
> > It does not work.
> > I also try to use direct: but then I have an empty body when for my
> choice.
> >
> >
> > Any idea?
> >
> >
> > Thank you,
> >
> >
> > Lydie
> >
> > I
> >
> >
> >
> > --
> > View this message in context:
> http://camel.465427.n5.nabble.com/sql-component-and-delay-tp5749161.html
> > Sent from the Camel - Users mailing list archive at Nabble.com.
>
>
>
> --
> Claus Ibsen
> -----------------
> Red Hat, Inc.
> Email: [hidden email]</user/SendEmail.jtp?type=node&node=5749170&i=1>
> Twitter: davsclaus
> Blog: http://davsclaus.com
> Author of Camel in Action: http://www.manning.com/ibsen
> Make your Camel applications look hawt, try: http://hawt.io
>
> ________________________________
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://camel.465427.n5.nabble.com/sql-component-and-delay-tp5749161p5749170.html
> To unsubscribe from sql component and delay, click here<
> http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5749161&code=bHByZXZvc3RAY29tcGxldGVnZW5vbWljcy5jb218NTc0OTE2MXwxNjI1NjE1Mjg2
> >.
> NAML<
> http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
> >
>
> ________________________________
>
> The contents of this e-mail and any attachments are confidential and only
> for use by the intended recipient. Any unauthorized use, distribution or
> copying of this message is strictly prohibited. If you are not the intended
> recipient please inform the sender immediately by reply e-mail and delete
> this message from your system. Thank you for your co-operation.
>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/sql-component-and-delay-tp5749161p5749297.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message