SQL Code

[t00d33]

Can someone please tell me how I can get hold of the SQL code generated by the Container. I need to keep an audit log of all Database updating SQL, but I'm using CMP Entity Beans. Can anyone please help?

[joelvogt]

You can try playing around with the log4j.properties. Generally you can produce as much debug as you want.
Alternatively, many jdbc drivers have a trace option that will dump all the commands to a file