org.opencms.setup.update6to7.oracle
Class CmsUpdateDBProjectId

java.lang.Object
  extended by org.opencms.setup.update6to7.A_CmsUpdateDBPart
      extended by org.opencms.setup.update6to7.generic.CmsUpdateDBProjectId
          extended by org.opencms.setup.update6to7.oracle.CmsUpdateDBProjectId
All Implemented Interfaces:
I_CmsUpdateDBPart

public class CmsUpdateDBProjectId
extends CmsUpdateDBProjectId

Oracle implementation to update the project ids to uuids.

Author:
Roland Metzler

Field Summary
 
Fields inherited from class org.opencms.setup.update6to7.generic.CmsUpdateDBProjectId
COLUMN_PROJECT_ID, COLUMN_PROJECT_ID_RESOURCE_PATH, COLUMN_PROJECT_LASTMODIFIED, COLUMN_PROJECT_UUID, COLUMN_TEMP_PROJECT_UUID, HISTORY_PROJECTS_TABLE, REPLACEMENT_COLUMN, REPLACEMENT_NEW_COLUMN, REPLACEMENT_OLDID, REPLACEMENT_PRIMARY_KEY, REPLACEMENT_TABLENAME, RESOURCE_TABLES, RESOURCES_TABLES_LIST, TABLES, TABLES_LIST, TEMP_UUID_COLUMN, TEMPORARY_TABLE_NAME
 
Fields inherited from class org.opencms.setup.update6to7.A_CmsUpdateDBPart
m_poolData, m_queries, QUERY_PROPERTIES_PREFIX
 
Constructor Summary
CmsUpdateDBProjectId()
          Constructor.
 
Method Summary
protected  void internalExecute(CmsSetupDb dbCon)
          Does the hard work.
protected  void transferDataToHistoryTable(CmsSetupDb dbCon)
          Transfers the data from the CMS_BACKUP_PROJECTS to the CMS_HISTORY_PROJECTS table.
 
Methods inherited from class org.opencms.setup.update6to7.generic.CmsUpdateDBProjectId
createHistProjectsTable, createTempTable
 
Methods inherited from class org.opencms.setup.update6to7.A_CmsUpdateDBPart
execute, getDbInstance, getPoolData, isKeepHistory, loadQueryProperties, readQuery, setPoolData
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

CmsUpdateDBProjectId

public CmsUpdateDBProjectId()
                     throws java.io.IOException
Constructor.

Throws:
java.io.IOException - if the sql queries properties file could not be read
Method Detail

internalExecute

protected void internalExecute(CmsSetupDb dbCon)
                        throws java.sql.SQLException
Description copied from class: A_CmsUpdateDBPart
Does the hard work.

Overrides:
internalExecute in class CmsUpdateDBProjectId
Parameters:
dbCon - the db connection interface
Throws:
java.sql.SQLException - if somethign goes wrong
See Also:
CmsUpdateDBProjectId.internalExecute(org.opencms.setup.CmsSetupDb)

transferDataToHistoryTable

protected void transferDataToHistoryTable(CmsSetupDb dbCon)
                                   throws java.sql.SQLException
Transfers the data from the CMS_BACKUP_PROJECTS to the CMS_HISTORY_PROJECTS table.

The datetime type for the column PROJECT_PUBLISHDATE is converted to the new long value.

Overrides:
transferDataToHistoryTable in class CmsUpdateDBProjectId
Parameters:
dbCon - the db connection interface
Throws:
java.sql.SQLException - if something goes wrong