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 Oracle exception - 11.x
    Updated Aug 11

    Validation query throwing Oracle exception - 11.x

    Symptoms

    One or more SQL Macro returns the following error:

    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected

    Cause

    Oracle requires a FROM clause in the validation query. For most other databases, it is sufficient to use SELECT 1. 

    Resolution

    Add a valid FROM clause for Oracle queries. 

    Need support? Create a request with our support team.

    Copyright © 2005 - 2025 Appfire | All rights reserved.

    {"serverDuration": 14, "requestCorrelationId": "3168ad3c299e4649894de0666da2b97c"}