THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
This page seems to be no longer up to date. It needs a rework.
...
Note that XSQL is quite simple, but useful. If you want something more complex and powerful you might want to look at using a scripting language like Groovy.
Example XSQL document
Firstly here is an example XSQL document. As you can see its a piece of XML which allows embedded SQL statements inside it.
...
This example page could produce something like...
...
Then we can convert this into a JBI component and apply it in a pipeline as follows...
...
There are 2 main modes of operation for this component
- you explicitly specify the XSQL page to use inside the component when it is invoked. This is useful if you wish to requery a database at timed intervals for example and publish the XML content
- the inbound XML content is assumed to be an XSQL page which is then evaluated against its database. This allows you to send an XSQL page to this component to be evaluated.