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 the 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 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.

data source J2EE resource property sets. We can create

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

Results

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

What to do next

Save the changes to the configuration.

Related tasks

Extracting properties files

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

PropertiesBasedConfiguration (AdminTask)