This appendix describes the development environment for creating applications that use the OLAP API.
This appendix includes the following topics:
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.
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.
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 |
---|---|
|
|
|
|
|
|
|
|
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.