mdjj Posted April 15, 2009 Share Posted April 15, 2009 Is there a way of seeing the underlying sql that an adhoc report generates? Perhaps some extra logging needs to be turned on?I'm trying to track down why some of our adhoc reports don't produce any data and it would be easier to debug if I could see what actual data was trying to be retrieved via the generated sql statement. Link to comment Share on other sites More sharing options...
rkm258 Posted April 15, 2009 Share Posted April 15, 2009 Hi, Place the below line in log4j.properties file in /WEB-INFlog4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter=debug Ram Link to comment Share on other sites More sharing options...
yashdeep Posted May 1, 2009 Share Posted May 1, 2009 hi!its working fine..... but i can't see any information regarding how much time the query take to get data for database, how many rows returned (result of Query)is thr any option to set Log level to more details..... likelog4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter="debugDetails".....(just an example). Thanks & Regards,Yash Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now