When we click on Export to Excel buttons we're seeing a large number of these: Opening JDBC connection failed with SQLState: null Message: Cannot get a connection, pool error Timeout waiting for idle object, giving up...(3/3) followed eventually by an out-of-memory crash. Can anyone explain what might be going on please?
The message "Opening JDBC connection failed with SQLState" can be reported in two situations:
The Mendix Business Server cannot connect to the database at all.
All connections between the Mendix Business Server and the database are occupied. You adjust the maximum number of connections in application.conf by changing/adding this line: ConnectionPoolingMaxActive = 500