Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@camel.apache.org
Received-SPF: pass (athena.apache.org: domain of nzipsi@gmail.com designates
 209.85.216.54 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <08D25C4F714FDC4B95A4C4F6664F8695012586EF@ws-exmb02.completegenomics.com>
References: <1395354681753-5749161.post@n5.nabble.com>
	<CAGB5yN=GUpLu7ZjvhXb24LtVuwiA75kbK=izPk=Xje8-pSf3og@mail.gmail.com>
	<08D25C4F714FDC4B95A4C4F6664F8695012586EF@ws-exmb02.completegenomics.com>
Date: Tue, 25 Mar 2014 12:18:48 +1300
Message-ID: 
 <CAJUvgM7n436zmMkjUE_5p-QqvosG1LVFpKJJt9WE-TdQLDLH7Q@mail.gmail.com>
Subject: Re: sql component and delay
From: Andrew Thorburn <nzipsi@gmail.com>
To: users@camel.apache.org
Content-Type: multipart/alternative; boundary=001a11c14d7a37d41a04f5627523

--001a11c14d7a37d41a04f5627523
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

It should be "&amp;consumer.delay=3D5000". 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>wrot=
e:

> When I do that:
>                     <from
>
>  uri=3D"sql:{{sql.oracle.selectPull2}}?consumer.onConsume=3D{{sql.oracle.=
markProcessed}}&consumer.delay=3D5000"
> />
>
> 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.doLoadBeanD=
efinitions(XmlBeanDefinitionReader.java:396)
>                at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDef=
initions(XmlBeanDefinitionReader.java:334)
>                at
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDef=
initions(XmlBeanDefinitionReader.java:302)
>                at
> org.springframework.beans.factory.support.AbstractBeanDefinitionReader.lo=
adBeanDefinitions(AbstractBeanDefinitionReader.java:174)
>                at
> org.springframework.beans.factory.support.AbstractBeanDefinitionReader.lo=
adBeanDefinitions(AbstractBeanDefinitionReader.java:209)
>                at
> org.springframework.beans.factory.support.AbstractBeanDefinitionReader.lo=
adBeanDefinitions(AbstractBeanDefinitionReader.java:180)
>                at
> org.springframework.beans.factory.support.AbstractBeanDefinitionReader.lo=
adBeanDefinitions(AbstractBeanDefinitionReader.java:243)
>                at
> org.springframework.context.support.AbstractXmlApplicationContext.loadBea=
nDefinitions(AbstractXmlApplicationContext.java:127)
>                at
> org.springframework.context.support.AbstractXmlApplicationContext.loadBea=
nDefinitions(AbstractXmlApplicationContext.java:93)
>                at
> org.springframework.context.support.AbstractRefreshableApplicationContext=
.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131)
>                at
> org.springframework.context.support.AbstractApplicationContext.obtainFres=
hBeanFactory(AbstractApplicationContext.java:530)
>                at
> org.springframework.context.support.AbstractApplicationContext.refresh(Ab=
stractApplicationContext.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.createApplicationConte=
xt(TestHorizonIntegration.java:40)
>                at
> org.apache.camel.test.spring.CamelSpringTestSupport.doCreateApplicationCo=
ntext(CamelSpringTestSupport.java:89)
>                at
> org.apache.camel.test.spring.CamelSpringTestSupport.doPreSetup(CamelSprin=
gTestSupport.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(FrameworkMeth=
od.java:47)
>                at
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallabl=
e.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:2=
7)
>                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:2=
7)
>                at org.junit.runners.ParentRunner.run(ParentRunner.java:30=
9)
>                at
> org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4Test=
Reference.java:50)
>                at
> org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.jav=
a:38)
>                at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTes=
tRunner.java:467)
>                at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTes=
tRunner.java:683)
>                at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunn=
er.java:390)
>                at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRun=
ner.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.createSAXPars=
eException(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Un=
known
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unkn=
own
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unkn=
own
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(Unkno=
wn
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLScanner.scanAttributeValue(Unk=
nown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanAttr=
ibute(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStar=
tElement(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$Fr=
agmentContentDriver.next(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unkno=
wn
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unk=
nown
> Source)
>                at
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.sc=
anDocument(Unknown
> Source)
>                at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unkno=
wn
> Source)
>                at
> com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unkno=
wn
> 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.doLoadBeanD=
efinitions(XmlBeanDefinitionReader.java:388)
>                ... 44 more
>
>
>
> Same thing with :
>                     <from
>
>  uri=3D"sql:{{sql.oracle.selectPull2}}?consumer.onConsume=3D{{sql.oracle.=
markProcessed}}&consumer.delay=3D5000;"
> />
> 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=3D{{sql.oracle.markPart}}&consumer.delay=3D5000
>
>
> On Thu, Mar 20, 2014 at 11:31 PM, Lydie <[hidden
> email]</user/SendEmail.jtp?type=3Dnode&node=3D5749170&i=3D0>> 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=3D{{sql.oracle.markPart}} ?consumer.delay=3D5000
> >
> >
> > 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=3Dnode&node=3D5749170&i=3D=
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-tp5749161p57491=
70.html
> To unsubscribe from sql component and delay, click here<
> http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=3Dunsubs=
cribe_by_code&node=3D5749161&code=3DbHByZXZvc3RAY29tcGxldGVnZW5vbWljcy5jb21=
8NTc0OTE2MXwxNjI1NjE1Mjg2
> >.
> NAML<
> http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=3Dmacro_=
viewer&id=3Dinstant_html%21nabble%3Aemail.naml&base=3Dnabble.naml.namespace=
s.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.t=
emplate.NodeNamespace&breadcrumbs=3Dnotify_subscribers%21nabble%3Aemail.nam=
l-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 intend=
ed
> 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-tp5749161p57492=
97.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>

--001a11c14d7a37d41a04f5627523--