i have seen many results with same query in Google some i understood/tries and some not working and some suggests a solution which start from the middle. like this and tried this one made change in log4j.properties not working and this I have tried making those changes and saw catelina.out for debug statements i didn't get anything.
Am I missing any thing?
instead of jasper report queries logging i used SET GLOBAL general_log = 'ON' to log mysql queries fired which is given by jasper report. we should run that command in mysql terminal. and then in /var/lib/mysql(mine ubuntu 14) you will see .log file where you can check for queries fired