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: 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.

Log a request with our support team.

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