DbConvert21

Owned by John Fereira
Last updated: Dec 27, 2005Version comment
2 min read

DbConvert21

The DbConvert21 tool is used to upgrade a uPortal 2.1.x database so that it can be used with uPortal 2.3.x code.  The following instructions describe the steps need to complete the conversion. 

Note that this converstion assumes that you will be running uPortal 2.3 with your original uPortal 2.1.x stucture and theme stylesheets, you will not be using aggregated layouts, and you will have internationalization features disabled.  The ability to enable aggregated layouts and internationalization as a result of this upgrade is currently being worked on.

Changes to database schema

  • Add a new column to UP_CHANNEL: CHAN_SECURE.
  • Add a new column to UP_ENTITY_CACHE_INVALIDATION: ENTITY_CACHE_ID

Changes to database data

  • Add a root folder element to all users' layouts by running the conversion tool included with uPortal 2.3.x: ant dbconvert21.
  • Add a row to UP_CHAN_TYPE for the Portlet Adapter:

INSERT INTO UP_CHANE_TYPE VALUES (7, 'org.jasig.portal.channels.portlet.CPortletAdapter', 'Portlet', 'Adapter for JSR-168 Portlets', '/org/jasig/portal/channels/portlet/CPortletAdapter.cpd')
You may have to change your TYPE_ID from 7 to another value if you have added rows to this table.

  • Change the URL's to your theme and structure stylesheets so that they can be loaded from the classpath. Essentially, this means that you need to strip off 'stylesheets' from the beginning of each URL in UP_SS_STRUCT.SS_URI, and UP_SS_STRUCT.SS_DESCRIPTION_URI,  UP_SS_THEME.SS_URI, and UP_SS_THEME.SS_DESCRIPTION_URI.

For example, change

stylesheets/org/jasig/portal/layout/tab-column/nested-tables/nested-tables.xsl
to
/org/jasig/portal/layout/tab-column/nested-tables/nested-tables.xsl

  • To turn on functionality of "Site Map" in the header, three tables need to be changed, as follows:

1) Retrieve the 'sequence_value' from the UP_SEQUENCE table where sequence_name='UP_CHANNEL':

SELECT sequence_value FROM UP_SEQUENCE WHERE sequence_name='UP_CHANNEL';

2) Use this retrieved value (denoted as 'x' in the statement below) to do an insert into the UP_CHANNEL table:

INSERT INTO UP_CHANNEL VALUES (x, 'Site Map','Site Map','A quick view of all your tabs and channels', 'org.jasig.portal.layout.channels.sitemap.CSiteMap', -1, 0, sysdate, 0, sysdate, 30000, 'N', 'N', 'N', 'layout-sitemap', 'N');

3) Insert a row into the UP_PERMISSION table to allow all users access to the Site Map channel (where 'x' in the statement below is the same chan_id used in the insert statement in #2):

INSERT INTO UP_PERMISSION VALUES ('UP_FRAMEWORK', 3, 'local.0', 'SUBSCRIBE', 'CHAN_ID.x', 'GRANT', null, null);

4) Update the sequence_value for UP_CHANNEL in the UP_SEQUENCE table for the next incremental value:

UPDATE UP_SEQUENCE SET sequence_value = sequence_value+1 WHERE sequence_name='UP_CHANNEL';

Changes to portal.properties

  • Disable aggregated layouts by setting the following properties:

org.jasig.portal.layout.UserLayoutManagerFactory.coreImplementation=org.jasig.portal.layout.SimpleUserLayoutManager
org.jasig.portal.UserLayoutStoreFactory.implementation=org.jasig.portal.RDBMUserLayoutStore

  • Disable internationalization by setting the following property:

org.jasig.portal.i18n.LocaleManager.locale_aware=false