wso2openjpawso2-as

How to configure openjpa logging in wso2as


I am trying to see the SQL generated by openjpa on WSO2AS 5.3.0. I tried: - to update system.properties in /tomee - add openjpa.Log to persistence.xml, using a resource_local transaction but also with jta, with a File attribute, or with log4j - adding log4j.properties to /log4j.properties

No matter what I try, I see no output from openjpa!

Any ideas?


Solution

  • It turns out that in logging-bridge.properties, the logging levels use the commons/jdk logging levels: so ALL / FINEST / FINER / FINE / CONFIG / INFO.

    When changing the level for openjpa.jdbc.SQL.level=ALL and org.wso2.carbon.bootstrap.logging.handlers.LoggingConsoleHandler.level = ALL, it works.