Chapter 91. XQuery
Camel supports XQuery to allow an Expression or Predicate to be used in the DSL.
For example, you could use XQuery to create a predicate in a Message Filter or as an expression for a Recipient List.
91.1. XQuery Language options
The XQuery language supports 4 options, which are listed below.
Name | Default | Java Type | Description |
---|---|---|---|
type |
| Sets the class name of the result type (type from output) The default result type is NodeSet. | |
headerName |
| Name of header to use as input, instead of the message body. | |
configurationRef |
| Reference to a saxon configuration instance in the registry to use for xquery (requires camel-saxon). This may be needed to add custom functions to a saxon configuration, so these custom functions can be used in xquery expressions. | |
trim |
| Whether to trim the value to remove leading and trailing whitespaces and line breaks. |
91.2. Variables
The message body will be set as the contextItem
. And the following variables are available as well:
Variable | Type | Description |
---|---|---|
exchange | Exchange | The current Exchange |
in.body | Object | The message body |
out.body | Object | deprecated The OUT message body (if any) |
in.headers.* | Object | You can access the value of exchange.in.headers with key foo by using the variable which name is in.headers.foo |
out.headers.* | Object | deprecated You can access the value of exchange.out.headers with key foo by using the variable which name is out.headers.foo variable |
key name | Object |
Any exchange.properties and exchange.in.headers and any additional parameters set using |
91.3. Example
from("queue:foo") .filter().xquery("//foo") .to("queue:bar")
You can also use functions inside your query, in which case you need an explicit type conversion, or you will get an org.w3c.dom.DOMException: HIERARCHY_REQUEST_ERR
). You need to pass in the expected output type of the function. For example the concat function returns a String
which is done as shown:
from("direct:start") .recipientList().xquery("concat('mock:foo.', /person/@city)", String.class);
And in XML DSL:
<route> <from uri="direct:start"/> <recipientList> <xquery type="java.lang.String">concat('mock:foo.', /person/@city</xquery> </recipientList> </route>
91.3.1. Using namespaces
If you have a standard set of namespaces you wish to work with and wish to share them across many XQuery expressions you can use the org.apache.camel.support.builder.Namespaces
when using Java DSL as shown:
Namespaces ns = new Namespaces("c", "http://acme.com/cheese"); from("direct:start") .filter().xquery("/c:person[@name='James']", ns) .to("mock:result");
Notice how the namespaces are provided to xquery
with the ns
variable that are passed in as the 2nd parameter.
Each namespace is a key=value pair, where the prefix is the key. In the XQuery expression then the namespace is used by its prefix, eg:
/c:person[@name='James']
The namespace builder supports adding multiple namespaces as shown:
Namespaces ns = new Namespaces("c", "http://acme.com/cheese") .add("w", "http://acme.com/wine") .add("b", "http://acme.com/beer");
When using namespaces in XML DSL then its different, as you setup the namespaces in the XML root tag (or one of the camelContext
, routes
, route
tags).
In the XML example below we use Spring XML where the namespace is declared in the root tag beans
, in the line with xmlns:foo="http://example.com/person"
:
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:foo="http://example.com/person" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://camel.apache.org/schema/spring http://camel.apache.org/schema/spring/camel-spring.xsd"> <camelContext id="camel" xmlns="http://activemq.apache.org/camel/schema/spring"> <route> <from uri="activemq:MyQueue"/> <filter> <xquery>/foo:person[@name='James']</xquery> <to uri="mqseries:SomeOtherQueue"/> </filter> </route> </camelContext> </beans>
This namespace uses foo
as prefix, so the <xquery>
expression uses /foo:
to use this namespace.
91.4. Using XQuery as transformation
We can do a message translation using transform or setBody in the route, as shown below:
from("direct:start"). transform().xquery("/people/person");
Notice that xquery will use DOMResult by default, so if we want to grab the value of the person node, using text()
we need to tell XQuery to use String as result type, as shown:
from("direct:start"). transform().xquery("/people/person/text()", String.class);
If you want to use Camel variables like headers, you have to explicitly declare them in the XQuery expression.
<transform> <xquery> declare variable $in.headers.foo external; element item {$in.headers.foo} </xquery> </transform>
91.5. Loading script from external resource
You can externalize the script and have Camel load it from a resource such as "classpath:"
, "file:"
, or "http:"
. This is done using the following syntax: "resource:scheme:location"
, e.g. to refer to a file on the classpath you can do:
.setHeader("myHeader").xquery("resource:classpath:myxquery.txt", String.class)
91.6. Learning XQuery
XQuery is a very powerful language for querying, searching, sorting and returning XML. For help learning XQuery try these tutorials
- Mike Kay’s XQuery Primer
- The W3Schools XQuery Tutorial
91.7. Dependencies
To use XQuery in your camel routes you need to add the a dependency on camel-saxon which implements the XQuery language.
If you use maven you could just add the following to your pom.xml, substituting the version number for the latest & greatest release (see the download page for the latest versions).
<dependency> <groupId>org.apache.camel</groupId> <artifactId>camel-saxon</artifactId> <version>{CamelSBVersion}</version> </dependency>
91.8. Spring Boot Auto-Configuration
When using xquery with Spring Boot make sure to use the following Maven dependency to have support for auto configuration:
<dependency> <groupId>org.apache.camel.springboot</groupId> <artifactId>camel-saxon-starter</artifactId> </dependency>
The component supports 11 options, which are listed below.
Name | Description | Default | Type |
---|---|---|---|
camel.component.xquery.autowired-enabled | Whether autowiring is enabled. This is used for automatic autowiring options (the option must be marked as autowired) by looking up in the registry to find if there is a single instance of matching type, which then gets configured on the component. This can be used for automatic configuring JDBC data sources, JMS connection factories, AWS Clients, etc. | true | Boolean |
camel.component.xquery.bridge-error-handler | Allows for bridging the consumer to the Camel routing Error Handler, which mean any exceptions occurred while the consumer is trying to pickup incoming messages, or the likes, will now be processed as a message and handled by the routing Error Handler. By default the consumer will use the org.apache.camel.spi.ExceptionHandler to deal with exceptions, that will be logged at WARN or ERROR level and ignored. | false | Boolean |
camel.component.xquery.configuration | To use a custom Saxon configuration. The option is a net.sf.saxon.Configuration type. | Configuration | |
camel.component.xquery.configuration-properties | To set custom Saxon configuration properties. | Map | |
camel.component.xquery.enabled | Whether to enable auto configuration of the xquery component. This is enabled by default. | Boolean | |
camel.component.xquery.lazy-start-producer | Whether the producer should be started lazy (on the first message). By starting lazy you can use this to allow CamelContext and routes to startup in situations where a producer may otherwise fail during starting and cause the route to fail being started. By deferring this startup to be lazy then the startup failure can be handled during routing messages via Camel’s routing error handlers. Beware that when the first message is processed then creating and starting the producer may take a little time and prolong the total processing time of the processing. | false | Boolean |
camel.component.xquery.module-u-r-i-resolver | To use the custom ModuleURIResolver. The option is a net.sf.saxon.lib.ModuleURIResolver type. | ModuleURIResolver | |
camel.language.xquery.configuration-ref | Reference to a saxon configuration instance in the registry to use for xquery (requires camel-saxon). This may be needed to add custom functions to a saxon configuration, so these custom functions can be used in xquery expressions. | String | |
camel.language.xquery.enabled | Whether to enable auto configuration of the xquery language. This is enabled by default. | Boolean | |
camel.language.xquery.trim | Whether to trim the value to remove leading and trailing whitespaces and line breaks. | true | Boolean |
camel.language.xquery.type | Sets the class name of the result type (type from output) The default result type is NodeSet. | String |