/
How to resolve a Validation query exception - 10.x

How to resolve a Validation query exception - 10.x

Symptoms

One or more SQL macros return the following error:

org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot create PoolableConnectionFactory (Syntax error: Encountered

Cause

The validation query is either not supported or you are entering an incorrect syntax.

Resolution

Remove the validation query or ensure that the query syntax is correct.

Related content