SQL timeout configuration
Posted on October 1, 2013 at 5:05am
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 ?
Joined: Jul 22 2013 - 11:01pm
Last seen: 8 years 7 months ago
Posted on October 1, 2013 at 12:24pm
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.
Joined: Jul 23 2013 - 6:10am
Last seen: 9 years 7 months ago
Posted on October 7, 2013 at 12:03pm
Joined: May 25 2012 - 11:10am
Last seen: 1 year 7 months ago
Posted on October 24, 2013 at 12:15am
You could try to switch to a jndi datasource
Joined: Jan 21 2009 - 1:24pm
Last seen: 3 years 12 months ago