Using the Driver for Logging

If you want to configure logging using the driver, you can use either of the following approaches:

Use a single properties file for all Oracle Service Cloud connections.

Use a different properties file for each embedded database. For example, if you have two embedded databases (johnsmith.xxx and pattijohnson.xxx, for example), you can load one properties file for the johnsmith.xxx database and load another properties file for the pattijohnson.xxx database.

Note: By default, the name of the embedded database is the user ID specified for the connection. You can specify the name of the embedded database using the DatabaseName connection property. See Connection Property Descriptions for details about using the DatabaseName connection property.

By default, the driver looks for the file named ddlogging.properties in the current working directory to load for all Oracle Service Cloud connections.

If a properties file is specified for the LogConfigFile connection property, the driver uses the following process to determine which file to load:

1. The driver looks for the file specified by the LogConfigFile property.

2. If the driver cannot find the file in Step 1, it looks for a properties file named database_name.logging.properties in the directory containing the embedded database for the connection, where database_name is the name of the embedded database.

3. If the driver cannot find the file in Step 2, it looks for a properties file named ddlogging.properties in the current working directory.

4. If the driver cannot find the file in Step 3, it abandons its attempt to load a properties file.

If any of these files exist, but the logging initialization fails for some reason while using that file, the driver writes a warning to the standard output (System.out), specifying the name of the properties file being used.

See Connection Property Descriptions for details about using the LogConfigFile connection property.

A sample properties file is installed in the installdir/testforjdbc and installdir/Samples/Example directories, where:

The file is named ddlogging.properties.You can copy this file from either location to the current working directory of your application or embedded database directory, and modify it using a text editor for your needs.