Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Symptoms

One or more SQL macros return the following error:

Code Block
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 it is correct

Image Removed

Include Page
SUPPORT:How to resolve a Validation query exception - 10.x
SUPPORT:How to resolve a Validation query exception - 10.x