Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
Teams
, (opens new window)
SQL for Confluence
Results will update as you type.
  • Get started
  • Data Center 11.x
    • Help and support - 11.x
      • Troubleshoot Data Source Profiles - 11.x
      • Troubleshoot Application Server Based Data Sources - 11.x
        • Access denied - 11.x
        • Data source name not found - 11.x
        • Class not found - 11.x
        • Validation query throwing exception - 11.x
        • Could not connect to database server - 11.x
        • Authentication failed - 11.x
        • Broken connections - 11.x
        • Invalid database port - 11.x
        • Listener refused connection - 11.x
        • No JDBC driver - 11.x
        • Database server not found - 11.x
        • isValid exceptions - 11.x
        • Generic SQL exception - 11.x
        • Validation query throwing Oracle exception - 11.x
        • User authority - 11.x
      • Sample queries - Confluence labels
      • SQL for Confluence Announcement and FAQ
    • Use cases - 11.x
    • Macro Reference - 11.x
    • Key Concepts - 11.x
    • Overview - Data Center 11.x
    • Installation and configuration - Data Center
  • Cloud
  • Release notes
  • Help and support
    You‘re viewing this with anonymous access, so some content might be blocked.
    /
    Validation query throwing exception - 11.x
    Updated Aug 07

    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.

     

    Need support? Create a request with our support team.

    Copyright © 2005 - 2025 Appfire | All rights reserved.

    {"serverDuration": 13, "requestCorrelationId": "4cba7599ba3544b0aef5bbdf35ba1c1c"}