Broken connections - 11.x

Symptoms

One or more SQL Macro returns the following error:

java.sql.SQLRecoverableException

Cause

Your connection (part of a connection pool) is being terminated between queries.

Resolution

Add a validation query to your configuration. This helps the application server connection pool recover from database connection problems.

validationQuery="Select 1"

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.