"The component of the database name of the object qualifier must be the name of the current database" error on upgrade to Confluence 6.1+

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Problem

Confluence throws the following database error while trying to upgrade to 6.1.0 or later when using Microsoft SQL Server database:

Caused by: java.sql.SQLException: The database name component of the object qualifier must be the name of the current database.

Diagnosis

Environment

  • Microsoft SQL Server

Cause

  1. The database name set in <home-directory>/confluence.cfg.xml does not match the name of the Microsoft SQL database. The database name is case-sensitive.
  2. If upgrading to the latest version (6.15.x), you may be hitting the following bug: CONFSERVER-58264 - Getting issue details... STATUS
  3. if upgrading to a version before 6.2.2, you may be hitting the following bug: CONFSERVER-52103 - Getting issue details... STATUS

Resolution for Confluence 6.6.x or later

  1. Stop Confluence

  2. Back up your home directory and installation directory before making any changes.

  3. Get the name of your database by running this SQL query:

    SELECT name, database_id, create_date  
    FROM sys.databases;  


    1. If you configured the database with a JDBC URL when you set up Confluence, compare the database name from step 3, with the database name configured in the hibernate.connection.url property in your <home-directory>/confluence.cfg.xml file. 

      <property name="hibernate.connection.url">jdbc:sqlserver://<hostname>:<port>;databaseName=<database></property>
    2. If you configured the database with a JNDI datasource when you set up Confluence (assuming you followed this documentation page for JNDI datasource configuration), compare the database name from step 3, with the database name in the url attribute, located in the JNDI Datasource configuration in your <installation-directory>/conf/server.xml file.

      <Resource name="jdbc/confluence" auth="Container" type="javax.sql.DataSource"
               username="yourDatabaseUser"
               password="yourDatabasePassword"
               driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
               url="jdbc:sqlserver://<hostname>:<port>;databaseName=<database>"
               maxTotal="60"
               maxIdle="20"
               validationQuery="select 1" />
  4. Update the database name so that it matches the name of the database from the SQL query in step 3 (note it is case sensitive)
  5. Start Confluence

Resolution for Confluence 6.5.x or earlier

The steps are the same with the exception being the connection URL and JTDS driver

  1. Stop Confluence

  2. Back up your home directory and installation directory before making any changes.

  3. Get the name of your database by running this SQL query:

    SELECT name, database_id, create_date  
    FROM sys.databases;  


    1. If you configured the database with a JDBC URL when you set up Confluence, compare the database name from step 3, with the database name configured in the hibernate.connection.url property in your <home-directory>/confluence.cfg.xml file. 

      <property name="hibernate.connection.url">jdbc:jtds:sqlserver://{host}:{port}/{database_name}</property>
    2. If you configured the database with a JNDI datasource when you set up Confluence (assuming you followed this documentation page for JNDI datasource configuration), compare the database name from step 3, with the database name in the url attribute, located in the JNDI Datasource configuration in your <installation-directory>/conf/server.xml file.

      <Resource name="jdbc/confluence" auth="Container" type="javax.sql.DataSource"
               username="yourDatabaseUser"
               password="yourDatabasePassword"
               driverClassName="net.sourceforge.jtds.jdbc.Driver"
               url="jdbc:jtds:sqlserver://{host}:{port}/{database_name}"
               maxTotal="60"
               maxIdle="20"
               validationQuery="select 1" />
  4. Update the database name so that it matches the name of the database from the SQL query in step 3 (note it is case sensitive)
  5. Start Confluence



Last modified on Aug 27, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.