You can use properties files to create or delete properties
of data source Java™ 2 Platform,
Enterprise Edition (J2EE) resource property sets.
Before you begin
Determine the changes that you want 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.
About this task
Using 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 your configuration.
Table 1. Actions for properties of
data source J2EE resource property sets. You 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, you can use interactive mode with the commands:
AdminTask.command_name('-interactive')
Procedure
- Create data source J2EE resource properties.
- Specify DataSource J2EEResourcePropertySet properties
in a properties file.
You 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 your 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
- 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 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
You can use the properties file to configure and manage
the data source J2EE resource properties.
What to do next
Save the changes to your configuration.