[feature request] more clear exception message

[mtassinari]

Hi everybody

I'm opening this thread to make a "feature request" if possible: I always find hard to understand my reports' problems when there is an exception thrown at compile time, especially when it comes to SQL errors.

The usual message I get is "error executing statement for ***", and that alone isn't much help in identifying the cause of the problem. Wouldn't it be possible, in this specific case, to add the full SQL error message, and more in general to have more self-explaining excepion messages?

[lucianc]

The SQLException is nested inside the JRException as a cause.  If you print the full stacktrace of the exception, you should see the SQLException exception message.

Other than that, I don't know how JR would be able to tell more about an SQL error raised during a query execution.

Regards,

Lucian

[mtassinari]

well, for example the SQL exception should contain at least the error number and error message reported from MySQL.

 

Anyway, I'll give it a look to see if I missed it, perhaps it is already there and I simply did not check the entire stack.