Upgrade Failed Due to "java.sql.SQLException: Conversion to String failed"
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. 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
Symptoms
Upgrade fails due to "java.sql.SQLException: Conversion to String failed" when using Oracle.
The following appears in the atlassian-confluence.log:
ERROR [lifecycle:thread-1] [sal.core.upgrade.PluginUpgrader] doUpgrade Upgrade failed: There was a SQL exception thrown by the Active Objects library:
Database:
- name:Oracle
- version:Oracle Database 11g Release 11.1.0.0.0 - Production
- minor version:1
- major version:11
Driver:
- name:Oracle JDBC driver
- version:10.2.0.3.0
java.sql.SQLException: Conversion to String failedCause
The Oracle JDBC Driver used on your instance is not the one supported by Confluence.
Resolution
- Download the supported JDBC driver according to our documentation.