XQuery Endpoint and Saxon problem

[Anonymous]

Hi,

Sorry if it's in the wrong location, I'm a beginner with Talend.

I tried to do the situation told in the following website https://help.talend.com/reader/UYgSnAddpoFjxiV3uo9geA/ou1jwKZ_rsIwLI8ZuLSkJg

The problem is, anytime I start the route, I have the following error :

[ERROR]: org.apache.camel.processor.DefaultErrorHandler - Failed delivery for (MessageId: ID-GFI520149-1561042532347-0-2 on ExchangeId: ID-GFI520149-1561042532347-0-1). Exhausted after delivery attempt: 1 caught: org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[ID-GFI520149-1561042532347-0-1]

Message History
---------------------------------------------------------------------------------------------------------------------------------------
RouteId              ProcessorId          Processor                                                                        Elapsed (ms)
[Utiliser_Endpoint_] [Utiliser_Endpoint_] [file://C:/Users/frus75498/Desktop/TOS_ESB-20181026_1147-V7.1.1/Studio/workspac] [       813]
[Utiliser_Endpoint_] [Utiliser_Endpoint_] [xquery:SampleXquery                                                           ] [       797]

Stacktrace
---------------------------------------------------------------------------------------------------------------------------------------
org.apache.camel.CamelExecutionException: Exception occurred during execution on the exchange: Exchange[ID-GFI520149-1561042532347-0-1]
	at org.apache.camel.util.ObjectHelper.wrapCamelExecutionException(ObjectHelper.java:1846)
	at org.apache.camel.impl.DefaultExchange.setException(DefaultExchange.java:385)
	at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:64)
	at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:148)
	at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110)
	at projet_pivot_talend_esb.utiliser_endpoint_xquery_0_1.Utiliser_Endpoint_XQuery$2$1$1.process(Utiliser_Endpoint_XQuery.java:203)
	at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:110)
	at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:548)
	at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201)
	at org.apache.camel.processor.Pipeline.process(Pipeline.java:138)
	at org.apache.camel.processor.Pipeline.process(Pipeline.java:101)
	at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:201)
	at org.apache.camel.component.file.GenericFileConsumer.processExchange(GenericFileConsumer.java:452)
	at org.apache.camel.component.file.GenericFileConsumer.processBatch(GenericFileConsumer.java:219)
	at org.apache.camel.component.file.GenericFileConsumer.poll(GenericFileConsumer.java:183)
	at org.apache.camel.impl.ScheduledPollConsumer.doRun(ScheduledPollConsumer.java:174)
	at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:101)
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NoSuchMethodError: net.sf.saxon.query.DynamicQueryContext.setParameter(Lnet/sf/saxon/om/StructuredQName;Lnet/sf/saxon/om/Sequence;)V
	at org.apache.camel.component.xquery.XQueryBuilder.addParameters(XQueryBuilder.java:660)
	at org.apache.camel.component.xquery.XQueryBuilder.addParameters(XQueryBuilder.java:652)
	at org.apache.camel.component.xquery.XQueryBuilder.configureQuery(XQueryBuilder.java:628)
	at org.apache.camel.component.xquery.XQueryBuilder.createDynamicContext(XQueryBuilder.java:552)
	at org.apache.camel.component.xquery.XQueryBuilder.evaluateAsDOM(XQueryBuilder.java:186)
	at org.apache.camel.component.xquery.XQueryBuilder.evaluate(XQueryBuilder.java:144)
	at org.apache.camel.component.xquery.XQueryBuilder.process(XQueryBuilder.java:111)
	at org.apache.camel.impl.ProcessorEndpoint.onExchange(ProcessorEndpoint.java:103)
	at org.apache.camel.impl.ProcessorEndpoint$1.process(ProcessorEndpoint.java:71)
	at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61)
	... 21 more

I really don't know what to do, I'm struggling with this since yesterday...

Also I'm an intern (no one in my team knows hos to use Talend, don't ask why please ^^') so please don't hesitate to explain a lot of things about the resolution of this !

Thanks a lot,

Mylnethys

[Anonymous]

Hello,

What does your XML file look like? Did you set the Camel Component Dependencies on the Advanced Setting tab to include saxon? It is camel-saxon jar per the dependencies for the component.

Does this issue repro on studio or runtime?

Best regards

Sabrina

[aitsakel]

Hello,

I think I find the cause of the bug.
When including the Saxon dependency via Advanced Tab, the dependency added to the pom is Saxon-HE-9.5.1-5.
But this Saxon version is incompatible with camel-saxon-2.21.2.
For this to work we must have at least the Saxon-HE-9.8.0-8 version.
I do not know if it is possible to adjust the configuration so that it takes the right version of the jar  

Thanks

[aitsakel]

I forgot to mention that I encountered this problem in version 7.1.1 of Talend ESB