Oracle COM Automation for Java README

************************************************************************

Copyright (C) 2000 Oracle Corporation, All rights reserved.


This document discusses the necessary steps that must be followed in order
to install and configure the COM Automation for Java Feature.  For the most
up-to-date information, please see Oracle COM Automation Developer's Guide.

Oracle COM Automation for Java Feature includes the following components:

* COM Automation for Java Feature (orawcom.dll)
* COM Automation Java classes (orawcom.jar)
* An Oracle to Microsoft Word data exchange solution

System Requirement
===================
The Oracle COM Automation for Java Feature requires the following:

* Oracle 9i Database
* Windows NT 4.0 or Windows 2000

Installation
============
The following steps detail how to install the COM Automation 
for Java Feature.

* Open a MS-DOS command prompt.

* Change the directory to com\java.

    cd ORACLE_BASE\ORACLE_HOME\com\java

* Load the COM Automation Java classes into the desired database schema
  using the loadjava tool.  For example:

    loadjava -force -resolve -user hr/hr orawcom.jar

Solutions for Oracle COM Automation for Java Feature
====================================================
As part of Oracle COM Automation for Java Feature, several solutions 
are provided to give developers an idea of how to use the COM Automation 
for Java Feature to build solutions.  These solutions provide base 
functionality.  They are provided as both examples as to how to use the 
COM Automation for Java Feature and as a foundation upon which to build 
more customized, complex applications that use COM Automation for Java.


Microsoft Word Solution
-----------------------
The following sections detail how to install the Microsoft Word Solution 
and describe the Application Programming Interfaces (APIs) that it exposes.  
This solution is provided as an example of the types of solutions that can 
be built with Oracle and Microsoft Word.

The Microsoft Word Solution provides a Java class (TestWORD) for 
manipulating Microsoft Word.  Also, the Microsoft Word Solution includes 
a static method in that Java class to demonstrate the capabilities of 
exchanging data between Oracle and Microsoft Word.  The test static method
exchanges data from the employees table in Oracle to a Microsoft 
Word document.  A developer should invoke this static method after 
installing the solution.

This demo relies on the human resources schema in the common schema.

Microsoft Word Solution Installation

The following steps detail how to install the Microsoft Word Solution.  
Microsoft Word must be installed on the local machine for this solution to 
work properly.

* Open a MS-DOS command prompt.

* Change to the com\java\demos directory.

    cd ORACLE_BASE\ORACLE_HOME\com\java\demos

* Load the TestWORD Java classes into the desired database schema using
  the loadjava tool.  For example:

    loadjava -force -resolve -user hr/hr TestWORD.class

* Connect to the database using SQL*Plus.  For example:

    sqlplus hr/hr

* From the SQL*Plus prompt, create the call spec.

    @TestWORD.sql

Using the Microsoft Word Solution

The following steps detail how to execute the Microsoft Word solution.

* Open a MS-DOS command prompt.

* Connect to the database using SQL*Plus.  For example:

    sqlplus hr/hr

* Allow SQL*Plus to display output from the Java program.

    set SERVEROUTPUT on

* Invoke the Java code.  This code will create a Word document 
  (worddemoj.doc) in the c:\.  The document will contain data 
  from the employees table.

    call TestWORD();

* Open the worddemoj.doc to see its content.

Known Bugs
==========
At present, a developer cannot call COM Automation method that displays a 
window, message box, or dialog box.  

The workaround is to avoid calling methods that display such dialog boxes.  
For example, the Microsoft Excel solution appends the time stamp to the 
filename (e.g. excelxxxxx.xls) to ensure that no two files are named the 
same.  Excel displays an overwrite dialog box, if a file has the same name, 
when you attempt to save it using COM Automation.  Microsoft Word does not 
do this.