To Edit Database Properties for the Oracle Database

Follow these steps if you will be using the Oracle database instead of Java DB. These steps assume that you have opened a copy of the install.properties or install.properties.template file in a text editor.

Change the values of the registry.install.RequireDatabaseAuthentication, registry.install.DatabaseUserID, and registry.install.DatabasePassword properties to match the values you provided for the Oracle user name and password in To Create a Database User:
```
registry.install.RequireDatabaseAuthentication=true
registry.install.DatabaseUserID=user-name
registry.install.DatabasePassword=password
```

Put comment characters (#) in front of the lines that define properties for Java DB, so that they look like the following:

#registry.install.clientDatabase=false
#registry.install.databaseHost=localhost
#registry.install.databasePort=1527
#registry.db.dialect=org.freebxml.omar.server.repository.hibernate.DerbyDialect
#registry.install.jdbcClassName=org.apache.derby.jdbc.EmbeddedDriver
#registry.install.dbURL=jdbc:derby:$omar.home/data/registry/soar;create=true
#registry.install.dbTransactionIsolation=TRANSACTION_READ_UNCOMMITTED
#registry.database.supportsOrderBy=true

Remove the comment characters from the lines that define properties for the Oracle database, so that they look like the following.

Note –

Each property definition must appear on one line. The registry.install.dbURL and registry.install.dbURLFixed appear on two lines below so that they fit on the page.

registry.install.clientDatabase=true
registry.install.databaseHost=localhost
registry.install.databasePort=1521
registry.install.nonJavaDB=true
registry.install.jdbcClassName=oracle.jdbc.driver.OracleDriver
registry.install.jdbcDataSourceName=oracle.jdbc.pool.OracleDataSource
registry.install.dbURL=jdbc:oracle:thin:@${registry.install.databaseHost}:
${registry.install.databasePort}:soar
registry.install.dbURLFixed=jdbc\\:oracle\\:thin\\:@${registry.install.databaseHost}\\:
${registry.install.databasePort}\\:soar
registry.db.installScript=database.sql
registry.db.cleanupScript=cleanup.sql
libs.db.jar=../lib/ojdbc14.jar
registry.db.dialect=net.sf.hibernate.dialect.Oracle9Dialect
registry.install.dbTransactionIsolation=TRANSACTION_READ_COMMITTED

Note –

The values of the registry.install.dbURL and registry.install.dbURLFixed properties assume that you gave the Oracle database the name soar when you followed the instructions in Configuring an Oracle Database for Use with Service Registry.

Add the following property definition to the file:
```
registry.database.supportsOrderBy=false
```
You must set this property in order for Service Registry to work correctly with an Oracle database. If you do not set this property, some queries will fail.

If the Oracle database is not installed on the same machine as Service Registry, change the value of the registry.install.databaseHost property from localhost to the IP address or hostname of the system where the Oracle database is installed (for example, 111.222.33.44 or mysys.mydomain.mycompany.com).