...
The /uPortal/uportal-impl/src/main/resources/properties/db/dbloader.xml properties file may also need to be modified. This file is used by the DbLoader tool to create the uPortal database tables and populate the database. It contains several sample entries which create db-type-mappings for different databases. Find the tags for an MySQL database and modify the db-version, driver-name, and driver-version as necessary. For example:
| Code Block |
|---|
<db-type-mapping>
<db-name>MySQL</db-name>
<db-version>5.0.32-Debian_7etch5-log</db-version>
<driver-name>MySQL-AB JDBC Driver</driver-name>
<driver-version>mysql-connector-java-5.0.8 ( Revision: ${svn.Revision} )</driver-version>
<type><generic>LONGVARCHAR</generic><local>TEXT</local></type>
</db-type-mapping>
|
The /uPortal/uportal-impl/src/main/resources/properties/contexts/personDirectoryContext.xml properties file will also need to be modified.
Replace
| Code Block |
|---|
<value> SELECT FIRST_NAME||' '||LAST_NAME AS FIRST_LAST, FIRST_NAME, LAST_NAME, EMAIL, USER_NAME FROM UP_PERSON_DIR WHERE USER_NAME=? </value> |
...