Finding the Compromise – the Adapter Framework - Applied SOA Patterns on the Oracle Platform - page 422

Assigning a SQL query from message payload
9. The SQL execution part is quite similar to the flow we implemented for a simple
EJB in the previous exercise, except that we have two more things. First, we have
to implement IF branching, routing the simple queries to the XQuery function ex-
ecution (step 1) and all others to the EJB Service Callout. The condition is as
presented on the following screenshot, (1) (it should be only one statement and
only SELECT ). Secondly, for the complex queries, we have to prepare a
SQLStatements List and datasource parameters for the Java invocation. See the
following script:
<urn:executeSQL
xmlns:urn="urn:com:telco:ctu:la:adapter:dbadapter:v01"
xmlns:java="java:ctu.fusion.adapter">
<urn:SQLStatements>
{