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.

Find answers from the community.

Ask a question to the community.

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2022 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.