Purpose

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:

  SELECT * 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 performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

  UPDATE 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.