Installing and Running the Flight Finder on Windows NT

July 2000

Installing the Oracle XSQL Servlet

1. Extract XSQL Servlet files to c:\xsql. (You can extract the files to a different directory, but you will have to update several configuration settings which use c:\xsql by default. The Release Notes in the xsql\doc directory provide details.)
2. Edit the file c:\xsql\xsql-wtg.bat. Near the top of this file is a line that sets the JAVA environment variable. Edit this line to specify the path to the Java executable on your machine. Example:
   set JAVA=c:\"program files"\java1.2\jre\bin\java.exe
3. Test your installation by running c:\xsql\xsql-wtg.bat. This bach file sets environment variables, starts Web-to-Go, and requests the following URL:
   START http://localhost:7070/xsql/index.html
If everything is set up correctly, Web-to-Go returns this page:
   
   (This should work, even if your machine is not connected to the Internet. If Internet Explorer displays an alert box, click the "Try Again" button to continue.)
4. If Web-to-Go displays the page shown in the previous step, you have installed the XSQL Servlet correctly. Next, edit the file c:\xsql\lib\XSQLConfig.xml to define a database connection for the Flight Finder. Scroll down to the <connectiondefs> section, then copy and paste the data for the demo connection. Here's the default data:
   <connection name="demo">
  <username>scott</username>
  <password>tiger</password>
  <dburl>jdbc:oracle:thin:@localhost:1521:ORCL</dburl>
  <driver>oracle.jdbc.driver.OracleDriver</driver>
</connection>
   Edit the newly-pasted data to define a connection named fly, with username fly and password fly. You might also have to edit the hostname, port, and SID in the <dburl> tag, depending on how your database is configured. For example, the database might not be on localhost, the listener might not be on port 1521, and the SID might not be ORCL. If your database configuration is unusual, you might also have to enter a different driver in the <driver> tag.
   <connection name="fly">
  <username>fly</username>
  <password>fly</password>
  <dburl>jdbc:oracle:thin:@localhost:1521:ORCL</dburl>
  <driver>oracle.jdbc.driver.OracleDriver</driver>
</connection>
5. Restart Web-to-Go.

Installing the Flight Finder

1. Extract the Flight Finder files to c:\xsql\fly.
2. Use SQL*Plus to run c:\xsql\fly\allFly.sql, which sets up tables, users, etc.
3. Test your installation. Start Web-to-Go (if it's not already running), then point your browser to
   http://localhost:7070/xsql/fly/index.html
   If things are set up correcly, Web-to-Go returns this page:
   
4. Click a link to invoke the Flight Finder on your server in the language of your choice. For example, if you choose to run the Flight Finder in English on Web-to-Go, the server returns a page like this:
   
5. Use the drop-down lists to choose departure and destination cities, then click the button to submit the form. The server will return a page like this:
   
6. Use the drop-down lists to choose a customer name and a flight code, then click OK to book that flight for that customer. The application inserts a record into the database.
   

Configuring Apache

The Oracle XSQL Servlet includes the Oracle Web-to-Go personal Web server for Windows NT. The Flight Finder also runs under Apache with the JServ servlet engine.

1. Install the Oracle XSQL Servlet as described above.
2. Configure Apache and JServ as described in the XSQL Servlet Release Notes (the default location is c:\xsql\doc\relnotes.html).
3. The Flight Finder assumes that Apache is listening on port 80. If you are using a different port, you can either change your Apache setup or edit the URLs in Flight Finder pages (for example, index.html) to request your port.
4. Test your installation. Point your browser to
   http://localhost/xsql/fly/index.html
   If things are set up correcly, Apache returns this page:
   
5. Click a link to invoke the Flight Finder on your server in the language of your choice. For example, if you choose to run the Flight Finder in English, Apache returns a page like this:
   
6. Use the drop-down lists to choose departure and destination cities, then click the button to submit the form. The server will return a page like this:
   
7. Use the drop-down lists to choose a customer name and a flight code, then click OK to book that flight for that customer. The application inserts a record into the database.

< Back to Introduction

Questions or comments? Post a message in OTN's Sample Code discussion forum or send email to the author.

Installing and Running the Flight Finder on Windows NT
Author: Robert Hall, Oracle Corporation
Date: July 2000
Revised: August 2000

This document is provided for information purposes only and the information herein is subject to change without notice. Please report any errors herein to Oracle Corporation. Oracle Corporation does not provide any warranties covering and specifically disclaims any liability in connection with this document.

Oracle is a registered trademark and Enabling the Information Age is a trademark or registered trademark of Oracle Corporation. All other company and product names mentioned are used for identification purposes only and may be trademarks of their respective owners.

Oracle Corporation
World Headquarters
500 Oracle Parkway
Redwood Shores, CA 94065
U.S.A.

Worldwide Inquiries:
+1.650.506.7200
Copyright © Oracle Corporation 2000
All Rights Reserved