JA-SIG
Home
About uPortal
Documentation
Getting
Started
Developers
Implementors
Users
Background
Release
|
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
|
About uPortal