A Setting Up the Development Environment

This appendix describes the development environment for creating applications that use the OLAP API.

This appendix includes the following topics:

Overview
Required Class Libraries
Obtaining the Class Libraries

Overview

The Oracle Database installation, with the OLAP option, provides the OLAP API and other class libraries, as jar files, that you require to develop an OLAP API client application. As an application developer, you must copy the required jar files to the computer on which you develop your Java application, or otherwise make them accessible to your development environment.

Required Class Libraries

Your application development environment must have the following files:

The OLAP API jar file, which contains the OLAP API class libraries.
Certain Oracle JDBC (Java Database Connectivity) jar files, which provide communications between the application and the Oracle database. The Oracle installation includes the JDBC files. You must use these JDBC files and not those from another Oracle product or those from a product from another vender.
The Java Development Kit (JDK) version 1.4. The Oracle installation does not provide the JDK. For information about obtaining and using it, see the Sun Microsystems Java Web site at
```
http://java.sun.com
```

If you are using Oracle JDeveloper as your development environment, the JDK is already installed on your computer. However, ensure that you are using the correct version of the JDK in JDeveloper.

Obtaining the Class Libraries

Table A-1 lists the OLAP API and other jar files that you must include in your application development environment. The table includes the locations of the files under the directory identified by the ORACLE_HOME environment variable on the system on which the Oracle database is installed. You can copy these files to your application development computer, or otherwise include them in your development environment.

Table A-1 Required Class Libraries and Their Locations in the Oracle Installation

Class Library jar File	Location under ORACLE_HOME
`awxml.jar`	`/olap/api/lib`
`olap_api.jar`	`/olap/api/lib`
`ojdbc14.jar`	`/jdbc/lib`
`xmlparserv2.jar`	`/lib`

The awxml.jar file contains the Oracle Analytic Workspace Java API classes. Those classes are required to compile the example program that defines and builds the analytic workspace that is used by all of the other example programs. The olap_api.jar file contains the OLAP API classes. The ojdbc14.jar file contains JDBC classes required to connect to an Oracle Database instance and the xmlparserv2.jar file contains classes that provide XML parsing support.

The ORACLE_HOME/olap/api/lib directory also contains the olap_awxml_doc.jar olap_api_doc.jar files. Those files contain the Oracle OLAP Analytic Workspace Java API Reference and the Oracle OLAP Java API Reference, respectively. You can add those files to your IDE to get online help for the APIs.