Instructions For Installing the HR and OE sample schemas

Overview

These instructions describe how to install the "HR" and "OE" sample schemas used in the Oracle9i JDeveloper Sample Applications

Requirements

You must have Oracle9i JDeveloper Production Release 903 and access to an 8.x database or higher.

Database Setup: HR and OE Installation

The JDeveloper samples are based on the Oracle9i Sample Schemas which are included with Oracle9i. If you are using Oracle 8i you will have to install the appropriate version of the sample schemas.

Contained within Oracle9i JDeveloper are SQL scripts which will install the hr and oe sample schemas onto an 8i database.These scripts are provided with JDeveloper under the <jdev_install>/jdev/tutorials/sample_schema_scripts

Further info is provided in the JDeveloper Help documentation.
See:

-> Tutorials
----> Creating and Populating the Sample Schema Tables
--------> About Installing the Oracle 8i Sample Schemas

Important: Setting Up Connection Names in JDeveloper

Once the hr and oe schemas have been installed on the database, you will have to create JDBC connections to these new schemas. The connection names have to be defined as "hr_conn" and "oe_conn". This is an important step because the other sample applications* will use the same JDBC connection names to access these schemas.

To establish JDBC connections to the hr and oe:

1. In the JDeveloper Navigator locate the "Database" node located in the "Connections" node.
2. Right-click on "Database" and select "New connection..."
3. In step 1 of the wizard enter hr_conn as the connection name.
   Accept the default JDBC connection type and click "Next".
   
4. In step 2 enter the following values:
   username = hr (or hr8/hr8 if using 8i version)
   password = hr
   role = <can leave blank>
   
   Check the "Deploy Password" checkbox. This is important or your apps will not have the connection information.
   
5. Answer the remaining questions and dismiss the wizard to establish a connection to your database. Once this step is completed, your bc4j projects will be able to connect to your installation of the hr schema.
   
   
6. Repeat these steps to create another connection for the oe schema. For this connection use the connection name, oe_conn.

You may now run the other Oracle9i JDeveloper samples which make use of the HR and OE schemas.

*The Online Orders sample application uses it's own connection and schema.