Database Encoding Configuration

Check out our Configuring Database Character Encoding page.

HSQL Articles

MS SQL Server Articles

• Page:
  Unable to install plugins using MS SQL due to transaction log exceptions
• Page:
  Getting 'ResultSet can not re-read row data' SQLException Error Due to jTDS 1.0.2
• Page:
  Users cannot log in due to length of active column
• Page:
  Migrating attachments from database to file system fails with transaction log full exception
• Page:
  'Foreign key has implicit reference to object which does not have a primary key defined on it' error is thrown during Confluence upgrade
• Page:
  Login Fails When Using JIRA for User Management Due To SQL Server Configuration
• Page:
  How to upgrade active objects columns from varchar to nvarchar in SQL Server
• Page:
  Cannot Restore XML Backup Due to Invalid Page Title when Using MS SQL
• Page:
  Database Deadlock on Microsoft SQL Server in Confluence
• Page:
  Unable to Add Comment due to SQL Server Error (AONOTIFICATION table)
• Page:
  Getting 'generate could not read a hi value java.sql.SQLException Invalid object name 'hibernate_unique_key' SQLException Error
• Page:
  Repairing a Damaged Microsoft SQL Server Database
• Page:
  Confluence throws an 'Invalid object name BANDANA' error
• Page:
  Can't start or upgrade Confluence due to an error with MS SQL Server database collation
• Page:
  Confluence Database Setup Fails for MS SQL Server with Connection Refused

MySQL Articles

• Page:
  Saving Page Throws Unable to Communicate with Server message
• Page:
  Getting 'can't create or write to file' SQLException Error When Browsing a Space
• Page:
  Getting 'Duplicate entry' when Using MySQL on OS X
• Page:
  Getting 'Invalid use of group function' SQLException Error on MySQL 4.x
• Page:
  Unable to create a decision with the Decision Blueprint
• Page:
  Database connection issues due to "Queries leading to data modification are not allowed"
• Page:
  'Got error 134 from storage engine' Error Due to MySQL Table Corruption
• Page:
  Getting a 'Duplicate key or integrity constraint violation' During XML Import
• Page:
  Unable to Create a New Space
• Page:
  Confluence will not start using MySQL 5.1.5+ with STATEMENT binary logging
• Page:
  Cannot Restore from XML Backup when Confluence is Backed by MySQL
• Page:
  Login After a Long Inactivity on Confluence Fails with 'com.mysql.jdbc.CommunicationsException Communications link failure' CommunicationsException Error
• Page:
  Getting 'Communications link failure' CommunicationsException Error when Making XML Backup
• Page:
  Characters appear as question marks using MySQL
• Page:
  Exceeds max allowed packet for MySQL

Postgres Articles

• Page:
  Site Import Fails on Weblogic when Using PostgreSQL
• Page:
  Unable to Update Plugin Due to 'FATAL no pg_hba.conf entry' in PostgreSQL
• Page:
  Confluence is displaying pages slowly or showing 503 errors with PostgreSQL
• Page:
  Confluence unable to connect to PostgreSQL due to unconfigured pg_hba.conf file
• Page:
  Getting ZipException Error when Installing a New Plugin Due to Postgres 9 Configuration
• Page:
  Unable to Setup Postgres Due to Incorrect Driver
• Page:
  Getting a PSQLException Error 'An IO error occured while sending to the backend' Due to Corrupt Postgres Database
• Page:
  Database Troubleshooting for PostgreSQL

Oracle Articles

• Page:
  Seeing Inverted Question Marks with Oracle
• Page:
  Upgrade failed with net.sf.hibernate.HibernateException: JDBC Driver class not found: oracle.jdbc.OracleDriver
• Page:
  Confluence is unable to start because Oracle database user account is locked
• Page:
  Confluence Operations Fail Due to ORA-01536 or ORA-01653
• Page:
  Clicking on Notifications Generates a System Error
• Page:
  Confluence Fails to Start due to Stopped Oracle's Database Listener
• Page:
  Confluence Upgrade Fails with ORA-02298 Parent Keys Not Found
• Page:
  Unable to Save Page Edits Using Oracle DB (ORA-01691: unable to extend lob segment)
• Page:
  Confluence Startup Failed or Scheduled Job Failed Due to ORA-28001
• Page:
  Oracle 8i 24-hour time format
• Page:
  Confluence upgrade fails with ORA-01408 error
• Page:
  Unable to Configure Oracle Data Source in Websphere
• Page:
  Unable to Install Oracle on Websphere Due to Classloader Preferences
• Page:
  Pre-existing Oracle indexes halt upgrade to Confluence with error ORA-01408
• Page:
  Handling java.sql.SQLRecoverableException: Closed Connection errors

Known Issues for Supported Databases

Database Troubleshooting for PostgreSQL
Database Troubleshooting for Oracle
Database Troubleshooting for MySQL
Database Troubleshooting for SQL Server
Database Troubleshooting for DB2

For a list of supported databases versions, please refer to our Supported Platforms page.

Open JIRA Features and Bug Reports