How to resolve a Validation query exception - 10.x

Owned by Smita Nair
Feb 18, 2020

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.