Portlet Factory, Version 6.1.2
Setting up database storage
Follow these general steps to set up database storage.
- Create the profile data tables and stored procedures. You can create the profile data tables and stored procedures in a database by executing the SQL scripts provided using the database's supported tools. If you are using a DB2 database, add connection information at the top of the script before running it to specify your database name and user name. You might need to customize all scripts according to your specific configuration and requirements. If you so alter any table structures in the scripts, make sure that corresponding source code in stored procedures is also updated to support your changes.
IBM® WebSphere Portlet Factory database scripts are located in the following directory: WEB-INF\factory\scripts
- Configure a WebSphere Portlet Factory user on Oracle. Now execute the profile sets in a DB scripts using the user you have created.
- Modify WebSphere Portlet Factory properties for database operation.
- Verify JDBC driver paths.
- Migrate profile sets to and from a database.
Parent topic: Database storage of profile information
- Configuring an IBM WebSphere Portlet Factory user on Oracle
Prior to running a script on Oracle, configure a user.
- Modifying IBM WebSphere Portlet Factory properties for database operation
You need to modify several properties in WebSphere Portlet Factory cluster.properties file.
- Verifying JDBC driver paths
If you are using a IBM WebSphere Portlet Factory-managed JDBC connection, provide the WebSphere Portlet Factory the path to the JDBC driver to be able to access the database containing the profile sets.
- Migrating profile sets to and from a database
Follow these steps to migrate profile sets to and from a database.
Library | Support |