adam_13 Posted March 9, 2015 Share Posted March 9, 2015 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 Link to comment Share on other sites More sharing options...
hozawa Posted March 10, 2015 Share Posted March 10, 2015 Have you checked the following thread?https://community.jaspersoft.com/questions/534989/settings-required-generating-large-reports Link to comment Share on other sites More sharing options...
adam_13 Posted March 10, 2015 Author Share Posted March 10, 2015 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. Link to comment Share on other sites More sharing options...
Solution adam_13 Posted March 13, 2015 Author Solution Share Posted March 13, 2015 We found the issue. We are using bitnami stack. The stack uses Apache2. Under appache2/conf/extra/httpd-default.conf we change some timeout settings. Under appache2/conf/httpd.conf we enable httpd-default.conf. Link to comment Share on other sites More sharing options...
rn.chotu.177 Posted August 31, 2022 Share Posted August 31, 2022 how to solve the database connection disconnection problems Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now