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.
    /
    Class not found - 11.x
    Updated Aug 06

    Class not found - 11.x

    Symptoms

    One or more SQL Macro returns the following error:

    java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSourceFactory

    Cause

    This error can occur if your data source configuration is out of date after upgrading Confluence or your application server. 

    Resolution

    1. Look for something similar to factory="org.apache.commons.dbcp.BasicDataSourceFactory" in your server.xml.

    2. Either, remove the entry, or, replace with factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory". 



    Need support? Create a request with our support team.

    Copyright © 2005 - 2025 Appfire | All rights reserved.

    {"serverDuration": 14, "requestCorrelationId": "99377f20c61843b1b223efaf637e895c"}