Setting up the sQLProxy tool

About this task

To set up the SQLProxy tool, you must add properties to the customer_overrides.properties file prior to starting the application server or noapp server. These will override settings for these properties in jdbc.properties.

Note: The SQLProxy properties in the yfs.properties file (such as yfs.enable.proxy.sql.logging, yfs.enable.source.logging, and yfs.proxy.log.dir) have been deprecated. All users, regardless of whether you are using a third party application server (WebSphere®, JBoss, WebLogic) or the noapp server, must configure the tool by adding the following JDBC properties to the customer_overrides.properties file.

Procedure

  1. In the \install_dir\properties\ folder, locate the customer_overrides.properties file or create it, if it does not exist.
  2. Set the following properties in customer_overrides.properties:

    jdbcService.proxyLoggingEnabled=Y

    (Determines if logging is needed.)

    jdbcService.proxySourceLogging=Y

    (Provides additional caller information.)

    jdbcService.proxyLogDir=<INSTALL_DIR>\logs

    (Directory where the trace files will be generated.)