You can see executed SQL statements by increasing log level to DEBUG for category org.jboss.ejb.plugins.cmp and also increasing the threshold to DEBUG for console or log file.
I fought with this problem for a while. I found that the primkey-field tag was missing from my ejb-jar.xml file. It should look something like this:
I was using EJBDoclet to generate this file, and had just hacked up a sample provided with JBoss. The reason that the EJBDoclet was not creating the ejb-jar.xml correctly was because I was not specifying the primkey-field on the bean class. Instead, I was @ejb:pk-field on the getter method. @ejb:pk-field is meant only for composite keys.
Hope this helps
Yep, that did it..Also got the log thang going..
Thanx for both suggestions..