Enable DEBUG level logging on org.jboss.ejb.plugin.cmp, and (optionally) direct that to a separate log file (such as db.log). This gives you a good idea what SQL is being executed on the DB.
Thank you very much for your help.
In the log4j.xml i already have
so i changed that to
and i am getting all the database executed queries in detail.
I wasted 3 days in just trying to figure out this using triggers.
Thanks once again