EJB insert SQL--how to log?

[robjacobs]

I'm getting an error when running JBoss 3.2 with Oracle--trying to create and insert an entity bean.
I'm getting a java.sql.SQLException: ORA-00904: invalid column name

I've compared the definition of the bean in the jbossjdbc-cmp.xml file with the db table, and the column names seem to match.

I'm not finding anything useful in the stack trace or in Oracle's logs, is there a way with JBOSS to log the JDBC sql that is generated for a CMP 2.0 EJB prior to insert? Something in the log4j.xml, perhaps?

[raja05]

Change the Threshold parameter in jbossdist/server//conf/log4j.xml from INFO to DEBUG.
That shud log ur sql statements. If you dont want all debug but only for CMP,
create a new category like




in ur jboss.xml

[robjacobs]

Thanks. That did it.