Monitor

Back Next

Datasource Service

You only see this service if you have selected a Secure Agent.

Many processes interact with relational databases. The Datasource Service lets you create a "pool" of open connections between all of the application's current users. The number of users actually performing a request at any given time is usually a very small percentage of the total number of active users. Also, only when the request is being processed is there a need for a database connection. Here, you create a service that logs into the DBMS, and handles user account issues.

The Datasource service is based upon the Apache Commons DBCP. See http://commons.apache.org/proper/commons-dbcp/index.html for more information.

To add a new datasource service, click

New

Enter the following properties to configure a datasource service:

The Datasource Service window with a list of properties to configure.

After you make changes, you click Test Connection
to make sure that the connection is defined and configured correctly.

Standard Properties

The standard properties are:

Name: The name of the service you are defining or editing
Driver Class: The fully qualified Java class name of the JDBC driver to be used.
JNDI Path: The JNDI name to where this Datasource is bound.
Password: The connection password passed to the JDBC driver when establishing a connection.
URL: The connection URL passed to the JDBC driver when establishing a connection.
Username: The connection username passed to the JDBC driver when establishing a connection.

Advanced Properties

The advanced properties are:

Default Transaction Isolation: The default state of connections created by this pool, which is one of the following:
NONE
READ_COMMITTED
READ_UNCOMMITTED
REPEATABLE_READ
SERIALIZABLE
Initial Size: The initial number of connections that are created when the pool is started.
Max Active: The maximum number of active connections that can be allocated from this pool at the same time. If this value is negative, there is no limit.
Max Idle: The maximum number of connections that can remain idle in the pool without extra ones being released,. If this value is negative, there is no limit
Max Wait (ms): The maximum number of milliseconds that the pool waits for a connection if there are none available. A value of -1 means to wait indefinitely.
Min Evictable idle Time (ms): The minimum amount of time an object may sit idle in the pool before it is eligible for eviction by the idle object evictor (if an evictor exists.
Min Idle: The minimum number of connections that can remain idle in the pool without extra ones being created. A value of zero means that none will be created.
Number Tests per Eviction Run: The number of objects to examine during each run of the idle object evictor thread (if it exists).
Pooling Statements: Enable prepared statement pooling for this pool
Test on Borrow: When checked, objects are validated before being borrowed from the pool. If the object cannot be validated, it is dropped from the pool, and an attempt is made to borrow another.
Test on Return: When checked, objects are validated before being returned to the pool.
Test While Idle: When checked, objects are validated by the idle object evictor (if one exists). If the object cannot be validated, it is dropped from the pool.
Time Between Eviction Runs (ms): The number of milliseconds to sleep between runs of the idle object evictor thread. If this value is not positive, no idle object evictor thread runs.
Validation Query: The SQL query that will validate connections from this pool before returning them to the caller. If specified, this query must be an SQL SELECT statement that returns at least one row.

Custom Connection Properties

Use this section to add other properties that connection requires. This information is sent to the JDBC driver when the service is creating a connections. Click the Add
button to add a row into which you enter the property's name and value

System Services

Download Guide

Watch

Comments

Cloud Application Integration Homepage