How to enable log level for EJB3 QL?

[hotat27]

How to enable log level for EJB3 QL? So the native SQL queries that were generated from EJBQL will be seen on console or log?

Regards,
Steven

[alrubinger]

EJB3 Entities in JBoss use Hibernate under the hood. So in persistence.xml, I pass in the property:

<property name="hibernate.show_sql" value="true" />

I'm pretty sure this instructs Hibernate to write to System.out. If anyone knows how to get this sent to Commong Logging or Log4J appenders, I'd love to know.

I also like to see the output from the Schema Export, so set the following in my $JBOSS_HOME/server//[servername]/conf/log4j.xml:

<!-- Show SQL Logs for Hibernate Schema Export -->
 <category name="org.hibernate.tool.hbm2ddl.SchemaExport">
 <priority value="DEBUG" />
 </category>

S,
ALR

[muhviehstarr]

you just need to add this to your log4j.xml:

 <category name="org.hibernate.SQL">
 <priority value="DEBUG"/>
 <appender-ref ref="YOURAPPENDER"/>
 </category>

[alrubinger]

Beautiful; thank you.

S,
ALR

"muhviehstarr" wrote:
you just need to add this to your log4j.xml:

 <category name="org.hibernate.SQL">
 <priority value="DEBUG"/>
 <appender-ref ref="YOURAPPENDER"/>
 </category>

[alrubinger]

Good logging reference at the bottom of:

http://wiki.jboss.org/wiki/Wiki.jsp?page=JBossHibernate3.

S,
ALR