com.atlassian.confluence.upgrade.upgradetask
Class RenamePositionColumnUpgradeTask

java.lang.Object
  com.atlassian.confluence.upgrade.upgradetask.RenamePositionColumnUpgradeTask

All Implemented Interfaces:

UpgradeTask

public class RenamePositionColumnUpgradeTask
extends Object
implements UpgradeTask

POSITION is a key word as far as HSQLDB 1.8 is concerned. Hence we need to rename it. however not many databases support a SQL rename command, so our first attempt involved trying to drop the column and add a new one it turns out that we cannot remove the POSITION column because it is part of composite primary key (and with values in the table, dropping the column will cause duplicate entries in the remaining PK column) further, hibernate's schemaUpdate autocreates the ANCESTORPOSITION column as part of the upgrade but fails to create it as a primary key -- not sure know why. instead of fighting with database dialects and integrity errors, we concluded its best and easier to just rename the table and allow schemaUpdate to create a new one this upgrade task handles the removal of the old table and the triggers off a populating of the new.

Constructor Summary

RenamePositionColumnUpgradeTask(PageAncestorManager pageAncestorManager)

Method Summary

void	doUpgrade()
String	getBuildNumber()
Collection<UpgradeError>	getErrors()
String	getShortDescription()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

RenamePositionColumnUpgradeTask

public RenamePositionColumnUpgradeTask(PageAncestorManager pageAncestorManager)

Method Detail

getBuildNumber

public String getBuildNumber()

Specified by:

getBuildNumber in interface UpgradeTask

getShortDescription

public String getShortDescription()

Specified by:

getShortDescription in interface UpgradeTask

doUpgrade

public void doUpgrade()
               throws Exception

Specified by:

doUpgrade in interface UpgradeTask

Throws:

Exception

getErrors

public Collection<UpgradeError> getErrors()

Specified by:

getErrors in interface UpgradeTask