| Oracle® Insurance Rules Palette Version 8.1 Installation Instructions

Oracle® Insurance Rules Palette

Installation Instructions

Rules Palette Release 8.1

E14404-01

May 2009

Oracle® Insurance Rules Palette Release V8.1
Copyright Â© 2009, Oracle. All rights reserved.

License Restrictions & Warranty Disclaimer

The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.

The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.

Restricted Rights Notice

U.S. GOVERNMENT RIGHTS

Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.

Third Party Web Sites, Content, Products, and Services Disclaimer The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.
Trademark Notice

Oracle, JD Edwards, and PeopleSoft are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

The latest release of the Rules Palette is available via Oracle E-Delivery. After you have downloaded the zip file to your local computer, unzip the file into the following folder:

- C:\Program Files\OracleInsurance\RulesPalette

Note: You may need to create a folder called Rules Palette within C:\Program Files\OracleInsurance if one does not already exist.

Downloading the Necessary jar Files

Before launching the Rules Palette, you must download the necessary proprietary and open source executable jar files required to successfully launch and operate the Palette.

It is recommended that a temporary subdirectory be created to house the downloaded zip files.

The files needed include:

Open Source – These files are mandatory regardless of what type of database you are using.

1. hibernate-3.2.1

2. hibernate-annotations

3. hibernate-tools

4. jaxen-1.1-beta-7

Proprietary – These files may or may not be required dependant on what type of database you are using.

5. db2jcc

6. db2jcc_license_cisuz

7. db2jcc_license_cu

8. jtds

For some of the following downloads, you need to ensure the operating system being used allows the display of file extensions. You will be renaming some file extensions in the instructions below (ie. In Windows, select Tools, Folder Options, View and ensure the setting hide extensions for known file types is NOT checked).

1-3) Download hibernate-3.2.1, hibernate-annotations, and hibernate-tools from the

following site:

http://www.hibernate.org/ (Click the “Download” link on the left.)

- hibernate-3.2.1

  - From the Download page, click the “Browse all Hibernate downloads” link.

  - Scroll down and click on the “hibernate3” package link..

  - Download the file for version 3.2.1.ga.zip and save to the temporary directory created

    to store the zip files.

  - Extract the hibernate3.jar file from the hibernate-3.2 folder of the zip file.

  - Rename this file hibernate-3.2.1.jar and copy into the directory C:\Program

    Files\AdminServer\RulesPalette\asgraphicruleside\modules\ext

- hibernate-annotations

  - From the Download page, click the “Browse all Hibernate downloads” link.

- Scroll down and click on “hibernate-annotations” package link .

- Download the file for version 3.2.1.GA.zip and save to the temporary directory

  created to store the zip files.

- Extract the hibernate-annotations.jar file from the hibernate-annotations-3.2.1GA folder of the zip file and copy into the directory C:\Program Files\AdminServer\RulesPalette\asgraphicruleside\modules\ext

- hibernate-tools

  - From the Download page, click the “Download” link next to Hibernate Tools under the Binary Releases heading.

  - This will take you to a page that will allow you to downloading the latest version. Save the file to the temporary directory created to store the zip files.

  - Open the downloaded zip file and extract the hibernate-tools.jar from the following folder:

    \plugins\org.hibernate.eclipse_3.2.2.Beta1\lib\tools\

    (if the version downloaded was 3.2.2.Beta1)

  - Copy the jar file into the directory C:\Program

    Files\AdminServer\RulesPalette\asgraphicruleside\modules\ext

4) Download jaxen-1.1-beta-7.jar from the following site:

http://www.ibiblio.org/maven/jaxen/jars/

- When downloading, the file may automatically be saved as a .zip file even though the file you are downloading is a .jar file. If this occurs, simply rename the file to ensure the extension is .jar.

- Copy the jar file into the directory C:\Program

  Files\AdminServer\RulesPalette\asgraphicruleside\modules\ext

IMPORTANT: You will only need db2jcc, db2jcc_license_cisuz, and db2jcc_license_cu jar files if you are running a DB2 database.

5-7) db2jcc, db2jcc_license_cisuz, and db2jcc_license_cu are included with the
purchase of the DB2 software. These files are not available for download.

(contact your IT department if you need assistance locating these files.)

Note: Make sure to note the exact location to which you save
the files, as you will need it when you set up your environment connections

IMPORTANT: You will only need the jtds jar file if you are running a SqlServer database.

8) Download jtds from the following site:

http://sourceforge.net/projects/jtds/

- Click on the "Download jtds – SQL Server and Sybase JDBC driver" link

- Scroll down to the area that lists the previous File Releases and download the distribution file for

  version 1.2 (jtds-1.2-dist.zip). Save the download zip file to the temporary directory created to store the zip files.

- Open the downloaded zip file and extract the file jtds-1.2.jar from the root of the zip file.

- Rename this file as jtds.jar

Note: Make sure to note the exact location to which you save
the file, as you will need it when you set up your environment connections.

Now that all the appropriate files have been extracted to their destination directory, the temporary folder created to house the zip files may be deleted.

You may now proceed to launching the Rules Palette application.

Launching the Rules Palette via Executable File

Once unzipped, the executable file asgraphicruleside.exe can be used to run the Rules Palette. To launch the application, double-click on the executable file. This executable file can be found in the following directory:

- C:\Program Files\AdminServer\RulesPalette\bin

Note: Once you launch the Rules Palette, make sure to delete any old/existing environments.

Refer to the Rules Palette User Guide for information on setting up environment connections for and operating the Rules Palette.

Create a Shortcut on the Windows XP Desktop

There are two options to create a shortcut in Windows. One option to create shortcut is to select “Create Shortcut” on the right-click on the executable menu. Another option to create a shortcut is to right-click on the Windows Desktop.

Option 1

Right-click on the asgraphicruleside.exe file in the following folder:

- C:\Program Files\AdminServer\RulesPalette\bin

Select Create Shortcut option and follow the Windows wizard instructions.

Option 2

To create a shortcut on your desktop, right-click on an empty area of the desktop and select New > Shortcut. Either browse to the executable file or copy the following path in the Shortcut Wizard:

- C:\Program Files\AdminServer\RulesPalette\bin\asgraphicruleside.exe

Refer to the Rules Palette User Guide for information on setting up environment connections for and operating the Rules Palette.

Steps to enable the Stored Procedure Validation

The Palette login process will typically use a hibernate call to validate the login credentials. The Login process for the Palette is now also able to use a Stored Procedure to validate login credentials for cases where the AsSecurity table is not accessible. Use the following steps to enable Stored Procedure Validation:

1. Ensure that the Rules palette is not running. (Close rules palette).

2. Open the Adminserver Rules Palette Release home directory. (this is the extracted folder of release

   reading like AdminServer Rules Palette Release x.x.x.x....).

3. Open folder location asgraphicruleside\modules.

4. Open the “com-adminserver-asideutilities.jar” file with an extract tool (ie.win-rar, winzip (if you

   don't have one installed, it is advisable to download an extract tool).

5. In the opened archive navigate to following location

   1. com\adminserver\asideutilities\resources

6. Open asGraphicRulesIDE.properties file.

7. Set the property “StoredProcedureValidation” to true as follows.

   StoredProcedureValidation = true

8. Close the file and hit yes upon prompt message to save the file and save the file in the archive.

Note: For turning off the stored procedure validation repeat above steps except the property in step 6 would be changed to false, i.e. StoredProcedureValidation = false.