JDBC Connection Pool
Create a JDBC Connection Pool
- Click to expand the JDBC node.
- Click the Connection Pools node. The Connection Pool table displays in the right
pane showing all the connection pools defined in your domain.
- Click the Create a New JDBC Connection Pool text link. A dialog displays in the
right pane showing the tabs associated with configuring a new connection pool.
- Enter values in the Name, URL, Driver Classname, and Properties attribute
fields.
- Click Create to create a connection pool instance with the name you specified in
the Name field. The new instance is added under the Connection Pools node in
the left pane.
- Click the Connections and Testing tabs and change the attribute fields or accept
the default values as assigned.
- Click Apply to save any changes you made.
Clone a JDBC Connection Pool
- Click to expand the JDBC node.
- Click the Connection Pools node. The Connection Pool table displays in the right
pane showing all the connection pools defined in your domain.
- Click the Clone icon in the row of the connection pool you want to clone. A
dialog displays in the right pane showing the tabs associated with cloning a
connection pool.
- Enter values in the Name, URL, Driver Classname, and Properties attribute
fields.
- Click Create to create a connection pool instance with the name you specified in
the Name field. The new instance is added under the Connection Pools node in
the left pane.
- Click the Connections and Testing tabs and change the attribute fields or accept
the default values as assigned.
- Click Apply to save any changes you made.
Delete a JDBC Connection Pool
- Click to expand the JDBC node.
- Click the Connection Pools node. The Connection Pool table displays in the right
pane showing all the connection pools defined in your domain.
- Click the Delete icon in the row of the connection pool you want to delete. A
dialog displays in the right pane asking you to confirm your deletion request.
- Click Yes to delete the connection pool. The connection pool icon under the
Connection Pools node is deleted.
Assign a JDBC Connection Pool
- Click the instance node in the left pane under Connection Pools for the pool you
want to assign. A dialog displays in the right pane showing the tabs associated with
this instance.
- Click the Targets tab.
- Complete the following steps for the Servers, Groups, and Clusters tabs:
- Select one or more targets in the Available column that you want to assign to
the connection pool.
- Click the mover control to move the targets you selected to the Chosen column.
- Click Apply to save your assignments.
Configuration
General
|
Attribute
|
Description
|
Range of Values
|
Default Value
|
|
Name
|
This attribute returns the name of the connection pool.
|
The name can be up to 256 alphanumeric characters, but may not contain commas or spaces.
|
Null
|
|
URL
|
The URL for the database, as specified in the JDBC driver documentation.
|
|
|
|
Driver Class Name
|
The string containing the name of the JDBC driver class.
|
|
|
|
Properties
|
The list of the properties passed to this JDBC driver.
|
|
|
Connections
|
Attribute
|
Description
|
Range of Values
|
Default Value
|
|
LoginDelaySeconds
|
The number of seconds to delay between logins when creating the pool.
|
Integer
|
0
|
|
InitialCapacity
|
The initial number of connections.
|
Integer
|
0
|
|
Maximum Capacity
|
This attribute sets the maximum pool capacity for this connection pool.
|
Integer
|
1
|
|
CapacityIncrement
|
The increment by which the pool capacity is expanded.
|
Integer
|
0
|
|
Allow Shrinking
|
Set to true to enable pool shrinking.
|
Boolean
Selected = true
Not Selected = false
|
True
|
|
Shrink Period
|
This attribute sets the shrink period for this connection pool.
|
Integer
|
15
|
|
Refresh Period
|
This attribute sets the amount of time to wait before refreshing this connection pool.
|
Integer
|
0
|
Testing
|
Attribute
|
Description
|
Range of Values
|
Default Value
|
|
TestTableName
|
This attribute is the name of the test table.
|
String
|
null
|
|
TestConnectionsOnReserve
|
This is attribute is used to determine if the connections on reserve will be tested.
|
Boolean
Selected = true
Not Selected = false
|
Not Selected
|
|
TestConnectionsOnRelease
|
This attribute is used to determine if connections that are being released are tested.
|
Boolean
Selected = true
Not Selected = false
|
Not Selected
|
Targets
Servers
|
Attribute
|
Description
|
Range of Values
|
Default Value
|
|
Targets
|
This attribute sets the target servers for this deployment
|
String
|
The default is [Lweblogic.management.configuration.TargetMBean;@2c84d9
|
Clusters
|
Attribute
|
Description
|
Range of Values
|
Default Value
|
|
Targets
|
This attribute sets the target clusters for this deployment
|
String
|
The default is [Lweblogic.management.configuration.TargetMBean;@2c84d9
|
Monitoring
|
Attribute
|
Description
|
Range of Values
|
Default Value
|
|
Configured to Deploy On
|
This attribute is an integer that shows the number of servers on which the pool is configured to deploy.
|
|
|
|
Instances Currently Active
|
This attribute is an integer that shows the number of servers that are currently active for this pool.
|
|
|
Notes
|
Attribute
|
Description
|
Range of Values
|
Default Value
|
|
Notes
|
This attribute provides a space for user supplied information.
|
The value must be an alphanumeric string.
|
Null
|
For more information about Connection Pools, see the Administration Guide.
|
Copyright © 2000 BEA Systems, Inc. All rights reserved.
Required browser: Netscape 4.0 or higher, or Microsoft Internet Explorer 4.0 or higher.
|
