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

We can use properties files to create, modify, or delete JDBC provider properties.

Determine the changes to make to your JDBC provider 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 JDBC provider object.

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

Actions for JDBC provider properties files. We can create, modify, and delete JDBC provider properties.

Action	Procedure
create	Set required properties and then run applyConfigProperties.
modify	Edit required properties and then run applyConfigProperties.
delete	To delete the entire JDBCProvider 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 JDBCProvider properties file.

  1. Set JDBCProvider properties as needed.

     Open an editor on a JDBCProvider properties file. Modify the Environment Variables section to match the system and set any property value that needs to be changed. An example JDBCProvider properties file follows:

     #
     # Header
     #
     ResourceType=JDBCProvider
     ImplementingResourceType=JDBCProvider
     ResourceId=Cell=!{cellName}:Node=!{nodeName}:Server=!{serverName}:JDBCProvider=myJDBCProvider
     #DELETE=true
     #
     
     #
     #Properties
     #
     classpath={${DERBY_JDBC_DRIVER_PATH}/derby.jar}
     name=myJDBCProvider
     implementationClassName=org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource
     nativepath={}
     description=Derby embedded non-XA  JDBC Provider
     #providerType=Derby JDBC Provider #readonly
     xa=false #boolean
     
     EnvironmentVariablesSection
     #Environment Variables
     cellName=myCell
     nodeName=myNode
     serverName=myServer
     

  2. Run applyConfigProperties to create or change a JDBC provider 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.
  1. Obtain a properties file for the JDBC provider that to change.

     We can extract a properties file for a JDBCProvider 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 applyConfigProperties.

• If you no longer need the JDBC provider, you can delete the entire JDBC provider 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 JDBC provider 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

+

Search Tips   |   Advanced Search