How to update an Application Link URL manually
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs 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
Summary
There are times where you'll need to update an Application Link in Confluence to use a different Application URL and Display URL without re-creating that link.
Generally speaking, you should not need to re-create the application links unless a specific problem prevents you from using the application links interface.
Solution
Shut down Confluence if it's running
Perform a full database backup
Run the following query to identify your application link:
1SELECT * FROM BANDANA WHERE BANDANAKEY LIKE 'applinks%url';For each application link you'll have two records - one for the application link URL and one for the display URL - for example:
<string>http://localhost:8080/jira</string>You will need to update the URL to your new address, using the ID you gathered in Step Three (3):
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
1UPDATE BANDANA SET BANDANAVALUE = '<string>newURL</string>' WHERE BANDANAID = xxxℹ️ Replace newURL with the new Application Link URL, and replace xxx with the ID of the rows you wish to update from Step Three (3)
Restart Confluence, and verify that your application link is correctly pointing to the new instance.
Was this helpful?