SQL feature not supported exception when starting Confluence 7.14 or later on PostgreSQL
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
The following exception appears in the atlassian-confluence.log
when starting Confluence 7.14 or later with a PostgreSQL database.
WARN [Catalina-utility-1] [zaxxer.hikari.pool.ProxyConnection] checkException HikariPool-1 - Connection org.postgresql.jdbc.PgConnection@907892d marked as broken because of SQLSTATE(0A000), ErrorCode(0)
java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc.PgConnection.createClob() is not yet implemented.
Cause
This error is caused by a known issue with Hibernate. See https://hibernate.atlassian.net/browse/HHH-12368 for more details.
Resolution
You can ignore this error. It will be resolved by a Hibernate upgrade in a future Confluence release.