Table of Contents

Search

  1. Preface
  2. The Application Integration Console
  3. Process Server Configuration
  4. Deployed Assets
  5. Process Schedules
  6. Processes
  7. Process Server Health
  8. Process Metrics
  9. Connections
  10. Guides
  11. Logs

Monitor

Monitor

Datasource Service

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
.