You open the JDBC Connection Pool property sheet by selecting a JDBC connection pool node under the Registered JDBC Connection Pools node or under the Unregistered JDBC Connection Pools node in the Explorer's Runtime tab.
A JDBC connection pool has the following properties:
This property specifies if you want the connection to this connection pool validated before the connection is given to an application. If it is set to true, the connection pool will continue to work properly even if the database crashes.
This property specifies the classname for the datasource.
This property specifies if all the connections in the pool will be closed and re-established when any connection in the pool is found to be invalid.
This property specifies the maximum time in seconds that a connection can remain idle in the pool. After this time, the pool implementation can close this connection.
This property specifies if you want to ensure that the transactions, in which the connection pool participates, are isolated.
This property specify the maximum number of connections that can be created to satisfy client requests.
This property specifies the amount of time the caller will wait before getting a connection timeout.
This property specifies the JNDI name of the JDBC connection pool. The JNDI name is a string value, and must not contain spaces in between.
This property specifies the number of connections to be created if a request arrives when the pool does not contain any available connections. This value is subject to the maximum connections for the pool that you have specified.
This property specifies any property that the JDBC connection pool uses. To add the properties, click this field and its ellipsis (...) button and add the properties using the Add button.
For example, the PointBase Network Server requires the following properties:
Name | Value |
---|---|
DatabaseName |
database URL.
For example: jdbc:pointbase:server://localhost/sun-appserv-samples |
User |
login user name.
For example: jdbc |
Password |
password of the user.
For example: jdbc |
The Oracle Type 4 JDBC Driver requires the following properties:
Name | Value |
---|---|
URL |
database URL.
For example: jdbc:oracle:thin:@localhost:1521:orcl |
User | login user name. |
Password | password of the user. |
This property specifies the type of the connection pool.
This property specify the minimum number of connections that must be maintained in the pool.
This property specifies the table to query if you select the table option in the Validation Method property.
This property specifies the method by which the transactions that this connection will participate in will be isolated for monitoring.
This property specifies the method by which the connections will be validated if the Connection Valdation Required property is true. Connections can be validated through:
See also | |
JDBC Connection Pools |