Hibernate SQL statements are not getting logged

[grettke_spdr]

Hi folks,

I'm running Seam 1.2.1 on JBoss 4.0.5GA.
Also using JPA EntityManager, not going straight against a Session.

In each of my persistence.xmls, I've added

<!-- Echo all executed SQL to stdout -->
<property name="show_sql" value="true" />
<!-- pretty print of all SQL-Statements -->
<property name="hibernate.format_sql" value="true" />

to the properties of my datasource.

When the app is deployed, I can see the sql statements that create the database (as hibernate.hbm2ddl.auto is set to create-drop). I can also see the statements for entities get pregenerated. This is all in the default server log.

When I run the app, persist my entities, and let the method complete on the EJB, I don't see the actual SQL that is getting executed to persist my entities.

What am I doing wrong here?

[fernando_jmt]

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

[grettke_spdr]

"fernando_jmt" wrote:

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

Thank you Fernando!

[tony.herstell1]

As well as the above...

In JBoss conf area is a file, log4j.xml, that controls logging.
I find it kinda useful to set hibernate debugging to DEBUG in that file.

Useful for things like that you can't use a reserved work for an entity property name! (even though seam did actually report this early and I didn't see it!).

I can post the Kung-Fu to add to the relevant logging file if you require it.

[grettke_spdr]

I can post the Kung-Fu to add to the relevant logging file if you require it.

Any and all kung-fu are welcome.