db.xml file parameters

Edit online

The db.xml file contains all of the database-related parameters and is located in the $TOP/etc/default directory.

If you set the encrypt_password parameter to yes in the env_settings.ini file, the db_password_encrypted element contains the encrypted database password. If you set the encrypt_password parameter to no, the db_password_plain element contains the database password in plain text format.
The elements in the db.xml file replace the following properties that were previously stored in the common.properties file:
  • db_userName
  • db_password
  • db_url
  • db_class_name
Note: Ensure that these properties are removed from the common.properties file.
You can encrypt the database password. The encrypt_password parameter controls whether an encrypted database password should be used.
Note: With the encrypt_password parameter set to yes, the database-related scripts require the dbpassword argument to be specified when launching the scripts. If the dbpassword argument is not specified, you are prompted to enter the password.
Parameter Description Value Example
db_class_name Defines the fully qualified database class name of the database driver you use to connect to the database. Class name

Db2® - com.ibm.db2.jcc.DB2Driver

Oracle - oracle.jdbc.driver.OracleDriver

 
db_class_name=oracle.jdbc.driver.OracleDriver
db_password Defines the password to log in to the database. Database password 
db_password=open
db_url Defines the JDBC URL used to connect to the database. JDBC URL 
db_url=jdbc:oracle:thin:@:host_name:1521:instance_name
db_userName Defines a username to log in to the database Database username 
db_userName=DB_User