How to see the query produced by a birt report

ReportServer (EN)
1

Hi,
I need to troubleshoot a query produced by a birt report.
I looked at catalina.out, but I can’t see the query.
Do you know how to find this information?

Thanks,

Alex

2

Hi Alex,

that is not easy since BIRT composes the query internally and does not invoke ReportServer for the execution. One option would be to look at your database, they usually provide query logging capabilities.

Cheers,
Arno