Work with data source J2EE resource properties files

Use properties files to create or delete properties of data source J2EE resource property sets.

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

Start the wsadmin scripting tool...

profile_home/bin/wsadmin -lang Jython

Use a properties file to 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 the configuration.

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')

Tasks

• 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 that 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]') 
  

Use the properties file to configure and manage the data source J2EE resource 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 .