Modified: portals/site-live/jetspeed-2/guide-migration.html URL: http://svn.apache.org/viewvc/portals/site-live/jetspeed-2/guide-migration.html?rev=1901428&r1=1901427&r2=1901428&view=diff ============================================================================== --- portals/site-live/jetspeed-2/guide-migration.html (original) +++ portals/site-live/jetspeed-2/guide-migration.html Tue May 31 02:15:08 2022 @@ -42,7 +42,7 @@ <div class="xleft"> - Last Published: 9 May 2016 + Last Published: 26 May 2022 </div> <div class="xright"> <a href="http://portals.apache.org/applications/"; class="externalLink">Applications</a> | @@ -253,117 +253,117 @@ </div> <div id="bodyColumn"> <div id="contentBox"> - <subtitle></subtitle><authors><person name="David Sean Taylor" email="[email protected]"><person name="Ate Douma" email="[email protected]"><person name="Randy Watler" email="[email protected]"></authors><div class="section"><h2><a name="Data_Migration_from_Jetspeed_2.2.2_to_2.3.1"></a>Data Migration from Jetspeed 2.2.2 to 2.3.1</h2> + <subtitle></subtitle><authors><person name="David Sean Taylor" email="[email protected]"><person name="Ate Douma" email="[email protected]"><person name="Randy Watler" email="[email protected]"></authors><div class="section"><h2><a name="Data_Migration_from_Jetspeed_2.2.2_to_2.3.1"></a>Data Migration from Jetspeed 2.2.2 to 2.3.1</h2> <p> No data migration is necessary from version 2.2.2 to 2.3.1. - </p> -</div> -<div class="section"><h2><a name="Data_Migration_from_Jetspeed_2.2.1_to_2.2.2"></a>Data Migration from Jetspeed 2.2.1 to 2.2.2</h2> -<p>The following tables describe database schema changes from version 2.2.1 to version 2.2.2.</p> + </p> +</div> +<div class="section"><h2><a name="Data_Migration_from_Jetspeed_2.2.1_to_2.2.2"></a>Data Migration from Jetspeed 2.2.1 to 2.2.2</h2> +<p>The following tables describe database schema changes from version 2.2.1 to version 2.2.2.</p> <p>Note: besides the below modifications, there are a few renames of index and foreign key names - for naming consistency reasons only, which can be ignored and are not mentioned in the below tables either.</p> -<div class="section"><h3><a name="Dropped_Foreign_Keys_and_their_Indexes"></a>Dropped Foreign Keys (and their Indexes)</h3> -<table class="bodyTable"><tr class="a"><th>Table</th> -<th>Foreign Key</th> -</tr> -<tr class="b"><td>CUSTOM_PORTLET_MODE</td> -<td>FK_CUSTOM_PORTLET_MODE_1</td> -</tr> -<tr class="a"><td>CUSTOM_WINDOW_STATE</td> -<td>FK_CUSTOM_WINDOW_STATE_1</td> -</tr> -<tr class="b"><td>EVENT_DEFINITION</td> -<td>FK_EVENT_DEFINITION_1</td> -</tr> -<tr class="a"><td>PA_METADATA_FIELDS</td> -<td>FK_PA_METADATA_FIELDS_1</td> -</tr> -<tr class="b"><td>PD_METADATA_FIELDS</td> -<td>FK_PD_METADATA_FIELDS_1</td> -</tr> -<tr class="a"><td>SECURITY_ROLE</td> -<td>FK_SECURITY_ROLE_REF_1</td> -</tr> -<tr class="b"><td>USER_ATTRIBUTE</td> -<td>FK_USER_ATTRIBUTE_1</td> -</tr> -<tr class="a"><td>USER_ATTRIBUTE_REF</td> -<td>FK_USER_ATTRIBUTE_REF_1</td> -</tr> -</table> -</div> -<div class="section"><h3><a name="Dropped_Indexes"></a>Dropped Indexes</h3> -<table class="bodyTable"><tr class="b"><th>Table</th> -<th>Index</th> -</tr> -<tr class="a"><td>PROFILE_PAGE_ASSOC</td> -<td>UN_PROFILE_PAGE_1</td> -</tr> -</table> -</div> -<div class="section"><h3><a name="Added_Columns"></a>Added Columns</h3> -<table class="bodyTable"><tr class="b"><th>Table</th> -<th>Column</th> -<th>Type</th> -<th>Required</th> -</tr> -<tr class="a"><td>PORTLET_DEFINITION</td> -<td>CLONE_PARENT</td> -<td>VARCHAR(80)</td> -<td>false</td> -</tr> -</table> -</div> -<div class="section"><h3><a name="Added_Indexes"></a>Added Indexes</h3> -<table class="bodyTable"><tr class="b"><th>Table</th> -<th>Index</th> -<th>Unique</th> -<th>Column(s)</th> -</tr> -<tr class="a"><td>FOLDER_MENU</td> -<td>IX_FOLDER_MENU_2</td> -<td>non unique</td> -<td>FOLDER_ID</td> -</tr> -<tr class="b"><td>PAGE_MENU</td> -<td>IX_PAGE_MENU_2</td> -<td>non unique</td> -<td>PAGE_ID</td> -</tr> -<tr class="a"><td>PRINCIPAL_PERMISSION</td> -<td>IX_PRINCIPAL_PERMISSION_2</td> -<td>non unique</td> -<td>PRINICIPAL_ID</td> -</tr> -<tr class="b"><td>RULE_CRITERION</td> -<td>IX_RULE_CRITERION_0</td> -<td>non unique</td> -<td>RULE_ID</td> -</tr> -</table> -</div> -<div class="section"><h3><a name="Added_Primary_Keys"></a>Added Primary Keys</h3> -<table class="bodyTable"><tr class="a"><th>Table</th> -<th>Column(s)</th> -</tr> -<tr class="b"><td>CLIENT_TO_CAPABILITY</td> -<td>CLIENT_ID, CAPABILITY_ID</td> -</tr> -<tr class="a"><td>CLIENT_TO_MIMETYPE</td> -<td>CLIENT_ID, MIMETYPE_ID</td> -</tr> -<tr class="b"><td>MEDIATYPE_TO_CAPABILITY</td> -<td>MEDIATYPE_ID, CAPABILITY_ID</td> -</tr> -<tr class="a"><td>MEDIATYPE_TO_MIMETYPE</td> -<td>MEDIATYPE_ID, MIMETYPE_ID</td> -</tr> -<tr class="b"><td>PROFILE_PAGE_ASSOC</td> -<td>LOCATOR_HASH, PAGE_ID</td> -</tr> -</table> -</div> -<div class="section"><h3><a name="Example_SQL_migration_script_from_2.2.1_to_2.2.2"></a>Example SQL migration script from 2.2.1 to 2.2.2</h3> + for naming consistency reasons only, which can be ignored and are not mentioned in the below tables either.</p> +<div class="section"><h3><a name="Dropped_Foreign_Keys_and_their_Indexes"></a>Dropped Foreign Keys (and their Indexes)</h3> +<table class="bodyTable"><tr class="a"><th>Table</th> +<th>Foreign Key</th> +</tr> +<tr class="b"><td>CUSTOM_PORTLET_MODE</td> +<td>FK_CUSTOM_PORTLET_MODE_1</td> +</tr> +<tr class="a"><td>CUSTOM_WINDOW_STATE</td> +<td>FK_CUSTOM_WINDOW_STATE_1</td> +</tr> +<tr class="b"><td>EVENT_DEFINITION</td> +<td>FK_EVENT_DEFINITION_1</td> +</tr> +<tr class="a"><td>PA_METADATA_FIELDS</td> +<td>FK_PA_METADATA_FIELDS_1</td> +</tr> +<tr class="b"><td>PD_METADATA_FIELDS</td> +<td>FK_PD_METADATA_FIELDS_1</td> +</tr> +<tr class="a"><td>SECURITY_ROLE</td> +<td>FK_SECURITY_ROLE_REF_1</td> +</tr> +<tr class="b"><td>USER_ATTRIBUTE</td> +<td>FK_USER_ATTRIBUTE_1</td> +</tr> +<tr class="a"><td>USER_ATTRIBUTE_REF</td> +<td>FK_USER_ATTRIBUTE_REF_1</td> +</tr> +</table> +</div> +<div class="section"><h3><a name="Dropped_Indexes"></a>Dropped Indexes</h3> +<table class="bodyTable"><tr class="b"><th>Table</th> +<th>Index</th> +</tr> +<tr class="a"><td>PROFILE_PAGE_ASSOC</td> +<td>UN_PROFILE_PAGE_1</td> +</tr> +</table> +</div> +<div class="section"><h3><a name="Added_Columns"></a>Added Columns</h3> +<table class="bodyTable"><tr class="b"><th>Table</th> +<th>Column</th> +<th>Type</th> +<th>Required</th> +</tr> +<tr class="a"><td>PORTLET_DEFINITION</td> +<td>CLONE_PARENT</td> +<td>VARCHAR(80)</td> +<td>false</td> +</tr> +</table> +</div> +<div class="section"><h3><a name="Added_Indexes"></a>Added Indexes</h3> +<table class="bodyTable"><tr class="b"><th>Table</th> +<th>Index</th> +<th>Unique</th> +<th>Column(s)</th> +</tr> +<tr class="a"><td>FOLDER_MENU</td> +<td>IX_FOLDER_MENU_2</td> +<td>non unique</td> +<td>FOLDER_ID</td> +</tr> +<tr class="b"><td>PAGE_MENU</td> +<td>IX_PAGE_MENU_2</td> +<td>non unique</td> +<td>PAGE_ID</td> +</tr> +<tr class="a"><td>PRINCIPAL_PERMISSION</td> +<td>IX_PRINCIPAL_PERMISSION_2</td> +<td>non unique</td> +<td>PRINICIPAL_ID</td> +</tr> +<tr class="b"><td>RULE_CRITERION</td> +<td>IX_RULE_CRITERION_0</td> +<td>non unique</td> +<td>RULE_ID</td> +</tr> +</table> +</div> +<div class="section"><h3><a name="Added_Primary_Keys"></a>Added Primary Keys</h3> +<table class="bodyTable"><tr class="a"><th>Table</th> +<th>Column(s)</th> +</tr> +<tr class="b"><td>CLIENT_TO_CAPABILITY</td> +<td>CLIENT_ID, CAPABILITY_ID</td> +</tr> +<tr class="a"><td>CLIENT_TO_MIMETYPE</td> +<td>CLIENT_ID, MIMETYPE_ID</td> +</tr> +<tr class="b"><td>MEDIATYPE_TO_CAPABILITY</td> +<td>MEDIATYPE_ID, CAPABILITY_ID</td> +</tr> +<tr class="a"><td>MEDIATYPE_TO_MIMETYPE</td> +<td>MEDIATYPE_ID, MIMETYPE_ID</td> +</tr> +<tr class="b"><td>PROFILE_PAGE_ASSOC</td> +<td>LOCATOR_HASH, PAGE_ID</td> +</tr> +</table> +</div> +<div class="section"><h3><a name="Example_SQL_migration_script_from_2.2.1_to_2.2.2"></a>Example SQL migration script from 2.2.1 to 2.2.2</h3> <p> Here is an example of a SQL migration script for a MySQL database: <div class="source"><pre> @@ -399,273 +399,273 @@ ALTER TABLE CLIENT_TO_MIMETYPE ADD PRIMA ALTER TABLE MEDIATYPE_TO_CAPABILITY ADD PRIMARY KEY (MEDIATYPE_ID, CAPABILITY_ID); ALTER TABLE MEDIATYPE_TO_MIMETYPE ADD PRIMARY KEY (MEDIATYPE_ID, MIMETYPE_ID); ALTER TABLE PROFILE_PAGE_ASSOC ADD PRIMARY KEY (LOCATOR_HASH, PAGE_ID ); - </pre> -</div> -</p> -</div> -</div> -<div class="section"><h2><a name="Data_Migrating_from_Jetspeed_2.1.32.1.4_to_2.2.1"></a>Data Migrating from Jetspeed 2.1.3/2.1.4 to 2.2.1</h2> + </pre> +</div> +</p> +</div> +</div> +<div class="section"><h2><a name="Data_Migrating_from_Jetspeed_2.1.32.1.4_to_2.2.1"></a>Data Migrating from Jetspeed 2.1.3/2.1.4 to 2.2.1</h2> <p> Extensive schema changes were made between the 2.1 and 2.2 versions related to the Portlet API 2.0 Standard implementation, the Pluto 2.0 integration, and the refactoring of the security and SSO components. Here is a summary of the table modifications that were made: - </p> -<table class="bodyTable"><tr class="a"><th>Registry and Preferences Table Name</th> -<th>Modification</th> -</tr> -<tr class="b"><td>CUSTOM_PORTLET_MODE</td> -<td>columns changed</td> -</tr> -<tr class="a"><td>CUSTOM_WINDOW_STATE</td> -<td>columns changed</td> -</tr> -<tr class="b"><td>EVENT_ALIAS</td> -<td>new table</td> -</tr> -<tr class="a"><td>EVENT_DEFINITION</td> -<td>new table</td> -</tr> -<tr class="b"><td>FILTERED_PORTLET</td> -<td>new table</td> -</tr> -<tr class="a"><td>FILTER_LIFECYCLE</td> -<td>new table</td> -</tr> -<tr class="b"><td>FILTER_MAPPING</td> -<td>new table</td> -</tr> -<tr class="a"><td>LANGUAGE</td> -<td>columns changed</td> -</tr> -<tr class="b"><td>LOCALE_ENCODING_MAPPING</td> -<td>new table</td> -</tr> -<tr class="a"><td>LOCALIZED_DESCRIPTION</td> -<td>columns changed</td> -</tr> -<tr class="b"><td>LOCALIZED_DISPLAY_NAME</td> -<td>columns changed</td> -</tr> -<tr class="a"><td>NAMED_PARAMETER</td> -<td>new table</td> -</tr> -<tr class="b"><td>PARAMETER</td> -<td>columns changed</td> -</tr> -<tr class="a"><td>PARAMETER_ALIAS</td> -<td>new table</td> -</tr> -<tr class="b"><td>PA_SECURITY_CONSTRAINT</td> -<td>new table</td> -</tr> -<tr class="a"><td>PORTLET_APPLICATION</td> -<td>columns changed</td> -</tr> -<tr class="b"><td>PORTLET_CONTENT_TYPE</td> -<td>deleted</td> -</tr> -<tr class="a"><td>PORTLET_DEFINITION</td> -<td>columns changed</td> -</tr> -<tr class="b"><td>PORTLET_ENTITY</td> -<td>deleted</td> -</tr> -<tr class="a"><td>PORTLET_FILTER</td> -<td>new table</td> -</tr> -<tr class="b"><td>PORTLET_LISTENER</td> -<td>new table</td> -</tr> -<tr class="a"><td>PORTLET_PREFERENCE</td> -<td>new table</td> -</tr> -<tr class="b"><td>PORTLET_PREFERENCE_VALUE</td> -<td>new table</td> -</tr> -<tr class="a"><td>PORTLET_SUPPORTS</td> -<td>new table</td> -</tr> -<tr class="b"><td>PREFS_NODE</td> -<td>deleted</td> -</tr> -<tr class="a"><td>PREFS_PROPERTY_VALUE</td> -<td>deleted</td> -</tr> -<tr class="b"><td>PROCESSING_EVENT</td> -<td>new table</td> -</tr> -<tr class="a"><td>PUBLIC_PARAMETER</td> -<td>new table</td> -</tr> -<tr class="b"><td>PUBLISHING_EVENT</td> -<td>new table</td> -</tr> -<tr class="a"><td>RUNTIME_OPTION</td> -<td>new table</td> -</tr> -<tr class="b"><td>RUNTIME_VALUE</td> -<td>new table</td> -</tr> -<tr class="a"><td>SECURED_PORTLET</td> -<td>new table</td> -</tr> -<tr class="b"><td>SECURITY_ROLE</td> -<td>columns and constraints changed</td> -</tr> -<tr class="a"><td>USER_ATTRIBUTE</td> -<td>columns changed</td> -</tr> -<tr class="b"><td>WEB_APPLICATION</td> -<td>deleted</td> -</tr> -</table> -<p></p> -<table class="bodyTable"><tr class="a"><th>Security and SSO Table Name</th> -<th>Modification</th> -</tr> -<tr class="b"><td>SECURITY_ATTRIBUTE</td> -<td>new table</td> -</tr> -<tr class="a"><td>SECURITY_CREDENTIAL</td> -<td>columns changed</td> -</tr> -<tr class="b"><td>SECURITY_DOMAIN</td> -<td>new table</td> -</tr> -<tr class="a"><td>SECURITY_GROUP_ROLE</td> -<td>deleted</td> -</tr> -<tr class="b"><td>SECURITY_PERMISSION</td> -<td> columns and constraints changed</td> -</tr> -<tr class="a"><td>SECURITY_PRINCIPAL</td> -<td>columns and constraints changed</td> -</tr> -<tr class="b"><td>SECURITY_PRINCIPAL_ASSOC</td> -<td>new table</td> -</tr> -<tr class="a"><td>SECURITY_USER_GROUP</td> -<td>deleted</td> -</tr> -<tr class="b"><td>SECURITY_USER_ROLE</td> -<td>deleted</td> -</tr> -<tr class="a"><td>SSO_COOKIE</td> -<td>deleted</td> -</tr> -<tr class="b"><td>SSO_COOKIE_TO_REMOTE</td> -<td>deleted</td> -</tr> -<tr class="a"><td>SSO_PRINCIPAL_TO_REMOTE</td> -<td>deleted</td> -</tr> -<tr class="b"><td>SSO_SITE</td> -<td>columns and constraints changed</td> -</tr> -<tr class="a"><td>SSO_SITE_TO_PRINCIPALS</td> -<td>deleted</td> -</tr> -<tr class="b"><td>SSO_SITE_TO_REMOTE</td> -<td>deleted</td> -</tr> -</table> -<p></p> -<table class="bodyTable"><tr class="a"><th>Statisitics Table Name</th> -<th>Modification</th> -</tr> -<tr class="b"><td>ADMIN_ACTIVITY</td> -<td>column sizes changed</td> -</tr> -<tr class="a"><td>USER_ACTIVITY</td> -<td>column sizes changed</td> -</tr> -</table> + </p> +<table class="bodyTable"><tr class="a"><th>Registry and Preferences Table Name</th> +<th>Modification</th> +</tr> +<tr class="b"><td>CUSTOM_PORTLET_MODE</td> +<td>columns changed</td> +</tr> +<tr class="a"><td>CUSTOM_WINDOW_STATE</td> +<td>columns changed</td> +</tr> +<tr class="b"><td>EVENT_ALIAS</td> +<td>new table</td> +</tr> +<tr class="a"><td>EVENT_DEFINITION</td> +<td>new table</td> +</tr> +<tr class="b"><td>FILTERED_PORTLET</td> +<td>new table</td> +</tr> +<tr class="a"><td>FILTER_LIFECYCLE</td> +<td>new table</td> +</tr> +<tr class="b"><td>FILTER_MAPPING</td> +<td>new table</td> +</tr> +<tr class="a"><td>LANGUAGE</td> +<td>columns changed</td> +</tr> +<tr class="b"><td>LOCALE_ENCODING_MAPPING</td> +<td>new table</td> +</tr> +<tr class="a"><td>LOCALIZED_DESCRIPTION</td> +<td>columns changed</td> +</tr> +<tr class="b"><td>LOCALIZED_DISPLAY_NAME</td> +<td>columns changed</td> +</tr> +<tr class="a"><td>NAMED_PARAMETER</td> +<td>new table</td> +</tr> +<tr class="b"><td>PARAMETER</td> +<td>columns changed</td> +</tr> +<tr class="a"><td>PARAMETER_ALIAS</td> +<td>new table</td> +</tr> +<tr class="b"><td>PA_SECURITY_CONSTRAINT</td> +<td>new table</td> +</tr> +<tr class="a"><td>PORTLET_APPLICATION</td> +<td>columns changed</td> +</tr> +<tr class="b"><td>PORTLET_CONTENT_TYPE</td> +<td>deleted</td> +</tr> +<tr class="a"><td>PORTLET_DEFINITION</td> +<td>columns changed</td> +</tr> +<tr class="b"><td>PORTLET_ENTITY</td> +<td>deleted</td> +</tr> +<tr class="a"><td>PORTLET_FILTER</td> +<td>new table</td> +</tr> +<tr class="b"><td>PORTLET_LISTENER</td> +<td>new table</td> +</tr> +<tr class="a"><td>PORTLET_PREFERENCE</td> +<td>new table</td> +</tr> +<tr class="b"><td>PORTLET_PREFERENCE_VALUE</td> +<td>new table</td> +</tr> +<tr class="a"><td>PORTLET_SUPPORTS</td> +<td>new table</td> +</tr> +<tr class="b"><td>PREFS_NODE</td> +<td>deleted</td> +</tr> +<tr class="a"><td>PREFS_PROPERTY_VALUE</td> +<td>deleted</td> +</tr> +<tr class="b"><td>PROCESSING_EVENT</td> +<td>new table</td> +</tr> +<tr class="a"><td>PUBLIC_PARAMETER</td> +<td>new table</td> +</tr> +<tr class="b"><td>PUBLISHING_EVENT</td> +<td>new table</td> +</tr> +<tr class="a"><td>RUNTIME_OPTION</td> +<td>new table</td> +</tr> +<tr class="b"><td>RUNTIME_VALUE</td> +<td>new table</td> +</tr> +<tr class="a"><td>SECURED_PORTLET</td> +<td>new table</td> +</tr> +<tr class="b"><td>SECURITY_ROLE</td> +<td>columns and constraints changed</td> +</tr> +<tr class="a"><td>USER_ATTRIBUTE</td> +<td>columns changed</td> +</tr> +<tr class="b"><td>WEB_APPLICATION</td> +<td>deleted</td> +</tr> +</table> +<p></p> +<table class="bodyTable"><tr class="a"><th>Security and SSO Table Name</th> +<th>Modification</th> +</tr> +<tr class="b"><td>SECURITY_ATTRIBUTE</td> +<td>new table</td> +</tr> +<tr class="a"><td>SECURITY_CREDENTIAL</td> +<td>columns changed</td> +</tr> +<tr class="b"><td>SECURITY_DOMAIN</td> +<td>new table</td> +</tr> +<tr class="a"><td>SECURITY_GROUP_ROLE</td> +<td>deleted</td> +</tr> +<tr class="b"><td>SECURITY_PERMISSION</td> +<td> columns and constraints changed</td> +</tr> +<tr class="a"><td>SECURITY_PRINCIPAL</td> +<td>columns and constraints changed</td> +</tr> +<tr class="b"><td>SECURITY_PRINCIPAL_ASSOC</td> +<td>new table</td> +</tr> +<tr class="a"><td>SECURITY_USER_GROUP</td> +<td>deleted</td> +</tr> +<tr class="b"><td>SECURITY_USER_ROLE</td> +<td>deleted</td> +</tr> +<tr class="a"><td>SSO_COOKIE</td> +<td>deleted</td> +</tr> +<tr class="b"><td>SSO_COOKIE_TO_REMOTE</td> +<td>deleted</td> +</tr> +<tr class="a"><td>SSO_PRINCIPAL_TO_REMOTE</td> +<td>deleted</td> +</tr> +<tr class="b"><td>SSO_SITE</td> +<td>columns and constraints changed</td> +</tr> +<tr class="a"><td>SSO_SITE_TO_PRINCIPALS</td> +<td>deleted</td> +</tr> +<tr class="b"><td>SSO_SITE_TO_REMOTE</td> +<td>deleted</td> +</tr> +</table> +<p></p> +<table class="bodyTable"><tr class="a"><th>Statisitics Table Name</th> +<th>Modification</th> +</tr> +<tr class="b"><td>ADMIN_ACTIVITY</td> +<td>column sizes changed</td> +</tr> +<tr class="a"><td>USER_ACTIVITY</td> +<td>column sizes changed</td> +</tr> +</table> <p> Given the extensive modifications made between these releases, migration is best performed using an ETL approach. To support this outside of the Jetspeed portal build and runtime environments, export, initialization, and import functionality have been integrated into the Jetspeed installer. The installer can be downloaded as a binary and, together with a JDBC driver, can be used to migrate from 2.1.3/2.1.4 to 2.2.1. - </p> + </p> <p> Documentation for ETL migration using the Jetspeed installer can be found here: <a href="guide-etl-migration.html">ETL Migration Guide</a>. Note that migration of Derby databases using the installer is not currently supported. - </p> -</div> -<div class="section"><h2><a name="Data_Migrating_from_Jetspeed_2.1.3_to_2.1.4"></a>Data Migrating from Jetspeed 2.1.3 to 2.1.4</h2> + </p> +</div> +<div class="section"><h2><a name="Data_Migrating_from_Jetspeed_2.1.3_to_2.1.4"></a>Data Migrating from Jetspeed 2.1.3 to 2.1.4</h2> <p>The following tables describe database schema changes from version 2.1.3 to version 2.1.4. - </p> -<div class="section"><h3><a name="Constraint_removed"></a>Constraint removed</h3> -<table class="bodyTable"><tr class="b"><th>Table</th> -<th>column(s)</th> -<th>2.1.3</th> -<th>2.1.4</th> -</tr> -<tr class="a"><td>PARAMETER</td> -<td>PARAMETER_VALUE</td> -<td>Required</td> -<td>Not required</td> -</tr> -</table> + </p> +<div class="section"><h3><a name="Constraint_removed"></a>Constraint removed</h3> +<table class="bodyTable"><tr class="b"><th>Table</th> +<th>column(s)</th> +<th>2.1.3</th> +<th>2.1.4</th> +</tr> +<tr class="a"><td>PARAMETER</td> +<td>PARAMETER_VALUE</td> +<td>Required</td> +<td>Not required</td> +</tr> +</table> <p> Here is an example of the SQL migration scripts for the MySQL database: - <div class="source"><pre>ALTER TABLE 'PARAMETER` MODIFY COLUMN `PARAMETER_VALUE` DEFAULT NULL;</pre> -</div> -</p> -</div> -</div> -<div class="section"><h2><a name="Data_Migrating_from_Jetspeed_2.1.2_to_2.1.3"></a>Data Migrating from Jetspeed 2.1.2 to 2.1.3</h2> + <div class="source"><pre>ALTER TABLE 'PARAMETER` MODIFY COLUMN `PARAMETER_VALUE` DEFAULT NULL;</pre> +</div> +</p> +</div> +</div> +<div class="section"><h2><a name="Data_Migrating_from_Jetspeed_2.1.2_to_2.1.3"></a>Data Migrating from Jetspeed 2.1.2 to 2.1.3</h2> <p>The following tables describe database schema changes from version 2.1.3 to version 2.1.2. - </p> -<div class="section"><h3><a name="Added_Indexes"></a>Added Indexes</h3> -<table class="bodyTable"><tr class="b"><th>Table</th> -<th>Index</th> -<th>type</th> -<th>column(s)</th> -</tr> -<tr class="a"><td>PREFS_NODE</td> -<td>IX_PREFS_NODE_1</td> -<td>non unique</td> -<td>PARENT_NODE_ID</td> -</tr> -<tr class="b"><td>PREFS_NODE</td> -<td>IX_PREFS_NODE_2</td> -<td>non unique</td> -<td>FULL_PATH</td> -</tr> -<tr class="a"><td>PREFS_PROPERTY_VALUE</td> -<td>IX_FKPPV_1</td> -<td>non unique</td> -<td>NODE_ID</td> -</tr> -</table> -</div> -<div class="section"><h3><a name="Foreign_Key_Altering"></a>Foreign Key Altering</h3> -<table class="bodyTable"><tr class="b"><th>Table</th> -<th>Name</th> -<th>Column(s)</th> -<th>Referencing table</th> -<th>Referencing column(s)</th> -<th>2.1.2</th> -<th>2.1.3</th> -</tr> -<tr class="a"><td>PREFS_NODE</td> -<td>FK_PREFS_NODE_1</td> -<td>PARENT_NODE_ID</td> -<td>PREFS_NODE</td> -<td>NODE_ID</td> -<td>(not casade delete)</td> -<td>CASCADE DELETE</td> -</tr> -<tr class="b"><td>PREFS_PROPERTY_VALUE</td> -<td>(not named)</td> -<td>NODE_ID</td> -<td>PREFS_NODE</td> -<td>NODE_ID</td> -<td>(not casade delete)</td> -<td>CASCADE DELETE</td> -</tr> -</table> + </p> +<div class="section"><h3><a name="Added_Indexes"></a>Added Indexes</h3> +<table class="bodyTable"><tr class="b"><th>Table</th> +<th>Index</th> +<th>type</th> +<th>column(s)</th> +</tr> +<tr class="a"><td>PREFS_NODE</td> +<td>IX_PREFS_NODE_1</td> +<td>non unique</td> +<td>PARENT_NODE_ID</td> +</tr> +<tr class="b"><td>PREFS_NODE</td> +<td>IX_PREFS_NODE_2</td> +<td>non unique</td> +<td>FULL_PATH</td> +</tr> +<tr class="a"><td>PREFS_PROPERTY_VALUE</td> +<td>IX_FKPPV_1</td> +<td>non unique</td> +<td>NODE_ID</td> +</tr> +</table> +</div> +<div class="section"><h3><a name="Foreign_Key_Altering"></a>Foreign Key Altering</h3> +<table class="bodyTable"><tr class="b"><th>Table</th> +<th>Name</th> +<th>Column(s)</th> +<th>Referencing table</th> +<th>Referencing column(s)</th> +<th>2.1.2</th> +<th>2.1.3</th> +</tr> +<tr class="a"><td>PREFS_NODE</td> +<td>FK_PREFS_NODE_1</td> +<td>PARENT_NODE_ID</td> +<td>PREFS_NODE</td> +<td>NODE_ID</td> +<td>(not casade delete)</td> +<td>CASCADE DELETE</td> +</tr> +<tr class="b"><td>PREFS_PROPERTY_VALUE</td> +<td>(not named)</td> +<td>NODE_ID</td> +<td>PREFS_NODE</td> +<td>NODE_ID</td> +<td>(not casade delete)</td> +<td>CASCADE DELETE</td> +</tr> +</table> <p> Here is an example of the SQL migration scripts for the MySQL database: <div class="source"><pre> @@ -675,9 +675,9 @@ CREATE INDEX IX_FKPPV_1 ON PREFS_PROPERT ALTER TABLE PREFS_NODE ADD CONSTRAINT FK_PREFS_NODE_1 FOREIGN KEY (PARENT_NODE_ID) REFERENCES PREFS_NODE (NODE_ID) ON DELETE CASCADE; ALTER TABLE PREFS_PROPERTY_VALUE ADD CONSTRAINT FK_PREFS_PROPERTY_VALUE_1 FOREIGN KEY (NODE_ID) REFERENCES PREFS_NODE (NODE_ID) ON DELETE CASCADE; - </pre> -</div> -</p> + </pre> +</div> +</p> <p> Here is an example of the SQL migration scripts for the MySQL database: <div class="source"><pre> @@ -687,41 +687,41 @@ CREATE INDEX IX_FKPPV_1 ON PREFS_PROPERT ALTER TABLE PREFS_NODE ADD CONSTRAINT FK_PREFS_NODE_1 FOREIGN KEY (PARENT_NODE_ID) REFERENCES PREFS_NODE (NODE_ID) ON DELETE CASCADE; ALTER TABLE PREFS_PROPERTY_VALUE ADD CONSTRAINT FK_PREFS_PROPERTY_VALUE_1 FOREIGN KEY (NODE_ID) REFERENCES PREFS_NODE (NODE_ID) ON DELETE CASCADE; - </pre> -</div> -</p> -</div> -</div> -<div class="section"><h2><a name="Data_Migrating_from_Jetspeed_2.1_to_2.1.2"></a>Data Migrating from Jetspeed 2.1 to 2.1.2</h2> + </pre> +</div> +</p> +</div> +</div> +<div class="section"><h2><a name="Data_Migrating_from_Jetspeed_2.1_to_2.1.2"></a>Data Migrating from Jetspeed 2.1 to 2.1.2</h2> <p>The following tables describe database schema changes from version 2.1 to version 2.1.2. - </p> -<div class="section"><h3><a name="Added_Tables"></a>Added Tables</h3> -<table class="bodyTable"><tr class="a"><th>Table</th> -</tr> -<tr class="b"><td>ADMIN_ACTIVITY</td> -</tr> -<tr class="a"><td>USER_ACTIVITY</td> -</tr> -</table> -</div> -</div> -<div class="section"><h2><a name="Configuration_Migrating_from_Jetspeed_2.0_to_2.1"></a>Configuration Migrating from Jetspeed 2.0 to 2.1</h2> + </p> +<div class="section"><h3><a name="Added_Tables"></a>Added Tables</h3> +<table class="bodyTable"><tr class="a"><th>Table</th> +</tr> +<tr class="b"><td>ADMIN_ACTIVITY</td> +</tr> +<tr class="a"><td>USER_ACTIVITY</td> +</tr> +</table> +</div> +</div> +<div class="section"><h2><a name="Configuration_Migrating_from_Jetspeed_2.0_to_2.1"></a>Configuration Migrating from Jetspeed 2.0 to 2.1</h2> <p>The following items describe important functional changes in Jetspeed 2.1 - </p> -<div class="section"><h3><a name="Portlet_API_Caching"></a>Portlet API Caching</h3> + </p> +<div class="section"><h3><a name="Portlet_API_Caching"></a>Portlet API Caching</h3> <p>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. <div class="source"><pre> UPDATE PORTLET_DEFINITION P SET EXPIRATION_CACHE = 0 WHERE P.APPLICATION_ID = 2 -</pre> -</div> -</p> -</div> -<div class="section"><h3><a name="Portlet_Preferences"></a>Portlet Preferences</h3> -<p>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.</p> -<p>To retain most of the old Jetspeed 2.0 behavior, allowing an administrator to still set/modify <i>initial</i> Preferences for other users,<br /> +</pre> +</div> +</p> +</div> +<div class="section"><h3><a name="Portlet_Preferences"></a>Portlet Preferences</h3> +<p>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.</p> +<p>To retain most of the old Jetspeed 2.0 behavior, allowing an administrator to still set/modify <i>initial</i> Preferences for other users,<br /> modify the following setting in the registry.xml spring assembly configuration for the portletEntityAccessImpl component: <div class="source"><pre> @@ -736,423 +736,423 @@ UPDATE PORTLET_DEFINITION P SET EXPIRATI <constructor-arg type="boolean"> <value>false</value> </constructor-arg> - </pre> -</div> + </pre> +</div> - As is commented in the assembly configuration also, setting <i>mergeSharedPreferences</i> to <i>true</i> will <i>NOT</i> turn off per user Preferences.<br /> + As is commented in the assembly configuration also, setting <i>mergeSharedPreferences</i> to <i>true</i> will <i>NOT</i> turn off per user Preferences.<br /> - Once a user sets its own Preference values (if allowed), those will override the shared Preference values.<br /> + Once a user sets its own Preference values (if allowed), those will override the shared Preference values.<br /> - See for further information: <a href="http://issues.apache.org/jira/browse/JS2-449"; class="externalLink">JS2-449</a></p> -</div> -</div> -<div class="section"><h2><a name="Data_Migrating_from_Jetspeed_2.0_to_2.1"></a>Data Migrating from Jetspeed 2.0 to 2.1</h2> + See for further information: <a class="externalLink" href="http://issues.apache.org/jira/browse/JS2-449";>JS2-449</a></p> +</div> +</div> +<div class="section"><h2><a name="Data_Migrating_from_Jetspeed_2.0_to_2.1"></a>Data Migrating from Jetspeed 2.0 to 2.1</h2> <p>The following tables describe database schema changes from version 2.0 to version 2.1. - </p> -<div class="section"><h3><a name="Added_Tables"></a>Added Tables</h3> -<table class="bodyTable"><tr class="b"><th>Table</th> -</tr> -<tr class="a"><td>CUSTOM_PORTLET_MODE</td> -</tr> -<tr class="b"><td>CUSTOM_WINDOW_STATE</td> -</tr> -</table> -</div> -<div class="section"><h3><a name="Column_Altering"></a>Column Altering</h3> -<table class="bodyTable"><tr class="a"><th>Table</th> -<th>Column</th> -<th>2.0</th> -<th>2.1</th> -</tr> -<tr class="b"><td>PORTLET_STATISTICS</td> -<td>ELAPSED_TIME</td> -<td>INTEGER</td> -<td>BIGINT</td> -</tr> -<tr class="a"><td>PAGE_STATISTICS</td> -<td>ELAPSED_TIME</td> -<td>INTEGER</td> -<td>BIGINT</td> -</tr> -<tr class="b"><td>USER_STATISTICS</td> -<td>ELAPSED_TIME</td> -<td>INTEGER</td> -<td>BIGINT</td> -</tr> -<tr class="a"><td>FOLDER</td> -<td>SKIN</td> -<td></td> -<td>NEW: VARCHAR(80)</td> -</tr> -<tr class="b"><td>FOLDER</td> -<td>DEFAULT_LAYOUT_DECORATOR</td> -<td></td> -<td>NEW: VARCHAR(80)</td> -</tr> -<tr class="a"><td>FOLDER</td> -<td>DEFAULT_PORTLET_DECORATOR</td> -<td></td> -<td>NEW: VARCHAR(80)</td> -</tr> -<tr class="b"><td>FRAGMENT</td> -<td>STATE</td> -<td>VARCHAR(40)</td> -<td>VARCHAR(10)</td> -</tr> -<tr class="a"><td>FRAGMENT</td> -<td>PMODE</td> -<td></td> -<td>NEW: VARCHAR(10)</td> -</tr> -<tr class="b"><td>FRAGMENT</td> -<td>LAYOUT_X</td> -<td></td> -<td>NEW: REAL</td> -</tr> -<tr class="a"><td>FRAGMENT</td> -<td>LAYOUT_Y</td> -<td></td> -<td>NEW: REAL</td> -</tr> -<tr class="b"><td>FRAGMENT</td> -<td>LAYOUT_Z</td> -<td></td> -<td>NEW: REAL</td> -</tr> -<tr class="a"><td>FRAGMENT</td> -<td>LAYOUT_WIDTH</td> -<td></td> -<td>NEW: REAL</td> -</tr> -<tr class="b"><td>FRAGMENT</td> -<td>LAYOUT_HEIGHT</td> -<td></td> -<td>NEW: REAL</td> -</tr> -<tr class="a"><td>LINK</td> -<td>SKIN</td> -<td></td> -<td>NEW: VARCHAR(80)</td> -</tr> -<tr class="b"><td>PORTLET_DEFINITION</td> -<td>SECURITY_REF</td> -<td></td> -<td>NEW: VARCHAR(40)</td> -</tr> -<tr class="a"><td>PORTLET_DEFINITION</td> -<td>SECURITY_REF</td> -<td></td> -<td>NEW: VARCHAR(40)</td> -</tr> -<tr class="b"><td>PORTLET_APPLICATION</td> -<td>SECURITY_REF</td> -<td></td> -<td>NEW: VARCHAR(40)</td> -</tr> -<tr class="a"><td>SSO_COOKIE</td> -<td>COOKIE</td> -<td>VARCHAR(250)</td> -<td>VARCHAR(1024)</td> -</tr> -</table> -</div> -<div class="section"><h3><a name="Index_Altering"></a>Index Altering</h3> -<table class="bodyTable"><tr class="b"><th>Table</th> -<th>Index</th> -<th>2.0</th> -<th>2.1</th> -</tr> -<tr class="a"><td>FOLDER_MENU</td> -<td>UN_FOLDER_MENU_1</td> -<td>unique</td> -<td>(non unique) index</td> -</tr> -<tr class="b"><td>PAGE_MENU</td> -<td>UN_PAGE_MENU_1</td> -<td>unique</td> -<td>(non unique) index</td> -</tr> -<tr class="a"><td>FRAGMENT</td> -<td>UN_FRAGMENT_1</td> -<td>unique</td> -<td>(non unique) index</td> -</tr> -</table> -</div> -<div class="section"><h3><a name="Foreign_Key_Altering"></a>Foreign Key Altering</h3> -<table class="bodyTable"><tr class="b"><th>Table</th> -<th>Column</th> -<th>2.0</th> -<th>2.1</th> -</tr> -<tr class="a"><td>FOLDER</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FOLDER_1"</td> -</tr> -<tr class="b"><td>FOLDER_METADATA</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FOLDER_METADATA_1"</td> -</tr> -<tr class="a"><td>FOLDER_CONSTRAINT</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FOLDER_CONSTRAINT_1"</td> -</tr> -<tr class="b"><td>FOLDER_CONSTRAINTS_REF</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FOLDER_CONSTRAINT_REF_1"</td> -</tr> -<tr class="a"><td>FOLDER_ORDER</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FOLDER_ORDER_1"</td> -</tr> -<tr class="b"><td>FOLDER_MENU</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FOLDER_MENU_1"</td> -</tr> -<tr class="a"><td>FOLDER_MENU</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FOLDER_MENU_2"</td> -</tr> -<tr class="b"><td>FOLDER_MENU_METADATA</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FOLDER_MENU_METADATA_1"</td> -</tr> -<tr class="a"><td>PAGE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PAGE_1"</td> -</tr> -<tr class="b"><td>PAGE_METADATA</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PAGE_METADATA_1"</td> -</tr> -<tr class="a"><td>PAGE_CONSTRAINT</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PAGE_CONSTRAINT_1"</td> -</tr> -<tr class="b"><td>PAGE_CONSTRAINT_REF</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PAGE_CONSTRAINTS_REF_1"</td> -</tr> -<tr class="a"><td>PAGE_MENU</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PAGE_MENU_1"</td> -</tr> -<tr class="b"><td>PAGE_MENU</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "PM_M_FK_PAGE_ID_PAGE"</td> -</tr> -<tr class="a"><td>PAGE_MENU_METADATA</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PAGE_MENU_METADATA_1"</td> -</tr> -<tr class="b"><td>FRAGMENT</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FRAGMENT_1"</td> -</tr> -<tr class="a"><td>FRAGMENT</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FRAGMENT_2"</td> -</tr> -<tr class="b"><td>FRAGMENT_CONSTRAINT</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FRAGMENT_CONSTRAINT_1"</td> -</tr> -<tr class="a"><td>FRAGMENT_CONSTRAINT_REF</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FRAGMENT_CONSTRAINT_REF_1"</td> -</tr> -<tr class="b"><td>FRAGMENT_PREF</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FRAGMENT_PREF_1"</td> -</tr> -<tr class="a"><td>FRAGMENT_PREF_VALUE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_FRAGMENT_PREF_VALUE_1"</td> -</tr> -<tr class="b"><td>LINK</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_LINK_1"</td> -</tr> -<tr class="a"><td>LINK_METADATA</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_LINK_METADATA_1"</td> -</tr> -<tr class="b"><td>LINK_CONSTRAINT</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_LINK_CONSTRAINT_1"</td> -</tr> -<tr class="a"><td>LINK_CONSTRAINT_REF</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_LINK_CONSTRAINT_REF_1"</td> -</tr> -<tr class="b"><td>PAGE_SECURITY</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PAGE_SECURITY_1"</td> -</tr> -<tr class="a"><td>PAGE_SEC_CONSTRAINTS_DEF</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PAGE_SEC_CONSTRAINTS_DEF_1"</td> -</tr> -<tr class="b"><td>PAGE_SEC_CONSTRAINT_DEF</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PAGE_SEC_CONSTRAINT_DEF_1"</td> -</tr> -<tr class="a"><td>PAGE_SEC_CONSTRAINTS_REF</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PAGE_SEC_CONSTRAINTS_REF_1"</td> -</tr> -<tr class="b"><td>PAGE_SEC_CONSTRAINT_REF</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PAGE_SEC_CONSTRAINT_REF_1"</td> -</tr> -<tr class="a"><td>RULE_CRITERION</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_RULE_CRITERION_1"</td> -</tr> -<tr class="b"><td>PREFS_NODE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PREFS_NODE_1"</td> -</tr> -<tr class="a"><td>PA_METADATA_FIELDS</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PA_METADATA_FIELDS_1"</td> -</tr> -<tr class="b"><td>PD_METADATA_FIELDS</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PD_METADATA_FIELDS_1"</td> -</tr> -<tr class="a"><td>USER_ATTRIBUTE_REF</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_USER_ATTRIBUTE_REF_1"</td> -</tr> -<tr class="b"><td>USER_ATTRIBUTE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_USER_ATTRIBUTE_1"</td> -</tr> -<tr class="a"><td>PRINCIPAL_PERMISSION</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PRINCIPAL_PERMISSION_1"</td> -</tr> -<tr class="b"><td>PRINCIPAL_PERMISSION</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_PRINCIPAL_PERMISSION_2"</td> -</tr> -<tr class="a"><td>SECURITY_CREDENTIAL</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SECURITY_CREDENTIAL_1"</td> -</tr> -<tr class="b"><td>SSO_SITE_TO_PRINCIPALS</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "SSO_SITE_TO_PRINC_FK1"</td> -</tr> -<tr class="a"><td>SSO_SITE_TO_PRINCIPALS</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "SSO_SITE_TO_PRINC_FK2"</td> -</tr> -<tr class="b"><td>SSO_PRINCIPAL_TO_REMOTE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SSO_PRINCIPAL_TO_REMOTE_1"</td> -</tr> -<tr class="a"><td>SSO_PRINCIPAL_TO_REMOTE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SSO_PRINCIPAL_TO_REMOTE_2"</td> -</tr> -<tr class="b"><td>SSO_SITE_TO_REMOTE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SSO_SITE_TO_REMOTE_1"</td> -</tr> -<tr class="a"><td>SSO_SITE_TO_REMOTE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SSO_SITE_TO_REMOTE_2"</td> -</tr> -<tr class="b"><td>SSO_COOKIE_TO_REMOTE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SSO_COOKIE_TO_REMOTE_1"</td> -</tr> -<tr class="a"><td>SSO_COOKIE_TO_REMOTE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SSO_COOKIE_TO_REMOTE_2"</td> -</tr> -<tr class="b"><td>SECURITY_USER_ROLE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SECURITY_USER_ROLE_1"</td> -</tr> -<tr class="a"><td>SECURITY_USER_ROLE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SECURITY_USER_ROLE_2"</td> -</tr> -<tr class="b"><td>SECURITY_USER_GROUP</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SECURITY_USER_GROUP_1"</td> -</tr> -<tr class="a"><td>SECURITY_USER_GROUP</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SECURITY_USER_GROUP_2"</td> -</tr> -<tr class="b"><td>SECURITY_GROUP_ROLE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SECURITY_GROUP_ROLE_1"</td> -</tr> -<tr class="a"><td>SECURITY_GROUP_ROLE</td> -<td>(FK constraint)</td> -<td>(not named)</td> -<td>named FK constraint "FK_SECURITY_GROUP_ROLE_2"</td> -</tr> -</table> -</div> -</div> + </p> +<div class="section"><h3><a name="Added_Tables"></a>Added Tables</h3> +<table class="bodyTable"><tr class="b"><th>Table</th> +</tr> +<tr class="a"><td>CUSTOM_PORTLET_MODE</td> +</tr> +<tr class="b"><td>CUSTOM_WINDOW_STATE</td> +</tr> +</table> +</div> +<div class="section"><h3><a name="Column_Altering"></a>Column Altering</h3> +<table class="bodyTable"><tr class="a"><th>Table</th> +<th>Column</th> +<th>2.0</th> +<th>2.1</th> +</tr> +<tr class="b"><td>PORTLET_STATISTICS</td> +<td>ELAPSED_TIME</td> +<td>INTEGER</td> +<td>BIGINT</td> +</tr> +<tr class="a"><td>PAGE_STATISTICS</td> +<td>ELAPSED_TIME</td> +<td>INTEGER</td> +<td>BIGINT</td> +</tr> +<tr class="b"><td>USER_STATISTICS</td> +<td>ELAPSED_TIME</td> +<td>INTEGER</td> +<td>BIGINT</td> +</tr> +<tr class="a"><td>FOLDER</td> +<td>SKIN</td> +<td></td> +<td>NEW: VARCHAR(80)</td> +</tr> +<tr class="b"><td>FOLDER</td> +<td>DEFAULT_LAYOUT_DECORATOR</td> +<td></td> +<td>NEW: VARCHAR(80)</td> +</tr> +<tr class="a"><td>FOLDER</td> +<td>DEFAULT_PORTLET_DECORATOR</td> +<td></td> +<td>NEW: VARCHAR(80)</td> +</tr> +<tr class="b"><td>FRAGMENT</td> +<td>STATE</td> +<td>VARCHAR(40)</td> +<td>VARCHAR(10)</td> +</tr> +<tr class="a"><td>FRAGMENT</td> +<td>PMODE</td> +<td></td> +<td>NEW: VARCHAR(10)</td> +</tr> +<tr class="b"><td>FRAGMENT</td> +<td>LAYOUT_X</td> +<td></td> +<td>NEW: REAL</td> +</tr> +<tr class="a"><td>FRAGMENT</td> +<td>LAYOUT_Y</td> +<td></td> +<td>NEW: REAL</td> +</tr> +<tr class="b"><td>FRAGMENT</td> +<td>LAYOUT_Z</td> +<td></td> +<td>NEW: REAL</td> +</tr> +<tr class="a"><td>FRAGMENT</td> +<td>LAYOUT_WIDTH</td> +<td></td> +<td>NEW: REAL</td> +</tr> +<tr class="b"><td>FRAGMENT</td> +<td>LAYOUT_HEIGHT</td> +<td></td> +<td>NEW: REAL</td> +</tr> +<tr class="a"><td>LINK</td> +<td>SKIN</td> +<td></td> +<td>NEW: VARCHAR(80)</td> +</tr> +<tr class="b"><td>PORTLET_DEFINITION</td> +<td>SECURITY_REF</td> +<td></td> +<td>NEW: VARCHAR(40)</td> +</tr> +<tr class="a"><td>PORTLET_DEFINITION</td> +<td>SECURITY_REF</td> +<td></td> +<td>NEW: VARCHAR(40)</td> +</tr> +<tr class="b"><td>PORTLET_APPLICATION</td> +<td>SECURITY_REF</td> +<td></td> +<td>NEW: VARCHAR(40)</td> +</tr> +<tr class="a"><td>SSO_COOKIE</td> +<td>COOKIE</td> +<td>VARCHAR(250)</td> +<td>VARCHAR(1024)</td> +</tr> +</table> +</div> +<div class="section"><h3><a name="Index_Altering"></a>Index Altering</h3> +<table class="bodyTable"><tr class="b"><th>Table</th> +<th>Index</th> +<th>2.0</th> +<th>2.1</th> +</tr> +<tr class="a"><td>FOLDER_MENU</td> +<td>UN_FOLDER_MENU_1</td> +<td>unique</td> +<td>(non unique) index</td> +</tr> +<tr class="b"><td>PAGE_MENU</td> +<td>UN_PAGE_MENU_1</td> +<td>unique</td> +<td>(non unique) index</td> +</tr> +<tr class="a"><td>FRAGMENT</td> +<td>UN_FRAGMENT_1</td> +<td>unique</td> +<td>(non unique) index</td> +</tr> +</table> +</div> +<div class="section"><h3><a name="Foreign_Key_Altering"></a>Foreign Key Altering</h3> +<table class="bodyTable"><tr class="b"><th>Table</th> +<th>Column</th> +<th>2.0</th> +<th>2.1</th> +</tr> +<tr class="a"><td>FOLDER</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FOLDER_1"</td> +</tr> +<tr class="b"><td>FOLDER_METADATA</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FOLDER_METADATA_1"</td> +</tr> +<tr class="a"><td>FOLDER_CONSTRAINT</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FOLDER_CONSTRAINT_1"</td> +</tr> +<tr class="b"><td>FOLDER_CONSTRAINTS_REF</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FOLDER_CONSTRAINT_REF_1"</td> +</tr> +<tr class="a"><td>FOLDER_ORDER</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FOLDER_ORDER_1"</td> +</tr> +<tr class="b"><td>FOLDER_MENU</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FOLDER_MENU_1"</td> +</tr> +<tr class="a"><td>FOLDER_MENU</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FOLDER_MENU_2"</td> +</tr> +<tr class="b"><td>FOLDER_MENU_METADATA</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FOLDER_MENU_METADATA_1"</td> +</tr> +<tr class="a"><td>PAGE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PAGE_1"</td> +</tr> +<tr class="b"><td>PAGE_METADATA</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PAGE_METADATA_1"</td> +</tr> +<tr class="a"><td>PAGE_CONSTRAINT</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PAGE_CONSTRAINT_1"</td> +</tr> +<tr class="b"><td>PAGE_CONSTRAINT_REF</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PAGE_CONSTRAINTS_REF_1"</td> +</tr> +<tr class="a"><td>PAGE_MENU</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PAGE_MENU_1"</td> +</tr> +<tr class="b"><td>PAGE_MENU</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "PM_M_FK_PAGE_ID_PAGE"</td> +</tr> +<tr class="a"><td>PAGE_MENU_METADATA</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PAGE_MENU_METADATA_1"</td> +</tr> +<tr class="b"><td>FRAGMENT</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FRAGMENT_1"</td> +</tr> +<tr class="a"><td>FRAGMENT</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FRAGMENT_2"</td> +</tr> +<tr class="b"><td>FRAGMENT_CONSTRAINT</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FRAGMENT_CONSTRAINT_1"</td> +</tr> +<tr class="a"><td>FRAGMENT_CONSTRAINT_REF</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FRAGMENT_CONSTRAINT_REF_1"</td> +</tr> +<tr class="b"><td>FRAGMENT_PREF</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FRAGMENT_PREF_1"</td> +</tr> +<tr class="a"><td>FRAGMENT_PREF_VALUE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_FRAGMENT_PREF_VALUE_1"</td> +</tr> +<tr class="b"><td>LINK</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_LINK_1"</td> +</tr> +<tr class="a"><td>LINK_METADATA</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_LINK_METADATA_1"</td> +</tr> +<tr class="b"><td>LINK_CONSTRAINT</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_LINK_CONSTRAINT_1"</td> +</tr> +<tr class="a"><td>LINK_CONSTRAINT_REF</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_LINK_CONSTRAINT_REF_1"</td> +</tr> +<tr class="b"><td>PAGE_SECURITY</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PAGE_SECURITY_1"</td> +</tr> +<tr class="a"><td>PAGE_SEC_CONSTRAINTS_DEF</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PAGE_SEC_CONSTRAINTS_DEF_1"</td> +</tr> +<tr class="b"><td>PAGE_SEC_CONSTRAINT_DEF</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PAGE_SEC_CONSTRAINT_DEF_1"</td> +</tr> +<tr class="a"><td>PAGE_SEC_CONSTRAINTS_REF</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PAGE_SEC_CONSTRAINTS_REF_1"</td> +</tr> +<tr class="b"><td>PAGE_SEC_CONSTRAINT_REF</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PAGE_SEC_CONSTRAINT_REF_1"</td> +</tr> +<tr class="a"><td>RULE_CRITERION</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_RULE_CRITERION_1"</td> +</tr> +<tr class="b"><td>PREFS_NODE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PREFS_NODE_1"</td> +</tr> +<tr class="a"><td>PA_METADATA_FIELDS</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PA_METADATA_FIELDS_1"</td> +</tr> +<tr class="b"><td>PD_METADATA_FIELDS</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PD_METADATA_FIELDS_1"</td> +</tr> +<tr class="a"><td>USER_ATTRIBUTE_REF</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_USER_ATTRIBUTE_REF_1"</td> +</tr> +<tr class="b"><td>USER_ATTRIBUTE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_USER_ATTRIBUTE_1"</td> +</tr> +<tr class="a"><td>PRINCIPAL_PERMISSION</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PRINCIPAL_PERMISSION_1"</td> +</tr> +<tr class="b"><td>PRINCIPAL_PERMISSION</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_PRINCIPAL_PERMISSION_2"</td> +</tr> +<tr class="a"><td>SECURITY_CREDENTIAL</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SECURITY_CREDENTIAL_1"</td> +</tr> +<tr class="b"><td>SSO_SITE_TO_PRINCIPALS</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "SSO_SITE_TO_PRINC_FK1"</td> +</tr> +<tr class="a"><td>SSO_SITE_TO_PRINCIPALS</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "SSO_SITE_TO_PRINC_FK2"</td> +</tr> +<tr class="b"><td>SSO_PRINCIPAL_TO_REMOTE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SSO_PRINCIPAL_TO_REMOTE_1"</td> +</tr> +<tr class="a"><td>SSO_PRINCIPAL_TO_REMOTE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SSO_PRINCIPAL_TO_REMOTE_2"</td> +</tr> +<tr class="b"><td>SSO_SITE_TO_REMOTE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SSO_SITE_TO_REMOTE_1"</td> +</tr> +<tr class="a"><td>SSO_SITE_TO_REMOTE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SSO_SITE_TO_REMOTE_2"</td> +</tr> +<tr class="b"><td>SSO_COOKIE_TO_REMOTE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SSO_COOKIE_TO_REMOTE_1"</td> +</tr> +<tr class="a"><td>SSO_COOKIE_TO_REMOTE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SSO_COOKIE_TO_REMOTE_2"</td> +</tr> +<tr class="b"><td>SECURITY_USER_ROLE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SECURITY_USER_ROLE_1"</td> +</tr> +<tr class="a"><td>SECURITY_USER_ROLE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SECURITY_USER_ROLE_2"</td> +</tr> +<tr class="b"><td>SECURITY_USER_GROUP</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SECURITY_USER_GROUP_1"</td> +</tr> +<tr class="a"><td>SECURITY_USER_GROUP</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SECURITY_USER_GROUP_2"</td> +</tr> +<tr class="b"><td>SECURITY_GROUP_ROLE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SECURITY_GROUP_ROLE_1"</td> +</tr> +<tr class="a"><td>SECURITY_GROUP_ROLE</td> +<td>(FK constraint)</td> +<td>(not named)</td> +<td>named FK constraint "FK_SECURITY_GROUP_ROLE_2"</td> +</tr> +</table> +</div> +</div> </div> </div> @@ -1161,7 +1161,7 @@ UPDATE PORTLET_DEFINITION P SET EXPIRATI </div> <div id="footer"> <div class="xright">© - 2004-2016 + 2004-2022 Apache Software Foundation
Modified: portals/site-live/jetspeed-2/how-to-help.html URL: http://svn.apache.org/viewvc/portals/site-live/jetspeed-2/how-to-help.html?rev=1901428&r1=1901427&r2=1901428&view=diff ============================================================================== --- portals/site-live/jetspeed-2/how-to-help.html (original) +++ portals/site-live/jetspeed-2/how-to-help.html Tue May 31 02:15:08 2022 @@ -42,7 +42,7 @@ <div class="xleft"> - Last Published: 9 May 2016 + Last Published: 26 May 2022 </div> <div class="xright"> <a href="http://portals.apache.org/applications/"; class="externalLink">Applications</a> | @@ -253,52 +253,52 @@ </div> <div id="bodyColumn"> <div id="contentBox"> - <subtitle></subtitle><authors><person name="David Le Strat" email="[email protected]"></authors><div class="section"><h2><a name="How_to_Help"></a>How to Help?</h2> -<div class="section"><h3><a name="Simple_Things_I_Can_Do_to_Help"></a>Simple Things I Can Do to Help</h3> + <subtitle></subtitle><authors><person name="David Le Strat" email="[email protected]"></authors><div class="section"><h2><a name="How_to_Help"></a>How to Help?</h2> +<div class="section"><h3><a name="Simple_Things_I_Can_Do_to_Help"></a>Simple Things I Can Do to Help</h3> <p> There are many ways to help with Jetspeed-2 as with most open source projects: <ul><li>Subscribe to the <a href="mail-lists.html">user mailing list</a> and help answer questions from the community. In open source a thriving community makes the project successful. Don't be shy to ask basic questions, we have all - been there.</li> -<li>Report bugs and issues that you encounter in <a href="http://issues.apache.org/jira/secure/BrowseProject.jspa?id=10492"; class="externalLink">Jetspeed-2 bug tracking system</a>. + been there.</li> +<li>Report bugs and issues that you encounter in <a class="externalLink" href="http://issues.apache.org/jira/secure/BrowseProject.jspa?id=10492";>Jetspeed-2 bug tracking system</a>. Prior to reporting a bug, make sure to discuss the issue on the <a href="mail-lists.html">user mailing list</a> or even the - <a href="mail-lists.html">developer mailing list</a>.</li> + <a href="mail-lists.html">developer mailing list</a>.</li> <li>When you encounter an issue, you may be compelled to fix it. We encourage this as this makes for a vibrant - community. Once you have a fix, <a href="devguide/patches.html">submit a patch</a> on the reporting issue.</li> -</ul> -</p> -</div> -<div class="section"><h3><a name="Why_Should_I_Get_Involved"></a>Why Should I Get Involved?</h3> + community. Once you have a fix, <a href="devguide/patches.html">submit a patch</a> on the reporting issue.</li> +</ul> +</p> +</div> +<div class="section"><h3><a name="Why_Should_I_Get_Involved"></a>Why Should I Get Involved?</h3> <p> There are many reasons why you want to help, just a few strong points: - <ul><li>If you help others solve there issues, they will most likely help you when you run into some problems.</li> -<li>By contributing patches, you can influence the prioritization of functionality and get your changes incorporated.</li> -<li>By reporting issues, you help Jetspeed-2 become a stronger project and improve its quality overall.</li> + <ul><li>If you help others solve there issues, they will most likely help you when you run into some problems.</li> +<li>By contributing patches, you can influence the prioritization of functionality and get your changes incorporated.</li> +<li>By reporting issues, you help Jetspeed-2 become a stronger project and improve its quality overall.</li> <li>You will meet and get to know great people as well as share and learn best practices which will help you on - your project.</li> -</ul> + your project.</li> +</ul> We are looking forward to have you part of our community! - </p> -</div> -<div class="section"><h3><a name="How_do_I_Join_the_Project"></a>How do I Join the Project?</h3> + </p> +</div> +<div class="section"><h3><a name="How_do_I_Join_the_Project"></a>How do I Join the Project?</h3> <p> - Projects at Apache operate under a <a href="http://www.apache.org/foundation/how-it-works.html#meritocracy"; class="externalLink">meritocracy</a>. + Projects at Apache operate under a <a class="externalLink" href="http://www.apache.org/foundation/how-it-works.html#meritocracy";>meritocracy</a>. To become a committer, you first need to demonstrate your committment. The best way to do so is to start contributing patch, participate in the community and make your interest known. It takes time and willingness to help and contribute! This may seem a bit intimidating at first, but the community will always help people who show interest and committment. - </p> -</div> + </p> +</div> <subection name="Other Resources for Help"><p> Here are some useful links for other resources for help. - <ul><li><a href="http://portals.apache.org/development/code-standards.html"; class="externalLink">Portals project coding standards</a>.</li> -<li><a href="http://portals.apache.org/development/documentation.html"; class="externalLink">Portals project documentation standards</a>.</li> -<li><a href="http://www.apache.org/foundation/how-it-works.html"; class="externalLink">How does the Apache Software Foundation work</a>?</li> -<li><a href="http://people.apache.org/~coar/mlists.html#portals.apache.org"; class="externalLink">Portals mailing lists statistics</a>. This can be helpful - to help you decide which mailing list to subscribe to.</li> -</ul> -</p> -</subection></div> + <ul><li><a class="externalLink" href="http://portals.apache.org/development/code-standards.html";>Portals project coding standards</a>.</li> +<li><a class="externalLink" href="http://portals.apache.org/development/documentation.html";>Portals project documentation standards</a>.</li> +<li><a class="externalLink" href="http://www.apache.org/foundation/how-it-works.html";>How does the Apache Software Foundation work</a>?</li> +<li><a class="externalLink" href="http://people.apache.org/~coar/mlists.html#portals.apache.org";>Portals mailing lists statistics</a>. This can be helpful + to help you decide which mailing list to subscribe to.</li> +</ul> +</p> +</subection></div> </div> </div> @@ -307,7 +307,7 @@ </div> <div id="footer"> <div class="xright">© - 2004-2016 + 2004-2022 Apache Software Foundation Modified: portals/site-live/jetspeed-2/index.html URL: http://svn.apache.org/viewvc/portals/site-live/jetspeed-2/index.html?rev=1901428&r1=1901427&r2=1901428&view=diff ============================================================================== --- portals/site-live/jetspeed-2/index.html (original) +++ portals/site-live/jetspeed-2/index.html Tue May 31 02:15:08 2022 @@ -42,7 +42,7 @@ <div class="xleft"> - Last Published: 9 May 2016 + Last Published: 26 May 2022 </div> <div class="xright"> <a href="http://portals.apache.org/applications/"; class="externalLink">Applications</a> | @@ -253,112 +253,116 @@ </div> <div id="bodyColumn"> <div id="contentBox"> - <subtitle></subtitle><authors><person name="David Sean Taylor" email="[email protected]"><person name="David Le Strat" email="[email protected]"></authors><div class="section"><h2><a name="Welcome_to_Jetspeed-2"></a>Welcome to Jetspeed-2</h2> -<div id="downloadbox"><h5>Get Jetspeed 2.3.1</h5> + <subtitle></subtitle><authors><person name="David Sean Taylor" email="[email protected]"><person name="David Le Strat" email="[email protected]"></authors><div class="section"><h2><a name="Dormant_Sub-project_Warning"></a>Dormant Sub-project Warning</h2> +<div class="alert-heading"><em>Warning</em>: Jetspeed-2 is a dormant project of Apache Portals as of May 24, 2022. + No further support will be provided. + </div></div> +<div class="section"><h2><a name="Welcome_to_Jetspeed-2"></a>Welcome to Jetspeed-2</h2> +<div id="downloadbox"><h5>Get Jetspeed 2.3.1</h5> <p><a href="download.html"><img src="images/folder-open.gif" alt="" /> Download </a> Jetspeed 2.3.1 - <small>(94MB)</small></p> + <small>(94MB)</small></p> <ul><li><a href="getting-started.html#Requirements"> System Requirements - </a></li> + </a></li> <li><a href="getting-started-installer.html"> Installation Instructions - </a></li> -<li><a href="release-notes.html">Release Notes</a></li> -<li><a href="features.html">Features</a></li> + </a></li> +<li><a href="release-notes.html">Release Notes</a></li> +<li><a href="features.html">Features</a></li> <li><a href="guide-migration.html"> Migrating Guide - </a></li> + </a></li> <li><a href="demo.html"> Live demo! - </a></li> -</ul> + </a></li> +</ul> </div><p> Jetspeed is an Open Portal Platform and Enterprise Information Portal, written entirely in open source under the Apache license in Java and XML and based on open standards. All access to the portal is managed through a robust portal security policy. Within a Jetspeed portal, individual portlets can be aggregated to create a page. Each portlet is an independent application with Jetspeed acting as the central hub making information from multiple sources available in an easy to use manner. - </p> + </p> <p> Jetspeed has been fully conformant to the -<a href="http://www.jcp.org/en/jsr/detail?id=286"; class="externalLink">Java Portlet 2.0 Standard</a> since release 2.2.0 in May 2009. +<a class="externalLink" href="http://www.jcp.org/en/jsr/detail?id=286";>Java Portlet 2.0 Standard</a> since release 2.2.0 in May 2009. All releases prior, such as the 2.1.x releases, are conformant to the first Java Portlet Specification, - <a href="http://www.jcp.org/en/jsr/detail?id=168"; class="externalLink">the Java Portlet 1.0 Standard</a>. -</p> + <a class="externalLink" href="http://www.jcp.org/en/jsr/detail?id=168";>the Java Portlet 1.0 Standard</a>. +</p> <p> A portal based on Jetspeed can make applications, database information and other data sources available to end-users through a single web site. Jetspeed provides a security infrastructure so that the information and functions made available to each user can be customized on basis of the user or a role that the user has. The user can access the portal via a web browser, WAP-phone, pager or any other device supported by the servlet engine. - </p> + </p> <p> The Jetspeed enterprise portal integrates dynamic information, people, and processes across organization boundaries. This content is aggregated using portlets from diverse sources. Portlets are just mini-web applications, or web-components. Jetspeed always provides secured access to the portlets. A short overview of Jetspeed <a href="features.html">features</a>: -<ul><li>2.3.1 - <a href="https://portals.apache.org/jetspeed-2/security-reports.html"; class="externalLink">Apache Security Fixes</a></li> -<li>2.3.1 - Search box and Search Results Portlets</li> -<li>2.3.0 - Responsive Layout and Designs</li> -<li>2.3.0 - Java7 Support</li> -<li>2.3.0 - Tomcat7 and Servlet 3.0</li> -<li>2.3.0 - Portlet API 2.1.0</li> -<li>2.3.0 - Jetspeed API + Generics</li> -<li>2.3.0 - Upgrade Dependencies, Spring</li> -<li>2.3.0 - J2-Admin Angular Portlet Framework</li> -<li>2.3.0 - J2-Admin Chart Portlets (JS2-1320)</li> -<li>2.3.0 - New User Manager (JS2-1293)</li> -<li>2.3.0 - Preferences Performance Improvements (JS2-1325)</li> -<li>2.3.0 - Security Performance Improvements (JS2-1324)</li> -<li>2.2.2 Portlet Cloning: allow site editors to quickly create new portlet variants based on modified preference and other descriptor settings</li> -<li>2.2.2 Admin roles security restriction on admin roles maintenance</li> -<li>2.2.1 JetUI AJAX Customization Engine with Dockable Toolbox, Drag and Drop, New Navigations</li> -<li>Secure Access - Security based on standards, ACLs, Open ID, CAS</li> -<li>Single Point of Entry (SSO, Federated) </li> -<li>Enterprise Integration - (EAI, integration points)</li> -<li>Personalization - (customizers, skins) </li> -<li>Dynamic Web Components - (portlets based on standards)</li> -<li>Scaleable, Component Architecture featuring multi-threading</li> -</ul> -</p> -<div class="section"><h3><a name="Jetspeed-2_Status"></a>Jetspeed-2 Status</h3> +<ul><li>2.3.1 - <a class="externalLink" href="https://portals.apache.org/jetspeed-2/security-reports.html";>Apache Security Fixes</a></li> +<li>2.3.1 - Search box and Search Results Portlets</li> +<li>2.3.0 - Responsive Layout and Designs</li> +<li>2.3.0 - Java7 Support</li> +<li>2.3.0 - Tomcat7 and Servlet 3.0</li> +<li>2.3.0 - Portlet API 2.1.0</li> +<li>2.3.0 - Jetspeed API + Generics</li> +<li>2.3.0 - Upgrade Dependencies, Spring</li> +<li>2.3.0 - J2-Admin Angular Portlet Framework</li> +<li>2.3.0 - J2-Admin Chart Portlets (JS2-1320)</li> +<li>2.3.0 - New User Manager (JS2-1293)</li> +<li>2.3.0 - Preferences Performance Improvements (JS2-1325)</li> +<li>2.3.0 - Security Performance Improvements (JS2-1324)</li> +<li>2.2.2 Portlet Cloning: allow site editors to quickly create new portlet variants based on modified preference and other descriptor settings</li> +<li>2.2.2 Admin roles security restriction on admin roles maintenance</li> +<li>2.2.1 JetUI AJAX Customization Engine with Dockable Toolbox, Drag and Drop, New Navigations</li> +<li>Secure Access - Security based on standards, ACLs, Open ID, CAS</li> +<li>Single Point of Entry (SSO, Federated) </li> +<li>Enterprise Integration - (EAI, integration points)</li> +<li>Personalization - (customizers, skins) </li> +<li>Dynamic Web Components - (portlets based on standards)</li> +<li>Scaleable, Component Architecture featuring multi-threading</li> +</ul> +</p> +<div class="section"><h3><a name="Jetspeed-2_Status"></a>Jetspeed-2 Status</h3> <p> The latest version of Jetspeed is 2.3.1, released May 9, 2016. Version 2.3.1 is a minor release, - introducing important Security patches. New features include a new Search UI, Improved Session Preferences, - Detached Portlets, an upgraded tutorial, and improved Responsive Decorators. - The last major release is 2.3.0, introducing responsive portal layouts, - Java 7 and Tomcat 7 support, Portlet API 2.1.0, and much more. See the <a href="features.html">Features</a> page for a complete description of the Jetspeed 2.3.1 release. - </p> -</div> -<div class="section"><h3><a name="Jetspeed_Documentation"></a>Jetspeed Documentation</h3> + introducing important Security patches. New features include a new Search UI, Improved Session Preferences, + Detached Portlets, an upgraded tutorial, and improved Responsive Decorators. + The last major release is 2.3.0, introducing responsive portal layouts, + Java 7 and Tomcat 7 support, Portlet API 2.1.0, and much more. See the <a href="features.html">Features</a> page for a complete description of the Jetspeed 2.3.1 release. + </p> +</div> +<div class="section"><h3><a name="Jetspeed_Documentation"></a>Jetspeed Documentation</h3> <p> Most of Jetspeed's documentation is in the form of guides. Depending on your role at the portal, you may want to read one of these guides: <ul><li><a href="usersguide/index.html"> Users Guide - </a></li> + </a></li> <li><a href="adminguide/index.html"> Administration Guide - </a></li> + </a></li> <li><a href="deployguide/index.html"> Deployment and Configuration Guide - </a></li> + </a></li> <li><a href="buildguide/index.html"> Build Guide - </a></li> + </a></li> <li><a href="devguide/index.html"> Developers Guide - </a></li> -</ul> -</p> -</div> -<div class="section"><h3><a name="Jetspeed_Tutorials"></a>Jetspeed Tutorials</h3> + </a></li> +</ul> +</p> +</div> +<div class="section"><h3><a name="Jetspeed_Tutorials"></a>Jetspeed Tutorials</h3> <p> A great place to learn how to use Jetspeed is with the Tutorials: <ul><li><a href="tutorial/index.html"> Custom Jetspeed Build Tutorial with Maven-2 - </a></li> -</ul> -</p> -</div> -</div> + </a></li> +</ul> +</p> +</div> +</div> </div> </div> @@ -367,7 +371,7 @@ The latest version of Jetspeed is 2.3.1, </div> <div id="footer"> <div class="xright">© - 2004-2016 + 2004-2022 Apache Software Foundation
