Data Migrating from Jetspeed 2.1.2 to 2.1.3

The following tables describe database schema changes from version 2.1.3 to version 2.1.2.

Added Indexes

TableIndextypecolumn(s)
PREFS_NODEIX_PREFS_NODE_1non uniquePARENT_NODE_ID
PREFS_NODEIX_PREFS_NODE_2non uniqueFULL_PATH
PREFS_PROPERTY_VALUEIX_FKPPV_1non uniqueNODE_ID

Foreign Key Altering

TableNameColumn(s)Referencing tableReferencing column(s)2.1.22.1.3
PREFS_NODEFK_PREFS_NODE_1PARENT_NODE_IDPREFS_NODENODE_ID(not casade delete)CASCADE DELETE
PREFS_PROPERTY_VALUE(not named)NODE_IDPREFS_NODENODE_ID(not casade delete)CASCADE DELETE

Data Migrating from Jetspeed 2.1 to 2.1.2

The following tables describe database schema changes from version 2.1 to version 2.1.2.

Added Tables

Table
ADMIN_ACTIVITY
USER_ACTIVITY

Configuration Migrating from Jetspeed 2.0 to 2.1

The following items describe important functional changes in Jetspeed 2.1

Portlet API Caching

Version 2.1 is the first Jetspeed version to support Portlet API Caching. In 2.0 the expiration-cache was set to -1 (infinity time) for all layouts in the file WEB-INF\apps\jetspeed-layouts\WEB-INF\portlet.xml. When upgrading to version 2.1 or greater from 2.0, you will need to update your database to disable portlet caching on the Jetspeed layouts. Updating the layouts can be achieved by either redeploying the jetspeed-layouts portlet application, or by updating your database as shown below (assuming the APPLICATION_ID value is 2) for the jetspeed-layouts application.

UPDATE PORTLET_DEFINITION P SET EXPIRATION_CACHE = 0 WHERE P.APPLICATION_ID = 2

Portlet Preferences

Portlet Preferences are now by default user specific on all pages. In Jetspeed 2.0, for shared pages, the Portlet Preferences were shared as well.

To retain most of the old Jetspeed 2.0 behavior, allowing an administrator to still set/modify initial Preferences for other users,

modify the following setting in the registry.xml spring assembly configuration for the portletEntityAccessImpl component:

<!-- 
  All preferences were shared. With JS2-449, preferences are now
  stored 'per user'. The username is stored in the preferences FULL_PATH
  To turn on mergeSharedPreferences configure this property to true 
  This will NOT turn off per user prefs, 
  but instead merge with them, where user prefs override.
  boolean
-->    
<constructor-arg type="boolean">
<value>false</value>
</constructor-arg>        
	   
As is commented in the assembly configuration also, setting mergeSharedPreferences to true will NOT turn off per user Preferences.

Once a user sets its own Preference values (if allowed), those will override the shared Preference values.

See for further information: JS2-449

Data Migrating from Jetspeed 2.0 to 2.1

The following tables describe database schema changes from version 2.0 to version 2.1.

Added Tables

Table
CUSTOM_PORTLET_MODE
CUSTOM_WINDOW_STATE

Column Altering

TableColumn2.02.1
PORTLET_STATISTICSELAPSED_TIMEINTEGERBIGINT
PAGE_STATISTICSELAPSED_TIMEINTEGERBIGINT
USER_STATISTICSELAPSED_TIMEINTEGERBIGINT
FOLDERSKINNEW: VARCHAR(80)
FOLDERDEFAULT_LAYOUT_DECORATORNEW: VARCHAR(80)
FOLDERDEFAULT_PORTLET_DECORATORNEW: VARCHAR(80)
FRAGMENTSTATEVARCHAR(40)VARCHAR(10)
FRAGMENTPMODENEW: VARCHAR(10)
FRAGMENTLAYOUT_XNEW: REAL
FRAGMENTLAYOUT_YNEW: REAL
FRAGMENTLAYOUT_ZNEW: REAL
FRAGMENTLAYOUT_WIDTHNEW: REAL
FRAGMENTLAYOUT_HEIGHTNEW: REAL
LINKSKINNEW: VARCHAR(80)
PORTLET_DEFINITIONSECURITY_REFNEW: VARCHAR(40)
PORTLET_DEFINITIONSECURITY_REFNEW: VARCHAR(40)
PORTLET_APPLICATIONSECURITY_REFNEW: VARCHAR(40)
SSO_COOKIECOOKIEVARCHAR(250)VARCHAR(1024)

