Maybe it's new from OpenJPA 2.2.0? In any case, it's mentioned in the docs :

(from
http://openjpa.apache.org/builds/2.2.0/apache-openjpa/docs/ref_guide_logging.html#ref_guide_logging_channels)
openjpa.Query: Messages about queries. Query strings and any parameter
values, if applicable, will be logged to the TRACE level at execution
time. Information about possible performance concerns will be logged to
the INFO level.

On 23/05/2012 12:09 AM, Ravindranath Akila wrote:
> Maybe you should get rid of "Query" and try? I haven't seen it before. Hth.
> On May 23, 2012 6:07 AM, "Bertrand Guay-Paquet"<bernie@step...>
> wrote:
>
>> Hi,
>>
>> I'm still not able to get OpenJPA logs.
>>
>> I tried the following combinations:
>> <property name="openjpa.Log" value="stdout, DefaultLevel=TRACE, SQL=TRACE,
>> Query=TRACE" />
>> <property name="openjpa.Log" value="File=c:\openjpa.log,
>> DefaultLevel=TRACE, SQL=TRACE, Query=TRACE" />
>> <property name="openjpa.Log" value="File=../logs/openjpa.**log,
>> DefaultLevel=TRACE, SQL=TRACE, Query=TRACE" />
>>
>> I also followed the recipe from
>> http://mail-archives.apache.**org/mod_mbox/openjpa-users/**200901.mbox/%**
>> 3Cc4a1048f0901071037x6ad504b6k**9df488fe7b0b8832@mail.gmail.**com%3E<http://mail-archives.apache.org/mod_mbox/openjpa-users/200901.mbox/%3Cc4a1048f0901071037x6ad504b6k9df488fe7b0b8832@mail...%3E>
>> and tried
>> <property name="openjpa.Log" value="commons" />
>> and
>> <property name="openjpa.Log" value="commons, DefaultLevel=TRACE,
>> SQL=TRACE, Query=TRACE" />
>>
>> with a logging.properties file in WEB-INF/classes:
>> ===BEGIN===
>> handlers = org.apache.juli.FileHandler, java.util.logging.**ConsoleHandler
>>
>> org.apache.juli.FileHandler.**level = ALL
>> org.apache.juli.FileHandler.**directory = ${catalina.base}/logs
>> org.apache.juli.FileHandler.**prefix = openjpa.
>>
>> java.util.logging.**ConsoleHandler.level = ALL
>> java.util.logging.**ConsoleHandler.formatter = java.util.logging.**
>> SimpleFormatter
>>
>> # enable SQL logging
>> openjpa.jdbc.SQL.level=ALL
>> ===END===
>>
>> With this last try, logs/openjpa.date.log is created but it doesn't
>> contain any SQL statements.
>>
>> I'm starting to think that since OpenJPA is initialized by TomEE all
>> logging settings are already set when my persistence.xml is loaded. Did you
>> manage to successfully use the properties you suggested in a real web app?
>>
>> Regards,
>> Bertrand
>>
>>
>> On 16/05/2012 1:31 PM, Ravindranath Akila wrote:
>>
>>> Sorry, correction: should be trace, not debug
>>>
>>> <property name="openjpa.Log" value="File=../logs/openjpa.**log,
>>> DefaultLevel=TRACE, Runtime=TRACE, SQL=TRACE"/>
>>>
>>> On May 16, 2012 10:58 PM, "Ravindranath Akila"<ravindranathakila@**
>>> gmail.com<ravindranathakila@gmai...>>
>>> wrote:
>>>
>>>> Hth:
>>>>
>>>> <property name="openjpa.Log" value="File=../logs/openjpa.**log,
>>>>
>>> DefaultLevel=DEBUG, Runtime=DEBUG, SQL=DEBUG"/>
>>>
>>>> On May 16, 2012 9:28 PM, "Bertrand Guay-Paquet"<bernie@step.**polymtl.ca<bernie@step...>
>>> wrote:
>>>
>>>> Hi,
>>>>> Another question regarding logging + TomEE :)
>>>>>
>>>>> I followed the instructions in the OpenJPA documentation to increase the
>>>>>
>>>> logging level of JPA to show SQL statements but it didn't work. Do I need
>>> to do anything special for it to work inside TomEE? Ideally, I'd love to
>>> set the logging level for a single WAR.
>>>
>>>> Here's what I tried.
>>>>> In persistence.xml:
>>>>> <property name="openjpa.Log" value="slf4j" />
>>>>>
>>>>> In WEB-INF/classes/log4j.**properties of my WAR:
>>>>> log4j.category.openjpa=TRACE
>>>>> log4j.category.openjpa.jdbc.**SQL=TRACE
>>>>> log4j.category.openjpa.Query=**TRACE
>>>>>
>>>>> In conf/logging.properties:
>>>>> log4j.category.openjpa=TRACE
>>>>> log4j.category.openjpa.jdbc.**SQL=TRACE
>>>>> log4j.category.openjpa.Query=**TRACE
>>>>>
>>>>> In the catalina log I see:
>>>>> WARNING: Log4j not installed. The following properties will be ignored.
>>>>> 16-May-2012 3:41:16 PM org.apache.openejb.OpenEJB$**Instance<init>
>>>>> WARNING: Ignored conf/logging.properties property
>>>>>
>>>> 'log4j.category.openjpa'
>>>> 16-May-2012 3:41:16 PM org.apache.openejb.OpenEJB$**Instance<init>
>>>>> WARNING: Ignored conf/logging.properties property
>>>>>
>>>> 'log4j.category.openjpa.jdbc.**SQL'
>>>> 16-May-2012 3:41:16 PM org.apache.openejb.OpenEJB$**Instance<init>
>>>>> WARNING: Ignored conf/logging.properties property
>>>>>
>>>> 'log4j.category.openjpa.Query'
>>>> Obviously, I'm not using the right approach but I don't know where to
>>>> find instructions so I'm asking here.
>>>> Regards,
>>>>> Bertrand
>>>>>