Installing OPA-JAVA on WINDOWS

Hardware, Operating System and Networking Requirements

* Pentium III PC with 733 MHz CPU, or higher

* 512 MB RAM, or higher

* 10 GB free hard disk space

* Window 2000/2003 Server Operating System

* Access to Internet with lease line and broadband connection

Software Prerequisites

Software Components

1. Java (tm) 2 SDK, Standard Edition - version 1.4.2 or higher.

Download it at:      http://java.sun.com/j2se/1.4.2/download.html   

Download and/or follow the installation instructions

2. TOMCAT 5 or higher

Download it from: http://jakarta.apache.org/tomcat/index.html

3. Java Web Services Developer Pack 1.5 or higher  

Download it from: http://java.sun.com/webservices/    

Download and/or follow the installation instructions. Use TOMCAT as the container.

4.MySQL Version 4.1.x  Database Server

Download it at:

http://www.mysql.com  .Download and/or follow the installation instructions.

Also download the JDBC driver(s) for MySQL - mysql-connector-java-3.0.x-stable-bin.jar -

where 'x' is 8,9,10,11, etc. You may have to try one or more of them to find the one that

works for your installation. Download all and delete those not needed later.

5. Web Browser

Internet Explorer Version 6.0 or higher;

or Netscape 7.0 or higher; or FireFox 1.0 or higher

6. Download OPA 

There are usually two zip files: the main application file and the help file. Download both

Important: Install required software in the order shown above, except for Web Browser 

which probably was installed with the Operating System. 

=======================================================================================

OPA-JAVA Installation 

=======================================================================================

1. Unzip the zip file to some temporary folder. 

2.Copy the MySQL driver ("mysql-connector-java-3.0.x-stable-bin.jar") downloaded above

to     <JWSDP HOME>\common\lib\

* <JWSDP HOME> is the Java Web Services Developer Pack home folder 

If there is difficulty connecting to the OPA database, it may be related to the

version of the driver. Download and try versions until you get the one that works 

for your installation.

3. Copy the archive contents as follows:

=======================================================================================

database\     Folder

=======================================================================================

This folder contains the SQL scripts for creating tables and populating those 

needed for initial startup. To run these scripts

1. Create the OPA-JAVA database

      Start DOS Command Prompt 

      Change directory to the directory <MYSQL HOME>\bin

      Enter the command "mysql -u root -p"  and hit Enter. 

      Hit Enter again without entering a password.

      Enter "create database opa;"  and hit Enter

      Enter "use opa;" and hit Enter

a. Run the create_db.sql script 

Enter "source /folder/create_db.sql;"     where /folder/ is the path to 

the location of the SQL scripts.  Hit Enter.  The database tables are created.

NOTE: If your database is not named 'opa', edit the script and substitute the proper name.

b.   In similar fashion run all the scripts in \database\data_inserts folder. 

These scripts insert initial data in the database like languages, phrases, and default values.

=============================================================================================

opa\     Folder

==============================================================================================

This folder contains the OPA application files.

Copy "opa" subdirectory and paste as a subdirectory of <JWSDP HOME>\webapps\

The OPA directory now looks like

  \opa\

  \opa\admin\

   \opa\archive\

and so on.

=============================================================================================

Help Files     

==============================================================================================

Unzip the help zip file to some temporary folder.

Copy its content to

  \opa\help\html\ 

where \opa\ is your application folder. 

=============================================================================================

           opa.xml  file. 

=============================================================================================

This is the configuration file for OPA Application

Copy this file to <JWSDP HOME>\webapps\  folder.

Edit  the file using a text editor.

Use the  "path" and "docBase "  attributes to define the path to OPA application.

Example: path="/opa" docbase="opa" if your OPA application directory root is "opa".

Edit the database connections attributes. 

For example if you are hosting you application on "localhost" and your database name is 

"opajava" and your user id is "root" and you have no password, this section will look like:

     <parameter>

        <name>url</name>

        <value>jdbc:mysql://localhost/opajava</value>

      </parameter>

      <parameter>

        <name>username</name>

        <value>root</value>

      </parameter>

      <parameter>

        <name>password</name>

        <value></value>

      </parameter>

Save opa.xml.

If TOMCAT does not appear to recognize your application, edit /conf/server.xml. 

Copy the contents of opa.xml into the section between the <Logger> tag and the </Host> tag.

===========================================================================================

1. Restart your computer.

2. Start Tomcat Servlet Container and Web Server

 At the DOS prompt (Assume c:>

C:> cd <JWSDP HOME>\bin  <enter>

C:><JWSDP HOME>\bin >catalina start  <enter>

This starts the services needed to serve the web pages

3. Start OPA as Administrator/Reviewer

          Start your Web Browser (Internet Explorer, Netscape , ...)

           Enter on the address line:

                http://localhost:8080/opa/admin   (if using localhost)

http://nnn.nnn.nnn.nnn:8080/opa/admin   (if using IP Address   nnn.nnn.nnn.nnn)

http://abc.com:8080/opa/admin   (if using Web Address abc.com)

       Start OPA as Public User

          Start your Web Browser (Internet Exploree, Netscape , ...)

           Enter on the address line:

             http://localhost:8080/opa/(if using localhost)

http://nnn.nnn.nnn.nnn:8080/opa/(if using IP Address nnn.nnn.nnn.nnn)

http://abc.com:8080/opa/(if using Web Address abc.com)