Database Query Action

Database Query Action
Prev	actions	Next

Name

action

Database Query Action — Action that executes a database query

<action class="xms.action.DBAction" … > child tags </action>

Table 1. Attributes for action tag (for xms.action.DBAction)

Name	Description	Type	Default Value	Required
dataSource	Data Source	Template Freemarker template string	none	yes
event	The event to fire this action on	String any character combination	none	yes
timeout	Timeout in ms for the database query	int any integer	none	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

Child Tags

SQL Element

<sql>value</sql>

Table 2. Attributes for sql tag (for xms.action.DBAction)

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

Param Element

<param>value</param>

Table 3. Attributes for param tag (for xms.action.DBAction)

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

Example 3. Example configuration for Database Query Action

Required attributes are marked with a bold typeface

<action class="xms.action.DBAction"
      dataSource="dataSource"
      event="event"
      timeout="timeout">
    <sql>
        value
    </sql>
    <param>
        value
    </param>
</action>