Figure 1. Add New Data Source
Use this configuration panel to configure data sources, and connection pools.
Figure 1. Add New Data Source
Figure 2. Adding Data Source with InMemory configuration
Figure 3. Data Source configuration with JNDI
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. The default 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 |