ADF, JDeveloper, SQL and PL/SQL, Weblogic

How to change logging level of standalone or integrated WebLogic in JDeveloper? For example how to capture SQL executed?

In Integrated WebLogic (JDeveloper) this can be done with just few clicks:

  • Open “IntegratedWeblogicServer – Log” window. On the right-hand top corner click “Actions” and choose “Configure Oracle Diagnostic Logging”
  • For getting SQL statements in the output, in the opened logging.xml choose “oracle.jbo” logger with desired logging level. Level “Finest” will generate maximum output. SQL staements shoud definitely be there.

 

Be careful not to choose too many loggers with quite fine logging level. Otherwise log output can become too massive, flooded and be difficult to find useful info in there.

In standalone WebLogic can accomplish this task using Fusion Middleware Control:

Open Oracle Enterprise Manager, right click on ADF server (i.e. adf_server1), choose LogsĀ -> Log Configuration:

Here You find similar structure like in JDeveloper:

 

You might be also interested in: