dbserver

1.0

Namespace	http://www.mulesoft.org/schema/mule/dbserver
Schema Location	http://www.mulesoft.org/schema/mule/dbserver/1.0/mule-dbserver.xsd
Version	1.0
Minimum Mule Version	3.2

Module Overview

Module to test database connections

Summary

Configuration
<dbserver:config> Configure an instance of this module

Message Processors
<dbserver:execute> Executes a SQL query
<dbserver:start-db-server> Start the server.
<dbserver:stop-db-server> Stops the server.

Configuration

To use the this module within a flow the namespace to the module must be included. The resulting flow will look similar to the following:

<mule xmlns="http://www.mulesoft.org/schema/mule/core"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:dbserver="http://www.mulesoft.org/schema/mule/dbserver"
      xsi:schemaLocation="
               http://www.mulesoft.org/schema/mule/core
               http://www.mulesoft.org/schema/mule/core/current/mule.xsd
               http://www.mulesoft.org/schema/mule/dbserver
               http://www.mulesoft.org/schema/mule/dbserver/1.0/mule-dbserver.xsd">

      <!-- here goes your flows and configuration elements -->

</mule>

This module is configured using the config element. This element must be placed outside of your flows and at the root of your Mule application. You can create as many configurations as you deem necesary as long as each carries its own name.

Each message processor, message source or transformer carries a config-ref attribute that allows the invoker to specify which configuration to use.

Attributes
Type	Name	Default Value	Description
xs:string	name		Optional. Give a name to this configuration so it can be later referenced.
xs:string	creationalScript		Optional. Script to create the database.
xs:string	jdbcUrl		JBDC url

Message Processors

<dbserver:execute>

Executes a SQL query

XML Sample

INCLUDE_ERROR

Attributes

Name	Default Value	Description
config-ref		Optional. Specify which configuration to use.
sql		Query to be executed

Child Elements

Return Payload

result of the SQL query.

<dbserver:start-db-server>

Start the server.

XML Sample

INCLUDE_ERROR

Attributes

Name	Default Value	Description
config-ref		Optional. Specify which configuration to use.

Child Elements

<dbserver:stop-db-server>

Stops the server.

XML Sample

INCLUDE_ERROR

Attributes

Name	Default Value	Description
config-ref		Optional. Specify which configuration to use.