There are quite a few Jboss users who have downloaded/use P6Spy, and I just wanted everyone to know it has now been released as an open source project: http://www.p6spy.com
For those of you unfamilar with p6spy, it is an application that intercepts and logs the database statements. Session beans, entity beans, BMPs ... direct statements issued in your servlet container. It is also easy to install, with specific Jboss instructions. A useful tool to see what is (or is not) going on with your DB statements.