You can use properties files to create, modify, or delete
connection pool properties of a data source.
Before you begin
Determine the changes that you want to make to your data
source configuration or its configuration objects.
Start the
wsadmin scripting tool. To start wsadmin using the Jython language,
run the wsadmin -lang Jython command from the bin directory
of the server profile.
About this task
Using a properties file, you can create, modify, or delete
a connection pool object.
Run administrative commands using
wsadmin to apply a properties file for a connection pool to your configuration,
validate the properties, or delete them.
Table 1. Actions for connection pool properties files. You can create, modify, and delete connection pool properties.
Action |
Procedure |
create |
Set required properties and then run the applyConfigProperties
command. |
modify |
Edit required properties and then run the applyConfigProperties
command. |
delete |
To delete the entire ConnectionPool object,
uncomment #DELETE=true and then run the deleteConfigProperties
command. |
create Property |
Not applicable |
delete Property |
Not applicable |
Optionally, you can use interactive mode with the commands:
AdminTask.command_name('-interactive')
Procedure
- Create a properties file for a ConnectionPool instance.
- Set ConnectionPool properties as needed.
Open
an editor on a ConnectionPool properties file. Modify the Environment
Variables section to match your system and set any property value
that needs to be changed. To specify a custom property, edit the AttributeInfo value
and properties values. An example ConnectionPool properties file follows:
#
# Header
#
ResourceType=ConnectionPool
ImplementingResourceType=JDBCProvider
ResourceId=Cell=!{cellName}:Node=!{nodeName2}:Server=!{serverName2}:JDBCProvider=myJDBCProvider:
DataSource=jndiName#myDataSourceJNDI:ConnectionPool=
AttributeInfo=connectionPool
#
#
#Properties
#
stuckThreshold=0 #integer
unusedTimeout=1800 #long
maxConnections=10 #integer
stuckTimerTime=0 #integer
testConnectionInterval=0 #integer
minConnections=1 #integer
surgeThreshold=-1 #integer
connectionTimeout=180 #long
purgePolicy=EntirePool #ENUM(EntirePool|FailingConnectionOnly)
surgeCreationInterval=0 #integer
numberOfUnsharedPoolPartitions=0 #integer
stuckTime=0 #integer
agedTimeout=0 #long
reapTime=180 #long
testConnection=false #boolean
numberOfSharedPoolPartitions=0 #integer
freePoolDistributionTableSize=0 #integer
numberOfFreePoolPartitions=0 #integer
EnvironmentVariablesSection
#Environment Variables
cellName=myCell
nodeName=myNode
serverName=myServer
- Run the applyConfigProperties command to create or change
a connection pool configuration.
Running the applyConfigProperties
command applies the properties file to the configuration. In this
Jython example, the optional -reportFileName parameter
produces a report named report.txt:
AdminTask.applyConfigProperties(['-propertiesFileName myObjectType.props -reportFileName report.txt '])
- Modify an existing properties file.
- Obtain a properties file for the connection pool that
you want to change.
You can extract a properties file
for a ConnectionPool object using the extractConfigProperties command.
- Open the properties file in an editor and change the
properties as needed.
Ensure that the environment variables
in the properties file match your system.
- Run the applyConfigProperties command.
- If you no longer need the connection pool, you can delete
the entire connection pool object.
Specify DELETE=true in
the header section of the properties file and run the deleteConfigProperties
command; for example:
AdminTask.deleteConfigProperties('[-propertiesFileName myObjectType.props -reportFileName report.txt]')
Results
You can use the properties file to configure and manage
the connection pool object and its properties.
What to do next
Save the changes to your configuration.