<execute xmlns="http://petals.ow2.org/components/sql/version-1">
   <sql show-metadata="true">SELECT name, firstname FROM user WHERE id='123'</sql>

<executeResponse xmlns="http://petals.ow2.org/components/sql/version-1">
  <row index='1'>
    <column name='name' type='varchar'>Field</column>
    <column name='firstname' type='varchar'>Jean</column>
  </row>
  <row index='2'>
    <column name='name' type='varchar'>Foo</column>
    <column name='firstname' type='varchar'>John</column>
  </row>
</executeResponse>
{info}The ResultSet can be written in the OUT message by a thread while the reponse message is sent back by another thread (pipes strreaming mechanism), increasing performance. To enable this feature, set the {{org.ow2.petals.transport.streaming=true}} property on the JBI Exchange, or set the {{streamingMode}} parameter of the Service Unit (in this case, the streaming mode is active for all requests).{info}
{info}The execute operation is defined in the SQL component abstract WSDL. You can import this abstract WSDL and define a concret WSDL to reference in your SU.{info}

<jbi:jbi version="1.0"
 xmlns:interfaceNs="http://petals.ow2.org/components/sql/version-1"
 xmlns:jbi="http://java.sun.com/xml/ns/jbi"
 xmlns:petalsCDK="http://petals.ow2.org/components/extensions/version-5"
 xmlns:serviceNs="http://test"
 xmlns:sql="http://petals.ow2.org/components/sql/version-1"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <!-- Import a Service into PEtALS or Expose a PEtALS Service => use a BC. -->
 <jbi:services binding-component="true">
   <!-- Import a Service into PEtALS => provides a Service. -->
   <jbi:provides
    interface-name="interfaceNs:SQLInterface"
    service-name="serviceNs:MyDatabaseSQLService"
    endpoint-name="MyDatabaseSQLServiceEndpoint">
    <!-- CDK specific elements -->
    <petalsCDK:wsdl>SQLService.wsdl</petalsCDK:wsdl>
    <!-- Component specific elements -->
    <sql:url>jdbc:mysql://host_name:port/dbname</sql:url>
    <sql:user>test</sql:user>
    <sql:password>test</sql:password>
    <sql:maxActive>8</sql:maxActive>
    <sql:maxIdle>8</sql:maxIdle>
    <sql:minIdle>0</sql:minIdle>
    <sql:maxWait>-1</sql:maxWait>
    <sql:timeBetweenEvictionRunsMillis>-1</sql:timeBetweenEvictionRunsMillis>
    <sql:metadata>true</sql:metadata>
   </jbi:provides>
 </jbi:services>
</jbi:jbi>