2 Getting Started with the Application

2.1.1 Oracle Database Server

To develop the Java application, you need a working installation of Oracle Database Server with the HR schema, which comes with the database. If you choose to install the client, then you must install the Oracle Database Server before the Oracle Database Client installation. The installation creates an instance of Oracle Database and provides additional tools for managing this database. The server installation is platform-specific. For more information, refer to the following Oracle Database installation guides and release notes:

• Oracle Database Installation Guide 11g Release 2 (11.2) for Linux

• Oracle Database Installation Guide 11g Release 2 (11.2) for Microsoft Windows

DROP TRIGGER HR.UPDATE_JOB_HISTORY;
DROP TRIGGER HR.ADD_JOB_HISTORY;
DROP TRIGGER HR.SECURE_EMPLOYEES;
ALTER TABLE EMPLOYEES  DROP CONSTRAINT JHIST_EMP_FK;
DELETE FROM JOB_HISTORY;

2.1.2 Oracle Database Client

Oracle Database Client installation is optional, but recommended. Installing Oracle Database Client on any computer allows easy access from that system to the Oracle Database. The installation also includes the following development tools:

• Oracle JDBC drivers

• Oracle Open Database Connectivity (ODBC) driver

• Oracle Provider for OLE DB

• Oracle Data Provider for .NET (ODP.NET)

• Oracle Services for Microsoft Transaction Server

The client installation is platform-specific. Refer to the following Oracle Database Client installation guides for more information on installing the client:

• Oracle Database Client Installation Guide 11g Release 2 (11.2) for Linux

• Oracle Database Client Installation Guide 11g Release 2 (11.2) for Microsoft Windows

2.1.3 J2SE or JDK

To create and compile Java applications, you need the full Java 2 Platform, Standard Edition, Software Development Kit (J2SE SDK), formerly known as the Java Development Kit (JDK). To create and compile applications that access databases, you must have the full JDBC API that comes with J2SE. This download also includes the Java Runtime Environment (JRE).

2.1.4 Integrated Development Environment

For ease in developing the application, you can choose to develop your application in an integrated development environment (IDE). This guide uses Oracle JDeveloper to create the files for this application. For more information on installing JDeveloper, refer to Installing Oracle JDeveloper.

2.1.5 Web Server

The sample application developed in this guide uses JavaServer Pages (JSP) technology to display information and accept input from users. To deploy these pages, you need a Web server with a servlet and JSP container, such as the Apache Tomcat application server.

This guide uses the embedded server called the Oracle WebLogic Server in JDeveloper for deploying the JSP pages. If you choose not to install Oracle JDeveloper, then any Web server that allows you to deploy JSP pages should suffice.

JDeveloper supports direct deployment to the following production application servers:

• Oracle WebLogic Server

• Oracle Application Server

• Apache Tomcat

• IBM WebSphere

• JBoss

For more information about these servers, please refer to vendor-specific documentation.

2.2.1 Checking Installed Directories and Files

Installing Oracle Java products creates the following directories:

• ORACLE_HOME/jdbc

• ORACLE_HOME /jlib

Check if the directories described in Table 2-1 have been created and populated in the ORACLE_HOME directory.

2.2.2 Checking the Environment Variables

This section describes the environment variables that must be set for the JDBC Thin Driver. You must set the classpath for your installed JDBC Thin Driver. For JDK 5, you must set the following values for the CLASSPATH variable:

Ensure that there is only one JDBC class file, such as ojdbc6.jar, and one globalization classes file, orai18n.jar, in the CLASSPATH variable.

2.2.3 Determining the JDBC Driver Version

Starting from Oracle Database 11g Release 1, you can get details about the JDBC support in the database as follows:

> java -jar ojdbc6.jar
  Oracle 11.1.0.0. JDBC 4.0 compiled with JDK6

In addition, you can determine the version of the JDBC driver that you installed by calling the getDriverVersion method of the OracleDatabaseMetaData class.

Example 2-1 illustrates how to determine the driver version:

import java.sql.*;
import oracle.jdbc.*;
import oracle.jdbc.pool.OracleDataSource;

class JDBCVersion
{
  public static void main (String args[]) throws SQLException
  {
    OracleDataSource ods = new OracleDataSource();
    ods.setURL("jdbc:oracle:thin:hr/hr@localhost:1521/XE");
    Connection conn = ods.getConnection();

    // Create Oracle DatabaseMetaData object
    DatabaseMetaData meta = conn.getMetaData();

    // gets driver info:
    System.out.println("JDBC driver version is " + meta.getDriverVersion());
  }
}

2.3.1 JDeveloper Studio Edition: Base Installation and Full Installation

JDeveloper 11.1.1 is available in two editions. The Studio Edition includes Oracle ADF, which is required for developing the master-detail application created in this guide.

You can install either the base installation or the full installation of the JDeveloper Studio Edition. In addition to JDeveloper, the full installation includes the required version of Java, the specialized Oracle Java Virtual Machine for JDeveloper (OJVM), and the online documentation, so the download file size is larger. For quicker downloading, you can install the JDeveloper base installation.

2.3.2 Steps to Install JDeveloper

If you are installing the base installation, you need to have J2EE version 1.6.0_05 on your machine. If you are installing the full installation, then J2EE is included. In outline, the installation process is as follows:

1. Download JDeveloper version 11.1.1 Studio Edition from the Oracle Technology Network at

   http://www.oracle.com/technology/software/products/jdev/htdocs/soft11.html

   Download the base installation (jdevjavabase11110.zip), or the full installation (jdevstudio11110install.exe ). It is recommended that you download the Studio Edition to avail all features.

2. To launch the installer for the base installation, enter the following command at the command line:

   java -jar jdevstudio11110install.jar

   To launch the installer for the full installation, double click jdevstudio11110install.exe and follow the instructions.

   Note:

   When choosing the Middleware Home directory, ensure that you choose a directory that does not contain spaces. For example, do not use C:\Program Files as the Middleware Home.

   To change a JDK location that you have previously specified, you have to modify the jdev.conf file. Set the variable SetJavaHome in the file <install_dir>/jdeveloper/jdev/bin/jdev.conf to the location of your Java installation. Here, Middleware Home directory has been represented by <install_dir>.For example, in a UNIX environment, if the location of your JDK is in a directory called /usr/local/java, your entry in jdev.conf would be as follows:

   SetJavaHome /usr/local/java

   Other tasks that you must perform include setting the permissions for all JDeveloper files to read, and giving all users write and execute permissions to files in a range of JDeveloper directories.

3. If you are using the base installation, there are some additional setup tasks, such as setting the location of your Java installation in the JDeveloper configuration file, optionally installing OJVM, and downloading the online documentation so that it is locally available.

2.3.3 Starting JDeveloper

To start JDeveloper on Windows, click on Start, select All Programs, then select Oracle Fusion Middleware and select JDeveloper Studio 11.1.1.0.0. You can also run the <install_dir>\jdeveloper\jdev\bin\jdevw.exe file. To use a console window for displaying internal diagnostic information, run the jdev.exe file in the same directory instead of jdevw.exe.

To start JDeveloper on other platforms, run the <install_dir>/jdeveloper/jdev/bin/jdev file.