SQL Delivery Service

SQL Delivery Service
Prev	services	Next

Name

service

SQL Delivery Service — Message transport that delivers to an SQL database.

<service class="xms.transport.sql.SQLDeliveryService" name="name" … > child tags </service>

Table 75. Attributes for service tag (for xms.transport.sql.SQLDeliveryService)

Name	Description	Type	Default Value	Required
dataSource	The datasource to store messages in	Template Freemarker template string	none	yes
maxBodySize	The maximum size in bytes of the message body	int any integer	1000000	no
maxHandlers	The number of simultaneous connections permitted	int any integer	5	no

Service Dependencies

This tag depends on the following services (or a service that extends or implements these classes)

xms.dataservices.DataSourceService
- XMS Data Source Service
xms.thread.ThreadPoolService
- XMS Thread Pool Service

Child Tags

DeliveryPolicy

<policy class="class" … />

Classes Implementing xms.policy.DeliveryPolicy

The following classes can be used in the class attribute for this tag:

xms.policy.DefaultDeliveryPolicy — Default Delivery Policy

SQL Element

<sql>value</sql>

Table 76. Attributes for sql tag (for xms.transport.sql.SQLDeliveryService)

Name	Description	Type	Default Value	Required
value	The SQL query to execute	Template Freemarker template string	none	yes

Param Element

<param>value</param>

Table 77. Attributes for param tag (for xms.transport.sql.SQLDeliveryService)

Name	Description	Type	Default Value	Required
value	An SQL query parameter	Template Freemarker template string	none	yes

Example 72. Example configuration for SQL Delivery Service

Required attributes are marked with a bold typeface

<service class="xms.transport.sql.SQLDeliveryService" name="name"
      dataSource="dataSource"
      maxBodySize="maxBodySize"
      maxHandlers="maxHandlers">
    <policy class="class" name="name" … />
    <sql>
        value
    </sql>
    <param>
        value
    </param>
</service>

Prev	Up	Next
SMTP Service	Home	XMS Authentication Service