Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Add a log of SQL queries

Description

We can add a log of SQL queries (while we are working in logging - thats not about performance but about debugging)

Environment

None

Activity

Show:

Carlos Ruiz February 22, 2019 at 2:18 PM

Closing as lack of interest from community.

There are several workarounds for this:

  • as explained it can be added as a JVM parameter (or added in idempiereInit.properties)

  • but this can also be achieved in postgresql logging - useful for tuning and/or audit purposes

Carlos Ruiz September 16, 2015 at 4:50 PM
Edited

At workshop I shown it can be done actually for postgresql using the JVM parameter:

-Dorg.idempiere.db.postgresql.debug=true

But suggested that it would be more useful if that can be configured in a running server, so, this ticket is about to explore that new option.

Won't Fix

Details

Assignee

Reporter

Labels

Priority

Created September 15, 2015 at 2:17 PM
Updated April 1, 2019 at 2:53 PM
Resolved February 22, 2019 at 2:18 PM