Index Altering

TableIndex2.02.1
FOLDER_MENUUN_FOLDER_MENU_1unique(non unique) index
PAGE_MENUUN_PAGE_MENU_1unique(non unique) index
FRAGMENTUN_FRAGMENT_1unique(non unique) index

Foreign Key Altering

TableColumn2.02.1
FOLDER(FK constraint)(not named)named FK constraint "FK_FOLDER_1"
FOLDER_METADATA(FK constraint)(not named)named FK constraint "FK_FOLDER_METADATA_1"
FOLDER_CONSTRAINT(FK constraint)(not named)named FK constraint "FK_FOLDER_CONSTRAINT_1"
FOLDER_CONSTRAINTS_REF(FK constraint)(not named)named FK constraint "FK_FOLDER_CONSTRAINT_REF_1"
FOLDER_ORDER(FK constraint)(not named)named FK constraint "FK_FOLDER_ORDER_1"
FOLDER_MENU(FK constraint)(not named)named FK constraint "FK_FOLDER_MENU_1"
FOLDER_MENU(FK constraint)(not named)named FK constraint "FK_FOLDER_MENU_2"
FOLDER_MENU_METADATA(FK constraint)(not named)named FK constraint "FK_FOLDER_MENU_METADATA_1"
PAGE(FK constraint)(not named)named FK constraint "FK_PAGE_1"
PAGE_METADATA(FK constraint)(not named)named FK constraint "FK_PAGE_METADATA_1"
PAGE_CONSTRAINT(FK constraint)(not named)named FK constraint "FK_PAGE_CONSTRAINT_1"
PAGE_CONSTRAINT_REF(FK constraint)(not named)named FK constraint "FK_PAGE_CONSTRAINTS_REF_1"
PAGE_MENU(FK constraint)(not named)named FK constraint "FK_PAGE_MENU_1"
PAGE_MENU(FK constraint)(not named)named FK constraint "PM_M_FK_PAGE_ID_PAGE"
PAGE_MENU_METADATA(FK constraint)(not named)named FK constraint "FK_PAGE_MENU_METADATA_1"
FRAGMENT(FK constraint)(not named)named FK constraint "FK_FRAGMENT_1"
FRAGMENT(FK constraint)(not named)named FK constraint "FK_FRAGMENT_2"
FRAGMENT_CONSTRAINT(FK constraint)(not named)named FK constraint "FK_FRAGMENT_CONSTRAINT_1"
FRAGMENT_CONSTRAINT_REF(FK constraint)(not named)named FK constraint "FK_FRAGMENT_CONSTRAINT_REF_1"
FRAGMENT_PREF(FK constraint)(not named)named FK constraint "FK_FRAGMENT_PREF_1"
FRAGMENT_PREF_VALUE(FK constraint)(not named)named FK constraint "FK_FRAGMENT_PREF_VALUE_1"
LINK(FK constraint)(not named)named FK constraint "FK_LINK_1"
LINK_METADATA(FK constraint)(not named)named FK constraint "FK_LINK_METADATA_1"
LINK_CONSTRAINT(FK constraint)(not named)named FK constraint "FK_LINK_CONSTRAINT_1"
LINK_CONSTRAINT_REF(FK constraint)(not named)named FK constraint "FK_LINK_CONSTRAINT_REF_1"
PAGE_SECURITY(FK constraint)(not named)named FK constraint "FK_PAGE_SECURITY_1"
PAGE_SEC_CONSTRAINTS_DEF(FK constraint)(not named)named FK constraint "FK_PAGE_SEC_CONSTRAINTS_DEF_1"
PAGE_SEC_CONSTRAINT_DEF(FK constraint)(not named)named FK constraint "FK_PAGE_SEC_CONSTRAINT_DEF_1"
PAGE_SEC_CONSTRAINTS_REF(FK constraint)(not named)named FK constraint "FK_PAGE_SEC_CONSTRAINTS_REF_1"
PAGE_SEC_CONSTRAINT_REF(FK constraint)(not named)named FK constraint "FK_PAGE_SEC_CONSTRAINT_REF_1"
RULE_CRITERION(FK constraint)(not named)named FK constraint "FK_RULE_CRITERION_1"
PREFS_NODE(FK constraint)(not named)named FK constraint "FK_PREFS_NODE_1"
PA_METADATA_FIELDS(FK constraint)(not named)named FK constraint "FK_PA_METADATA_FIELDS_1"
PD_METADATA_FIELDS(FK constraint)(not named)named FK constraint "FK_PD_METADATA_FIELDS_1"
USER_ATTRIBUTE_REF(FK constraint)(not named)named FK constraint "FK_USER_ATTRIBUTE_REF_1"
USER_ATTRIBUTE(FK constraint)(not named)named FK constraint "FK_USER_ATTRIBUTE_1"
PRINCIPAL_PERMISSION(FK constraint)(not named)named FK constraint "FK_PRINCIPAL_PERMISSION_1"
PRINCIPAL_PERMISSION(FK constraint)(not named)named FK constraint "FK_PRINCIPAL_PERMISSION_2"
SECURITY_CREDENTIAL(FK constraint)(not named)named FK constraint "FK_SECURITY_CREDENTIAL_1"
SSO_SITE_TO_PRINCIPALS(FK constraint)(not named)named FK constraint "SSO_SITE_TO_PRINC_FK1"
SSO_SITE_TO_PRINCIPALS(FK constraint)(not named)named FK constraint "SSO_SITE_TO_PRINC_FK2"
SSO_PRINCIPAL_TO_REMOTE(FK constraint)(not named)named FK constraint "FK_SSO_PRINCIPAL_TO_REMOTE_1"
SSO_PRINCIPAL_TO_REMOTE(FK constraint)(not named)named FK constraint "FK_SSO_PRINCIPAL_TO_REMOTE_2"
SSO_SITE_TO_REMOTE(FK constraint)(not named)named FK constraint "FK_SSO_SITE_TO_REMOTE_1"
SSO_SITE_TO_REMOTE(FK constraint)(not named)named FK constraint "FK_SSO_SITE_TO_REMOTE_2"
SSO_COOKIE_TO_REMOTE(FK constraint)(not named)named FK constraint "FK_SSO_COOKIE_TO_REMOTE_1"
SSO_COOKIE_TO_REMOTE(FK constraint)(not named)named FK constraint "FK_SSO_COOKIE_TO_REMOTE_2"
SECURITY_USER_ROLE(FK constraint)(not named)named FK constraint "FK_SECURITY_USER_ROLE_1"
SECURITY_USER_ROLE(FK constraint)(not named)named FK constraint "FK_SECURITY_USER_ROLE_2"
SECURITY_USER_GROUP(FK constraint)(not named)named FK constraint "FK_SECURITY_USER_GROUP_1"
SECURITY_USER_GROUP(FK constraint)(not named)named FK constraint "FK_SECURITY_USER_GROUP_2"
SECURITY_GROUP_ROLE(FK constraint)(not named)named FK constraint "FK_SECURITY_GROUP_ROLE_1"
SECURITY_GROUP_ROLE(FK constraint)(not named)named FK constraint "FK_SECURITY_GROUP_ROLE_2"