Installing Upgrading Designing Configuring Deploying Monitoring Administering Troubleshooting Reference JBI Components
Close Print View
Upgrading: Step 12: Upgrade the Database Connection and Security
 

Classic Java CAPS

Upgrading to Java CAPS 6

Upgrading to Sun Master Index

About the Upgrade Paths to Sun Master Index

Upgrading From eView Studio to Sun Master Index (Repository)

To Upgrade to Sun Master Index (Repository)

Migrating to Service-Enabled Sun Master Index

Step 1: Create the Service-Enabled Master Index

Step 2: Migrate any Custom Plug-ins

Step 3: Update the Object Definition

Step 4: Update midm.xml

Step 5: Update the Master Controller

Step 6: Update the Matching and Standardization Configuration

Step 7: Update Query Definitions

Step 8: Update the Survivor Calculator

Step 9: Update Field Validations

Step 10: Validate the Configuration Files

Step 11: Update Match and Standardization Engine Files

Step 12: Upgrade the Database Connection and Security

Step 13: Finalizing the Upgrade

Step 14 (Optional): Update the Master Index API in Client Projects

Troubleshooting

JBI Based Components

Migrating From eTL to Sun Data Integrator

Step 12: Upgrade the Database Connection and Security

When you migrate to service-enabled Master Index, you need to redefine the database connection pool in the application server Admin Console. You also need to set up security on the Admin Console.

To Upgrade the Database Connection and Security
  1. Start the application server and database.
  2. In the application server Admin Console, create the JDBC connection pool and data source. This procedure is described in Defining a Database Connection Pool in Developing Sun Master Indexes .

    Tip - For the connection pool, use the javax.sql.DataSource class for the same functionality as in previous versions. If you specified distributed transactions when you updated master.xml, use the javax.sql.XADataSource class. Once you create the Connection Pool, you can test the configuration by clicking Ping at the top of the Connection Pool page.

  3. In the application server Admin Console, update security for existing users. Security is described in Defining Master Index Data Manager Security in Maintaining Sun Master Indexes.

    Note - If you created any custom user roles or groups for the Repository-based version, you can create corresponding roles in midm-security.xml.