Validation query throwing exception - 11.x
Symptoms
One or more SQL macros return the following error:
org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot create PoolableConnectionFactory (Syntax error: EncounteredCause
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.