Jasper Report Exception: An error occured whilst filling the report : net.sf.jasperreports.engine.JRException: Error executing SQL s tatement for

Posted on August 9, 2017 at 8:05am

Hi All, 

When I am executing my jasper report from my Application, I am getting below Error -

Jasper Report Exception: An error occured whilst filling the report : net.sf.jasperreports.engine.JRException: Error executing SQL s tatement for

But when I am using the same report and executing from the JasperSoft, it is running. To debug this issue I ussed the simple query in the report, then also getting the same error from application.

I used the below query -

select item_id , item_name , manufacturer , ship_country , grade from IRON_TABLE
 
Can anyone please help me on this?
 
Regards
Digvijay Singh
diggu1987's picture
diggu1987
2
Joined: Aug 2 2017 - 2:57am
Last seen: 7 months 11 hours ago

1 Answer:

Posted on August 10, 2017 at 11:27pm

You can try setting "net.sf.jasperreports.engine.query.JRJdbcQueryExecuter" to DEBUG in the Manage -> Server Settings -> Log Settings and check the jasperserver.log file under WEBINF\logs dir for more clues. Must be superuser to set this. 

vchiem's picture
vchiem
37795
Joined: May 1 2017 - 5:33pm
Last seen: 8 min 57 sec ago
Feedback