How to ignore or gracefully handle SQL error?
Posted on September 25, 2015 at 7:52am
Hi,
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)
or
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)
With regards,
Goran
Joined: Jan 7 2014 - 3:52am
Last seen: 3 years 1 week ago
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.
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 3 months ago
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!
Joined: Jan 7 2014 - 3:52am
Last seen: 3 years 1 week ago
