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.

As of Java CAPS Release 6 Update 1, you need to define two connection pools and two JDBC resources for Sun Master Index. For more information and instructions, see Defining the Database Connection Pools in Developing Sun Master Indexes .

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 the Database Connection Pools 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.

   ---