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 data source properties files
We can use properties files to create, modify, or delete data source properties.
Determine the changes to make to your data source configuration or its configuration objects.
Start wsadmin.sh.
To start wsadmin using the Jython language, run...
WP_PROFILE/bin/wsadmin -lang jython
Use a properties file, you can create, modify, or delete a data source object.
Run administrative commands using wsadmin to apply a properties file for a data source to the configuration, validate the properties, or delete them.
Actions for data source properties files. You can create, modify, and delete data source properties.
Action Procedure create Set required properties and then run applyConfigProperties. modify Edit required properties and then run applyConfigProperties. delete To delete the entire DataSource object, uncomment #DELETE=true and then run deleteConfigProperties. 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 DataSource instance.
- Set DataSource properties as needed.
Open an editor on a DataSource properties file. Modify the Environment Variables section to match the system and set any property value that needs to be changed. An example DataSource properties file follows:
# # Header # ResourceType=DataSource ImplementingResourceType=JDBCProvider ResourceId=Cell=!{cellName}:Node=!{nodeName}:Server=!{serverName}:JDBCProvider=myJDBCProvider:DataSource=jndiName#myDataSourceJNDI #DELETE=true # # #Properties # name=myDataSource category=null datasourceHelperClassname=com.ibm.websphere.rsadapter.DerbyDataStoreHelper authMechanismPreference=BASIC_PASSWORD #ENUM(BASIC_PASSWORD|KERBEROS) statementCacheSize=10 #integer #providerType=Derby JDBC Provider #readonly jndiName=myDataSourceJNDI relationalResourceAdapter=WebSphere Relational Resource Adapter #ObjectName(J2CResourceAdapter) xaRecoveryAuthAlias=null diagnoseConnectionUsage=false #boolean authDataAlias=null manageCachedHandles=false #boolean #provider=Derby JDBC Provider #ObjectName(JDBCProvider),readonly description=Datasource for the WebSphere Default Application logMissingTransactionContext=true #boolean EnvironmentVariablesSection #Environment Variables cellName=myCell nodeName=myNode serverName=myServer- Run applyConfigProperties to create or change a data source 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 data source that you want to change.
We can extract a properties file for a DataSource 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 data source, you can delete the entire data source object.
Specify DELETE=true in the header section of the properties file and run deleteConfigProperties; for example:
AdminTask.deleteConfigProperties('[-propertiesFileName myObjectType.props -reportFileName report.txt]')
Results
We can use the properties file to configure and manage the data source 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