> I could get to the bottom of this if I could just see what 
> the container is doing when the findAll() is triggered. 
> My question is: is there a way to print or log the SQL SELECT 
> statement that the container has executed on my entity bean's 
> behalf? If not, can anyone suggest a good way to debug
> something like this?

Yes, you can (there are few places where you can turn logging on and off):

jaws.xml or standardjaws.xml and specify:
<jaws>
  ...
  <debug>true</debug>
  ...
</jaws>

jboss.xml or standardjboss.xml in you CMP container configuration:

<!-- prints the method invoked by container -->
<call-logging>true</call-logging> 

in jboss.jcml in your datasource configuration:

<mbean ...>
  ...
  <attribute name="LoggingEnabled">true</attribute>
</mbean>


Also, do not forget to watch the server.log, not the console output, because
SQL statements appear only in server log (at least in my case).

Roman

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to