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

<result 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>
</result>

h2. Configuration

{center}{*}Configuration of a Service Unit to provide a service (JBI)*{center}

{table-plus:columnAttributes=,,style="text-align:center;",style="text-align:center;"}




|| {color:#333333}Parameter{color} || {color:#333333}Description{color}\\ || {color:#333333}Default{color}\\ || {color:#333333}Required{color}\\ ||
| provides | Describe the JBI service that will be exposed into the JBI bus. Interface (QName), Service (QName) and Endpoint (String) attributes are required. | \- | Yes |

\\
{center}{*}Configuration of a Service Unit to provide a service (CDK)*{center}
{table-plus:columnAttributes=,,style="text-align:center;",style="text-align:center;"}

{table-plus}

{table-plus}

{table-plus}

{table-plus}




|| {color:#333333}Parameter{color} || {color:#333333}Description{color}\\ || {color:#333333}Default{color}\\ || {color:#333333}Required{color}\\ ||
| timeout | Timeout in milliseconds of a synchronous send. This parameter is used by the method {{sendSync}} (Exchange exchange) proposes by the CDK {{Listeners}} classes. \\
Set it to 0 for an infinite timeout. | 0 | No |
| retrypolicy | This section defines a policy when attempting external transfer of message, before accepting the service as failed.
{note}Only for Binding Components.{note} | \- | No |
| retrypolicy - attempts | The number of transfer attempts. | \- | bound to {{retrypolicy}} |
| retrypolicy - delay | The delay in milliseconds between transfer attempts. | \- | bound to {{retrypolicy}} |
| exchange-properties | This sections defines the list of properties to set to the JBI exchange when processing a service. | \- | No |
| message-properties | This sections defines the list of properties to set to the JBI message when processing a service. | | No |
| validate-wsdl | Activate the validation of the WSDL when deploying a service unit. | true | No |
| WSDL | Path to the WSDL document describing services and operations exposed by the provided JBI endpoints defined in the SU. \\
The value of this parameter is : \\
* an URL
* a file relative to the root of the SU package \\
If not specified, a basic WSDL description is automaticaly provided by the CDK. | | No |
| forward-attachments \\ | Defines if attachment will be forwarded. \\ | false \\ | No \\ |
| forward-message-properties \\ | Defines if the message properties will be forwarded. | false \\ | No \\ |
| forward-security-subject \\ | Defines if the security subject will be forwarded. | false \\ | No \\ |
| exchange-property - org.ow2.petals.router.provider.noack | Check Petals documentation for further details. This property activates the bypass of acknowledgement messages destinated to this SU. Can be used for MEPs {{RobustInOnly}}, {{InOut}} and {{InOptionalOut}}. | \- | bound to {{retrypolicy}} |
| org.ow2.petals.transport.compress | {warning}To be used only in distributed setup of Petals ESB. Check Petals ESB documentation for further details.{warning} This property activates the compression of the message payload when set to {{true}}. | true | No |
{table-plus}


{petalslink}{include:0 CDK SU Provide Configuration}{petalslink}
\\
{center}{*}Configuration of a Service Unit to provide a service (SQL)*{center}
{table-plus:columnAttributes=,,style="text-align:center;",style="text-align:center;"}

{table-plus}

{table-plus}




|| Parameter \\ || Description || Default value || Required ||
| url \\ | The JDBC URL of the targeted database \\ | \- \\ | Yes \\ |
| driver | The JDBC Driver className. The JDBC library has to be loaded with a SharedLibrary. It is automatically resolved for: mysql,oracle,hsql,sqlserver,derby,postgresql,db2,sybase (according to the jdbc url). | \- \\ | No \\ |
| user \\ | The database user \\ | \- \\ | Yes \\ |
| password \\ | The database password. \\ | \- \\ | Yes \\ |
| maxActive \\ | The maximum number of active connections that can be allocated from this pool at the same time, or negative for no limit. | 8 \\ | No |
| maxIdle \\ | The maximum number of connections that can remain idle in the pool, without extra ones being released, or negative for no limit. | 8 \\ | No |
| minIdle \\ | The minimum number of connections that can remain idle in the pool, without extra ones being created, or zero to create none. | 0 \\ | No |
| maxWait \\ | The maximum amount of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception, \-1 to wait indefinitely. | \-1 \\ | No |
| timeBetweenEvictionRunsMillis \\ | The number of milliseconds to sleep between runs of the idle object evictor thread. When non-positive, no idle object evictor thread will be run. | \-1 \\ | No |
| metadata \\ | If true, When the 'select' operation is used, the response contains metadata on result elements(Row type,index...). | false \\ | No \\ |
{table-plus}





h3. Service Unit descriptor

The SQL component creates dataSource initialized with Service Unit parameters.
You have to deploy a Service Unit with a JBI descriptor containing a provides section and the following parameters.
Here is a sample of a SU JBI descriptor to configure a MyDataBaseSQL service.
{code:xml}
<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>