Enabling and disabling remote diagnostic logging for the JDBC proxy

To facilitate troubleshooting, HCL Quality Server administrators can view, download, and share detailed log events information for the JDBC proxy. The capability to display this information in HCL Quality Server requires enabling remote diagnostic logging for the proxy.

About this task

HCL Quality Server can display a diagnostic log that is a centralized view of log events of HCL OneTest™ API proxies.

By default, remote diagnostic logging to HCL Quality Server is not enabled in the HCL OneTest™ API Agent or in the proxies supplied with HCL Quality Server.

To enable or disable remote diagnostic logging to HCL Quality Server for the JDBC proxy, you must modify the startup parameters of the application that you want to record or virtualize.

Procedure

  1. Edit the startup parameters as shown in the following table.
    Note: In the table, stand-alone Java™ applications and Apache Tomcat are two examples of application server software that is supported by the HCL OneTest™ API JDBC proxy. The following application server software is also supported by the JDBC proxy:
    • IBM® WebSphere® Application Server
    • Oracle WebLogic Server
    • Software AG webMethods Integration Server
    • TIBCO BusinessWorks
    For more information about modifying the startup parameters of any of those application servers, refer to the relevant documentation.
    Table 1. Parameters for enabling and disabling remote diagnostic logging for the JDBC proxy to HCL Quality Server
    To: For stand-alone Java™ applications, do the following: For Apache Tomcat, do the following:

    Enable remote diagnostic logging at debug level to HCL Quality Server

    Note: Available levels are error, warning, info, debug, and trace. The Java.Util.Logging (JUL) appender defaults to "level:debug" if level is not set, so all events are passed to Java.Util and filtered there by the separate configuration.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET=level:DEBUG -Dgreenhat.logappender.jul.JUL

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET=level:DEBUG -Dgreenhat.logappender.jul.JUL

    Enable remote diagnostic logging at debug level to HCL Quality Server and specify the URL for the network log appender.

    Note: Available levels are error, warning, info, debug, and trace. Instead of entering a specific URL, you can enter url:auto.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver-Dgreenhat.logappender.net.NET=url:http://IP address or host name:port_number/RTCP,level:DEBUG -Dgreenhat.logappender.jul.JUL

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET=url:http://IP address or host name:port_number/RTCP,level:DEBUG -Dgreenhat.logappender.jul.JUL

    Enable remote diagnostic logging at debug level and internal logging to HCL Quality Server.

    Note: Available levels are error, warning, info, debug, and trace.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET=level:DEBUG -Dgreenhat.logappender.jul.JUL -Dgreenhat.loginternal=appender

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET=level:DEBUG -Dgreenhat.logappender.jul.JUL -Dgreenhat.loginternal=appender

    Enable remote diagnostic logging at error or warning level to HCL Quality Server

    Note: Default remote log level is warning.
    Note: The Java.Util.Logging (JUL) appender is not present, so there will be no local file logging.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.net.NET

    Enable console logging at debug level and use detailed layout.

    Note: If Java™ logging is not enabled, you might want to enable console logging. Console logging layout can be detailed, standard, or compact.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.console.CONSOLE=layout:detailed,level:DEBUG

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.console.CONSOLE=layout:detailed,level:DEBUG

    Enable console logging at debug level, use detailed layout, and log internal framework events.

    Note: Internal events will be sent to the console to help diagnose issues within the logging framework.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.console.CONSOLE=layout:detailed,level:DEBUG -Dgreenhat.loginternal=console

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.console.CONSOLE=layout:detailed,level:DEBUG -Dgreenhat.loginternal=console

    Disable all logging.

    Edit the invocation command line or the system properties within the Java™ application as follows:

    -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.none

    Configure the Tomcat startup script as follows:

    SET JAVA_OPTS=%JAVA_OPTS% -Djdbc.drivers=com.greenhat.jdbc.Driver -Dgreenhat.logappender.none
  2. Save your changes.
  3. Restart the application or application server as required.