How to ignore or gracefully handle SQL error?
Posted on September 25, 2015 at 7:52am
Is there a way to:
a) ignore sql error in a report so that execution doesn't get interrupted (of course, if other report parts depend on erroneous sql query, report will break eventually)
b) gracefully handle error - ie. our database application raises errors as a informative feedback for the calling client so we would like to catch and display error code and the message (if possible via customizing some Jasper classes)
Posted on September 25, 2015 at 10:06am
Had a similar problem and decided to use REST v2 API to display reports. I'm also able to better validate parameters value entries.
Posted on September 30, 2015 at 3:19am
REST v2 API concept is new to me, and, as far as I understood, it requires Jasperreports Server component.
Since our current configuration doesn't include Server, that type of solution is not an option at the time.
Anyway, thanks for the hint!