JDBC Resource Templates

A JDBC resource template can be used to establish a connection to a database and obtain table and column information to complete the SELECT statement. This resource template is only used during design. When the mediation flow is used in a composite and deployed, the resource template is ignored.

Resource templates are defined on the mediation flow and are used to specify a resource (such as a database connection) that can be used by one or more tasks in a mediation flow.

The property specified on the Properties tab of the mediation flow provides the database connection used for each Query Database task.

To connect to more than one database or use different user accounts, create one resource template for each database connection. Query Database tasks that use the same resource template will use the same database connection.

Note: Resource templates must be associated with JDBC resource templates at the component or composite level, and you can also override JDBC resources at deployment time in the ActiveMatrix Administrator interface. See Composite Development Guide for more information about resource templates and the Administrator interface.