Work with connection pool properties files

Use properties files to create, modify, or delete connection pool properties of a data source.

Determine the changes to make to the data source configuration or its configuration objects.

Start the wsadmin scripting tool...

profile_home/bin/wsadmin -lang Jython

Use a properties file to create, modify, or delete a connection pool object.

Run administrative commands using wsadmin to apply a properties file for a connection pool to the configuration, validate the properties, or delete them.

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, we can use interactive mode with the commands:

AdminTask.command_name('-interactive')

Tasks

• Create a properties file for a ConnectionPool instance.

  1. Set ConnectionPool properties as needed.

     Open an editor on a ConnectionPool properties file. Modify the Environment Variables section to match the 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
     

  2. 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.
  1. Obtain a properties file for the connection pool to change.

     We can extract a properties file for a ConnectionPool object using the extractConfigProperties command.

  2. Open the properties file in an editor and change the properties as needed.

     Ensure that the environment variables in the properties file match the system.

  3. Run the applyConfigProperties command.

• If we no longer need the connection pool, we 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]') 
  

Use the properties file to configure and manage the connection pool object and its properties.

What to do next

Save the changes to the configuration.

Extracting properties files

Create server, cluster, application, or authorization group objects using properties files and wsadmin scripting

Deleting server, cluster, application, or authorization group objects using properties files

PropertiesBasedConfiguration .