Data Sources - User Guide

Data Sources

Use this configuration panel to configure data sources, and connection pools.

  1. In the navigator, under Manage, click Data Sources. The Data Sources page appears. Add New Data SourcesFigure 1. Add New Data Source
  2. Click AddDataSource. The New Data Source page appears.
  3. Add your data source configuration details. Depending on the selection of your data source repository (InMemory, JNDI ) different configuration parameters will be available.
  4. Click Add. Your data source will be added.

Data Source configuration panel InMemory

Figure 2. Adding Data Source with InMemory configuration

Data Source configuration panel JNDI

Figure 3. Data Source configuration with JNDI

Field Descriptions

The meanings of many field descriptions are similar to the DBCPconfiguration guide. Please refer that for more information. The following table only briefly summaries some of them.

New Data Source
Field Name Description
Name Name of the data source (This value should be unique.)
Data Source Name A name to identify the data source, if a value is not specified,
Driver The JDBC driver to be used.
URL The connection URL to be passed to the JDBC driver to establish a connection
User Name The connection user name to be passed to the JDBC driver to establish a connection
Password The connection password to be passed to the JDBC driver to establish a connection
Data Source Pool Implementation The type of the data source pool implementation
Pool type This can be either: BasicDataSource or PerUserPoolDataSource. BasicDataSource - This data source is an implementation of javax.sql.DataSource that is configured via Java Bean properties. PerUserPoolDataSource :- This data source uses individual pools per user. Some properties can be set specifically for a given user, if the deployment environment can support initialization of mapped properties. For example, a pool of admin or write-access Connections can be guaranteed a certain number of connections, separate from a maximum set for users with read-only connections
Repository type The type of the data source repository.
IC Factory Initial context factory of the JNDI
Provider Port If specified, it will be used to create a JNDI provider URL internally.
Provider URL The URL of the JNDI provider. It is assumed that this URL exists and is accessible.
Max Active The maximum number of active connections that can be allocated from this pool at the same time. If a negative value is specified, there wont be a limit to the number of connections. The default value is 8.
Max Idle The minimum number of connections that can remain idle in the pool, without extra ones being created.It can be zero, to create none. Thedefault value is 8.
Initial Size (int) The initial number of connections that are created when the pool is started.
Max Open Statements (int) The maximum number of active connections that can be allocated from this pool at the same time. If a negative value is specifed, there wont be a limit to the number of connections. The default value is 8.
Transaction Isolation For the isolation values, please refer to the javadoc.
Auto Commit The default auto-commit state of connections created by this pool.
Pool Statements Enables prepared statement pooling for this pool. The default value is False.
Test On Borrow Indicates whether objects will be validated before being borrowed from the pool. If the object fails to validate, it will be dropped from the pool, and we will attempt to borrow another. The default value is True. Note - For the value True to have any effect, the validationQuery parameter must be set to a non-null string
Test While Idle Indicates whether objects will be validated by the idle object evictor (if any). If an object fails to validate, it will be dropped from the pool. The default value is False. Note - For the value True to have any effect, the validationQuery parameter must be set to a non-null string.
Validation Query The SQL query that will be used to 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