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