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
------------------------------
Original Message:
Sent: Fri June 24, 2022 04:35 AM
From: Thabo Shokgolo
Subject: ACE 12.4 postgres service level trace command
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
------------------------------