SQL timeout configuration

    Hello Everyone,

   I have a couple of very slow SQL reports which take more than an hour of execution, database returns the error that the query timeout has been reached. How can I configure this timeout in jasper server 5.2.0 ?

roman.davydchenko's picture
Joined: Jul 22 2013 - 11:01pm
Last seen: 8 years 7 months ago

3 Answers:

Hi,

        i have the same issue where I'm getting timeout and socket connection errors because its take almost whole day to render the report. It is possible that it could be firewall issues in your environment. 

polubothusatish's picture
Joined: Jul 23 2013 - 6:10am
Last seen: 9 years 7 months ago

In our Wiki, we have a good JasperReports Server Performance Reference page that might help you.

djohnson53's picture
166386
Joined: May 25 2012 - 11:10am
Last seen: 1 year 7 months ago

You could try to switch to a jndi datasource

mespub's picture
611
Joined: Jan 21 2009 - 1:24pm
Last seen: 3 years 12 months ago
Feedback
randomness