---
title: "Broken Connections"
canonical: "https://support.appfire.com/space/SQL/74318277/Broken%20Connections"
format: markdown
---
> Macro (aura-html)

# 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"
```


.