Configure the following fields on this screen:
Name:
Enter a name for the database connection in the Name
field.
URL:
Enter the fully qualified URL of the location of the database.
User Name:
The username to use to access the database.
Password:
The password for the user specified in the User Name
field.
Initial pool size:
The initial size of the DBCP pool when it is first created.
Maximum number of active connections:
The maximum number of active connections that can be allocated
from the JDBC pool at the same time. The default maximum is
8 active connections.
Maximum number of idle connections:
The maximum number of active connections that can remain idle in the
pool without extra connections being released. The default maximum
is 8 connections.
Minimum number of idle connections:
The minimum number of active connections that can remain idle in the
pool without extra connections being created. The default minimum
is 8 connections.
Maximum wait time:
The maximum number of milliseconds that the pool waits (when
there are no available connections) for a connection to be
returned before throwing an exception, or -1 to wait indefinitely.
The default time is 10000ms, and a value of -1 indicates an indefinite
time to wait.
Time between eviction:
The number of milliseconds to sleep between runs of the thread that evicts
unused connections from the JDBC pool.
Number of tests:
The number of connection objects to examine from the pool during each
run of the evictor thread. The default number of objects is 3.
Minimum idle time:
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 any).
|