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@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...>
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