
Design and Implementation of wireless data application: eCare
--------------------------------------------------------------

The following files are associated with this project:

proj.hdml
inpsh.cgi (calls eCare.java)
eCare.java
main.hdml
min.cgi, call.cgi
billnew.cgi (calls pay.cgi)
pay.cgi (calls payNow.java)
payNow.java
output file: billinfo.out

sql scripts:
create tablespace: ecaretbs.sql
create table billinfo: billinfo.sql
add data (subscribers) to table: ecareData.sql

some dbf files associated with oracle storage of data

Steps to implement:
--------------------
System configuration:
- unix Sun Sparc 20 (upgrade to Ultra 2)
- Solaris 2.6
- client: PC : tested with Windows 95 (via 56k dialup connection frm home)
		           NT4.0 (desktop at work over Ethernet connection) 

Server side:
- install a web server (such as netscape suitespot enterprise server 3.5.1)
- install Oracle RDBMS (7.3.2.3)
- download and install JDK 1.1.4
- download and install oracle JDBC thin drivers (from oracle web site) vs. 1.2
-configure web server to serve cgi scripts (say from cgi-bin)
- set up paths for ORACLE, JDK and JDBC Class and libraries
- configure the unix machine to run kshell

Client side:
- download and install Unwired Planet's UPSDK2.0.2
- ability to run UP.Phone simulator browser from the client

to run the scripts:
- use the .sql files to create tablespace, tables and insert subscriber data
- create directories hdml,  within the webserver publisher tree
- create hdml/cgi-bin and hdml/cgi-bin/jdbc-bin directories
- the hdml files must be in the hdml directory
- all other scripts in jdbc-bin directory

call me on 512 372 5417 or email lalitha@tri.sbc.com if need help in configuring/ installing / executing this.

Thanks.
Lalitha
