Skip Navigation Links | |
Exit Print View | |
Developing Oracle Java CAPS Master Indexes (Repository) Java CAPS Documentation |
Developing Oracle Java CAPS Master Indexes (Repository)
Oracle Java CAPS Master Index Overview
About Oracle Java CAPS Master Index
Oracle Java CAPS Master Index Features
Master Index Repository Components
Match Engine Configuration Files
Outbound Object Type Definition (OTD)
Learning about the Master Index Runtime Environment
Functions of the Runtime Environment
Features of the Runtime Environment
Master Index Runtime Components
Object Persistence Service (OPS)
Objects in an Enterprise Record
Working with Project Components
Copying, Cutting, and Pasting Files
Master Index Development Process Overview (Repository)
The Master Index Framework and the Runtime Environment (Repository)
Before You Begin Developing a Master Index (Repository)
Preliminary Data Analysis for a Master Index (Repository)
Planning a Master Index Project (Repository)
Master Index Project Initiation Checklist (Repository)
Creating a Master Index Application (Repository)
Step 1: Create a Project and Start the Wizard (Repository)
Step 2: Name the Master Index Application (Repository)
To Name the Master Index Application
Step 3: Define Source Systems (Repository)
Step 4: Define the Deployment Environment (Repository)
To Define the Deployment Environment
Step 5: Define Parent and Child Objects (Repository)
Creating Objects from a Template
Deleting an Object from the Structure
Step 6: Define the Fields for Each Object (Repository)
Step 7: Generate the Project Files (Repository)
To Generate the Configuration Files
Step 8: Review the Configuration Files (Repository)
Master Index Wizard Field Properties and Name Restrictions (Repository)
Master Index Wizard Field Name Restrictions (Repository)
Master Index Wizard General Field Properties (Repository)
Master Index Wizard EDM Field Properties (Repository)
Custom Plug-ins for Master Index Custom Transaction Processing (Repository)
Master Index Update Policy Plug-ins (Repository)
Master Index Field Validation Plug-ins (Repository)
Master Index Field Masking Plug-ins (Repository)
Master Index Match Processing Logic Plug-ins (Repository)
Custom Match Processing Logic Methods
Custom Match Processing Logic Plug-in Requirements
Custom Match Processing Configuration (Repository)
Master Index Custom Plug-in Exception Processing (Repository)
Custom Plug-Ins for Master Index Custom Components (Repository)
Master Index Survivor Calculator Plug-ins (Repository)
Master Index Query Builder Plug-ins (Repository)
Master Index Block Picker Plug-ins (Repository)
Master Index Pass Controller Plug-ins (Repository)
Match Engine Plug-ins (Repository)
Standardization Engine Plug-ins (Repository)
Phonetic Encoders Plug-ins for a Master Index (Repository)
Implementing Master Index Custom Plug-ins (Repository)
Creating Master Index Custom Plug-ins (Repository)
Building Master Index Custom Plug-ins (Repository)
Generating the Master Index Application (Repository)
To Generate the Application for the First Time
Master Index Database Scripts and Design (Repository)
Master Index Database Scripts (Repository)
Master Index Database Requirements (Repository)
Database Platform Requirements
Master Index Database Structure (Repository)
Designing the Master Index Database (Repository)
Designing for Performance Optimization
Creating the Master Index Database (Repository)
Step 1: Analyze the Master Index Database Requirements (Repository)
Step 2: Create a Master Index Database and User (Repository)
Step 3: Define Master Index Database Indexes (Repository)
Step 4: Define Master Index External Systems (Repository)
Master Index Database Table Description for sbyn_systems (Repository)
Step 5: Define Master Index Code Lists (Repository)
To Customize Common Table Data for Oracle
To Customize Common Table Data for SQL Server
Step 6: Define Master Index User Code Lists (Repository)
Master Index Database Table Description for sbyn_user_code (Repository)
Step 7: Create Custom Master Index Database Scripts (Repository)
Step 8: Create the Master Index Database Structure (Repository)
To Create the Database Structure
Step 9: Specify a Starting EUID for a Master Index (Repository)
If you are using a database Adapter, you configure the database connection pool in the database external system in the Environment and do not need to perform this step. If the application is running on the GlassFish Application Server and is not using a database Adapter to connect to the database, you need to create and configure two JDBC connection pools and resources using the Admin Console.
To set up the connection pools, you create the connection pools and then define a JDBC resource for each pool. This section provides general instructions for setting up the connection pools. For more information about the procedures in this section, see the online help provided with the GlassFish Admin Console.
Perform the following steps to define database connectivity through the application server:
If you are using an Oracle database, you need to manually install or copy the database driver to the application server environment. If you are using a SQL Server database, you can skip this step.
You can either install the Oracle driver on the application server or copy the ojdbc14.jar file from your Oracle client installation (Oracle_client\jdbc\lib) to app_server_home\lib. To install the driver, see the documentation for the GlassFish Application Server.
Once the driver is installed or copied, continue to Step 2: Create the JDBC Connection Pools.
The JDBC connection pools provide connections for the master index database. Before proceeding, make sure you have the relevant information about the master index database (such as the database name, URL, and administrator login credentials).
Before You Begin
If you are using an Oracle database, be sure to add the database driver to the application server environment, as described in Step 1: Add the Oracle Driver to the Application Server.
You can access the console from the Services window in NetBeans.
Note - You can use either javax.sql.DataSource or javax.sql.ConnectionPoolDataSource.
URL – The URL that points to the database. The syntax of the URL is:
For Oracle, jdbc:oracle:thin:@host:port:database_name.
For SQL Server, jdbc:sqlserver://server:port;databaseName=database
user – The login ID for the user you created in Step 2: Create a Master Index Database and User (Repository).
password – The password for the above user.
ImplicitCachingEnabled – An indicator of whether implicit statement caching is enabled. Set this property to true.
MaxStatements – The maximum number of statements in the cache. Set this property to 1000.
A JDBC resource (also known as a data source) gives the master index application the ability to connect to the database. You need to create one for each connection pool created earlier.
Before You Begin
Create the JDBC connection pool, as described in Step 2: Create the JDBC Connection Pools.
The name must be in the form jdbc/application_nameDataSource, where application_name is the name of the master index application. For example, jdbc/PersonDataSource.
For the connection pool, select the second connection pool you created in Step 2: Create the JDBC Connection Pools.
The name of the resource must be in the form jdbc/application_nameSequenceDataSource, where application_name is the name of the master index application. For example, jdbc/PersonSequenceDataSource.