skip to main content
Troubleshooting : Diagnostic Tools : Configuring Logging : Using the Driver
  

Try DataDirect Drivers Now
Using the Driver
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 Database attribute. See "Connection Option Descriptions" for details on using LogConfigFile and other connection options.
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 the SQLEngineMode connection option is set to Server, the driver uses the ddlogging.properties file that is specified by the Server DB Directory connection option.
If a properties file is specified for the LogConfigFile connection option, the driver uses the following process to determine which file to load:
1. The driver looks for the file specified by the LogConfigFile connection option.
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 ddlog.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.
A sample properties filenamed ddlogging.properties is installed in the install_dir\samples subdirectory of your product installation directory, where install_dir is your product installation directory. For example, you can find the ddlogging.properties file in install_dir\Samples\Bulkstrm, install_dir\Samples\Bulk, and install_dir\Samples\Example. You can copy this file to the current working directory of your application or embedded database directory, and modify it using a text editor for your needs.