WAS v8.5 > Script 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

Work with data source J2EE resource properties files

We can use properties files to create or delete properties of data source J2EE resource property sets.

Determine the changes to make to your data source J2EE resource property set configuration.

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. Using a properties file, we can create or delete data source J2EE resource properties.

Run administrative commands using wsadmin to change a properties file for a data source J2EE resource, validate the properties, and apply them to your configuration.

Actions for properties of data source J2EE resource property sets. We can create and delete data source J2EE resource properties.

Action	Procedure
create	Not applicable
modify	Not applicable
delete	Not applicable
create Property	Add a new property to the properties file and then run the applyConfigProperties command.
delete Property	Edit the properties file so that it lists only the properties to be deleted and then run the deleteConfigProperties command.

Optionally, we can use interactive mode with the commands:

AdminTask.command_name('-interactive')

• Create data source J2EE resource properties.

  1. Specify DataSource J2EEResourcePropertySet properties in a properties file.

     We can extract a properties file for a DataSource J2EEResourcePropertySet object using the extractConfigProperties command. Open the properties file in an editor and change the properties as needed.

     Ensure the environment variables in the properties file match the system. To specify a property, edit the AttributeInfo value and properties values.

     The following example of a DataSource J2EEResourcePropertySet properties file shows new properties in bold:

     #
     # Header 
     #
     ResourceType=J2EEResourcePropertySet
     ImplementingResourceType=JDBCProvider
     ResourceId=Cell=!{cellName}:Node=!{nodeName2}:Server=!{serverName2}:JDBCProvider=myJDBCProvider:
     DataSource=jndiName#myDataSourceJNDI:J2EEResourcePropertySet=
     AttributeInfo=resourceProperties(name,value)
     #
     
     #
     #Properties
     #
     connectionAttributes=upgrade=true #String
     shutdownDatabase= #String
     description= #String
     dataSourceName= #String
     databaseName=${APP_INSTALL_ROOT}/${CELL}/DefaultApplication.ear/DefaultDB #String
     createDatabase= #String
     newProperty=newValue #String
     newIntProp=10 #integer
     
     
     EnvironmentVariablesSection
     #Environment Variables
     cellName=myCell
     nodeName=myNode
     serverName=myServer

  2. Run the applyConfigProperties command to create or change a data source J2EE resource 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 '])

• If we no longer need a data source J2EE resource property, we can delete the property.

  Specify only the property to be deleted in the properties file and then run the deleteConfigProperties command; for example:

  AdminTask.deleteConfigProperties('[-propertiesFileName myObjectType.props -reportFileName report.txt]')

Results

We can use the properties file to manage the data source J2EE resource properties.

Save the changes to your configuration.

Related

Extracting 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

Reference:

PropertiesBasedConfiguration command group for AdminTask using wsadmin.sh

+

Search Tips   |   Advanced Search