App Connect

 View Only
Expand all | Collapse all

ACE 12.4 postgres service level trace command

  • 1.  ACE 12.4 postgres service level trace command

    Posted Fri June 24, 2022 07:10 AM
    Hi,
    What is the jvmSystemProperty for tracing a postgres 9.4 database within Integration server on ACE 12.4

    for example oracle db  is trace this way mqsichangeproperties <brokerName> -e <egName> -o ComIbmJVMManager -n jvmSystemProperty -v"-Doracle.jdbc.Trace=true"
    as ibm support does not cover this topic : JDBC trace for IBM App Connect Enterprise and IBM Integration Bus

    ------------------------------
    Thabo Shokgolo
    ------------------------------


  • 2.  RE: ACE 12.4 postgres service level trace command
    Best Answer

    Posted Mon June 27, 2022 02:53 PM

    The postgres JDBC driver does not use a Java command argument to enable the trace.  It uses a flag on the JDBC connection URL like:

    jdbc:postgresql://localhost:5432/mydb?loggerLevel=DEBUG
    jdbc:postgresql://localhost:5432/mydb?loggerLevel=TRACE&loggerFile=pgjdbc.log


    ------------------------------
    MATTHEW SEGALL
    ------------------------------