Network Deployment (Distributed operating systems), v8.0 > Scripting the application serving environment (wsadmin) > Use properties files to manage system configuration > Manage specific configuration objects using properties files > Work with JDBC provider properties files
Work with CMP connection factory properties files
We can use properties files to create, modify, or delete container managed persistence (CMP) connection factory properties.
Determine the changes to make to your CMP connection factor configuration or its configuration objects.
Start wsadmin.sh.
To start wsadmin using the Jython language, run the wsadmin -lang Jython command from the bin directory of the server profile.
Use a properties file, you can create, modify, or delete a CMP connection factory object.
Run administrative commands using wsadmin to apply a properties file for a CMP connection factory to the configuration, validate the properties, or delete them.
Actions for CMP connection factory properties files. We can create, modify, and delete CMP connection factory 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 CMPConnectorFactory 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 CMPConnectorFactory instance.
- Set CMPConnectorFactory properties as needed.
Open an editor on a CMPConnectorFactory properties file. Modify the Environment Variables section to match the system and set any property value that needs to be changed. An example CMPConnectorFactory properties file follows:
# # Header # ResourceType=CMPConnectorFactory ImplementingResourceType=J2CResourceAdapter ResourceId=Cell=!{cellName}:Node=!{nodeName}:Server=!{serverName}:J2CResourceAdapter=myJ2CResourceAdapter: CMPConnectorFactory=jndiName#myCFJNDI #DELETE=true # # #Properties # name=myCF #required connectionDefinition=Cell=!{cellName}:Node=!{nodeName}:Server=!{serverName}:J2CResourceAdapter= myJ2CResourceAdapter:Connector=:ResourceAdapter=:OutboundResourceAdapter=:ConnectionDefinition= connectionFactoryImplClass#com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl #ObjectName (ConnectionDefinition),required category=null authMechanismPreference=BASIC_PASSWORD #ENUM(BASIC_PASSWORD|KERBEROS),default(BASIC_PASSWORD) providerType=null jndiName=myCFJNDI #required diagnoseConnectionUsage=false #boolean,default(false) xaRecoveryAuthAlias=null authDataAlias=null manageCachedHandles=false #boolean,default(false) description=null logMissingTransactionContext=true #boolean,default(true) # EnvironmentVariablesSection #Environment Variables cellName=myCell nodeName=myNode serverName=myServer- Run applyConfigProperties to create or change a CMP connection factory configuration.
Run applyConfigProperties 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 CMP connection factory to change.
We can extract a properties file for a CMPConnectorFactory 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 the system.
- Run applyConfigProperties.
- If you no longer need the CMP connection factory, you can delete the entire CMP connection factory 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
We can use the properties file to configure and manage the CMP connection factory object and its properties.
What to do next
Save the changes to the configuration.
Extract properties files using wsadmin.sh
Create server, cluster, application, or authorization group objects using properties files and wsadmin scripting
Delete server, cluster, application, or authorization group objects using properties files
Related
PropertiesBasedConfiguration command group using wsadmin.sh