Re: [servicemix-user] XSQL Component

[J B]

Looking at the source, it does not appear to allow variable substitution.  Seems like it wouldn't be that hard to support.  But as for a working solution right now, you could have a component generate the XSQL document on the fly with parameters passed in to it, then forward that document to the XSQL component.  If you do not set the XSQL document in the configuration of the XSQL component, then it will attempt to create one out of the message passed to it.  A groovy component could easily use the xmlbuilder to generate the document

Hope that helps.

Birch

On 10/27/05, Angel Gomez <[EMAIL PROTECTED] > wrote:

    Hello.

    Is it possible to pass parameters in the call to a XSQL component
like in the Oracle documentation, with the xsql page specified in the
configuration file?

<?xml version="1.0 "?>
<xsql:query connection="demo" *bind-params="City"* xmlns:xsql="urn:oracle-xsql">

    SELECT Carrier, FlightNumber, Origin, TO_CHAR(ExpectedTime,'HH24:MI') Due
      FROM FlightSchedule
     WHERE TRUNC(ArrivalTime) = TRUNC(SYSDATE)
       AND Destination = *?*
  ORDER BY ExpectedTime

</xsql:query>

    Regards.