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

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 wsadmin.sh.

To start wsadmin using the Jython language, run the wsadmin -lang Jython command from the bin directory of the server profile.

Use a properties file, you 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 the 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 applyConfigProperties.
delete Property	Edit the properties file so that it lists only the properties to be deleted and then run the deleteConfigProperties command.

Optionally, you can use interactive mode with the commands:

AdminTask.command_name('-interactive')

Procedure

• 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 applyConfigProperties to create or change a data source J2EE resource 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 '])
     

• If you no longer need a data source J2EE resource property, you 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.
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