How to ignore or gracefully handle SQL error?

0

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

goran.matisa's picture
Joined: Jan 7 2014 - 3:52am
Last seen: 1 year 8 months ago

2 Answers:

0

Had a similar problem and decided to use REST v2 API to display reports. I'm also able to better validate parameters value entries.

hozawa's picture
47137
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 months 2 weeks ago
0

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!

 

goran.matisa's picture
Joined: Jan 7 2014 - 3:52am
Last seen: 1 year 8 months ago
Feedback
randomness