<property name="openjpa.Log" value="SQL=TRACE" />
<property name="openjpa.ConnectionFactoryProperties"
value="printParameters=true" />

- Romain


2012/5/16 Ravindranath Akila <ravindranathakila@gmai...>

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