Adding a Database External System to the Master Index Environment (Repository)

Either an Oracle or a SQL Server external system is required for master index server projects that connect to the database using a database Adapter. Optionally, the database connection can be handled by the application server. Perform the following steps to add a database external system to the master index Environment. If you are not using an Oracle or SQL Server Adapter, be sure to follow the instructions under Defining a Database Connection Pool Through the Application Server in Developing Sun Master Indexes (Repository) to create a database connection pool.

To Add a Database External System

1. In NetBeans, open the Services window.
2. Right-click the master index Environment.
3. Point to New, and then select Oracle External System or Sqlserver External System.
4. In the External System Name field, enter a name for the new external system.
5. Click OK.
6. To configure the connection pool, right-click the new external system, and then select Properties.

   The Properties window appears.

7. Do one of the following:
   • For Oracle, expand Outbound Oracle eWay, and then select JDBC Connector Settings.
   • For SQL Server, expand Outbound Sqlserver non-Transactional Adapter, and then select JDBC Connector Settings.
8. Define the properties in the right portion of the window with information specific to the master index database you created. All properties are described in Configuring Java CAPS Project Components for Database Adapters.

   Be sure to only define the properties for the driver type you are using.

   Note - Creating the database is described in Creating the Master Index Database (Repository) in Developing Sun Master Indexes (Repository). Use the information for that database for the properties on this window.

9. When you finish defining the properties, click OK to close the Properties window.