mattmattb Posted October 20, 2009 Share Posted October 20, 2009 I want to debug the query that is being run as I create an adhoc report. As I start adding columns the live update preview is showing data from my data source (this is how adhoc report tool works). Obviously there is a query running (this is a JDBC data source) and my Domain (which I've made an adhoc topic out of) has about 10 tables with basic inner joins. However, the 3rd column I try to add, the data preview disappears and adhoc tells me that no data can be displayed, so obviously adding that column to the query is stopping the query from returning data and try as I might, I don't see any messed up or missing joins in the domain designer for this domain. Seeing the query being run in a debug would help me immensely to solve this problem, any help here or other ideas ? Thanks, Matt Link to comment Share on other sites More sharing options...
Solution mdahlman Posted October 20, 2009 Solution Share Posted October 20, 2009 Matt,I think these are the lines you want in <tomcat>/webapps/jasperserver-pro/WEB-INF/log4j.properties:log4j.logger.com.jaspersoft.commons.semantic.datasource.impl.SemanticLayerSecurityResolverImpl=DEBUGlog4j.logger.com.jaspersoft.commons.semantic.dsimpl.JdbcTableDataSet=DEBUGlog4j.logger.com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter=DEBUGlog4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter=DEBUGlog4j.logger.com.jaspersoft.commons.semantic.dsimpl.JdbcBaseDataSet=DEBUGYou will need to restart JasperServer.Alternatively/additionally, you can add these same settings using the super-secret log_settings.html page. It's an undocumented feature that might go away or change radically. But for quick tests it's great. Navigate here after logging in as superuser:http://localhost:8080/jasperserver-pro/log_settings.htmlRegards,Matt Link to comment Share on other sites More sharing options...
mattmattb Posted October 20, 2009 Author Share Posted October 20, 2009 Perfect!! Thank you so much for the help. Link to comment Share on other sites More sharing options...
suedonne123 Posted October 21, 2009 Share Posted October 21, 2009 I am interested in the above "secret" log_settings.html but this cannot be found on my instance...I am running JasperServer Pro version 3.0.2... Link to comment Share on other sites More sharing options...
swood Posted November 2, 2009 Share Posted November 2, 2009 I don't think that page is in JS Pro 3.0.2. ShermanJaspersoft 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