We are currently updating our server and we are running into some issues with connections timing out (or the server breaking the connection) for some of our longer running SQL query's. If the query takes longer than one minute we get a error 500 and the error log tells of a broken connection. Can anyone tell us were the settings are in jasperserver 6.0 to wait longer for a response from the database.
Thanks
2 Answers:
Posted on March 10, 2015 at 3:04am
Have you checked the following thread?
https://community.jaspersoft.com/questions/534989/settings-required-gene...
Thank you for your reply. Unfortunately that does not seem to be the problem. We are using stored procedures for our reports so some of the queries can take several minutes before they start sending back any data. I think the connection to our database is disconnected after 60 seconds, so that makes me think that there is a timeout setting somewhere set to 60 seconds. I'm just not sure where the disconnect is happening.
how to solve the database connection disconnection problems