See exact query execution in Oracle ADF

Challenge

You want to be able to see all the sql-statements and DML-statements that your ADF application is executing.

Solution

  1. Just add the following java option to the run configuration : -Djbo.debugoutput=console
    While this will give you everything you need, you get a lot of clutter and it is difficult to see the information you are looking for.
  2. ADF Logger: While you just run your application, no special run configuration or debug setting is needed, you can change the log level of the different ADF components.  The change is immediate active, no rerun or stopping of the jvm is needed.
    In case you want to see the SQL and DML statements you need to set the oracle.jbo.common.ADFLoggerDiagnosticImpl to FINEST, anything lower will not show the statements.

How to set this logger level?

Follow this procedure to use the logger level:

  1. Just run or debug your application.
  2. In the Log-pane you should see your application starting up.
  3. In this pane, there is an Action-menu.  Choose here the “Oracle Diagnostic Logging”-option.
  4. This will open a new tab, called “logging.xml”.
  5. Now walk through the tree until you find the

    oralce.jbo.common.ADFLoggerDiagnosticImpl

  6. And then select in the Level column “Finest” or type “TRACE:32”.
  7. This change is active immediately. You should see appearing the SQL-statements in the Log pane when you are walking through your application.

ADFLogger_1

ADFLogger_2

ADFLogger_3

Ref:blog