Prerequisites: Machine must be a Windows machine, and must have access to the internet (in order to access the database)

1. Download Files

a. Download Weblogic Platform 7.0

i. platform701_win32.exe

b. Download JDBC files

i. JDBC.zip

c. Download Application

i. arsSystem.zip

2. Install BEA WebLogic Server

a. Double click ”platform701_win32.exe” from WebLogic download

b. Click “next”

c. Select “Yes” (Accept License)

d. Click “next”

e. Leave “BEA Home” as Default directory (C:\bea)

f. Click “next”

g. Select “Typical Installation”

h. Click “next”

i. Leave “Product Installation Directory” as default directory (C:\bea\WebLogic700)

j. Click “next”

k. Deselect “Run QuickStart

l. Click “Done”

3. Configure Domain

a. Run configuration wizard: StartàprogramsàBEA WebLogic Platform 7àDomain Configuration Wizard

i. Choose “WLS Domain”

ii. Leave domain name as mydomain

iii. Click “next”

iv. Choose “Single Server”

v. Click “next”

vi. Leave domain directory as default “c:\bea\user_projects\

vii. Click “next”

viii. Server name “myserver”

ix. Server listen address: LEAVE BLANK

x. Server listen port “7001”

xi. Server SSL Listen Port “7002”

xii. Click “next”

xiii. Enter username “ars”

xiv. Enter Password “airlinears”

xv. Click “next”

xvi. Select “No”

xvii. Click “next”

xviii. Select “Yes”

xix. Click “next”

xx. Click “Create”

xxi. Select “End Configuration Wizard”

xxii. Click “Done”

4. Configure WebLogic Classpath

a. Change ClassPath in startWLS.cmd

i. Right click on C:\bea\WebLogic700\server\bin\startWLS.cmd

ii. Select “edit”

iii. Look for “set CLASSPATH=%JAVA_HOME%...”

iv. Paste “set CLASSPATH=%JAVA_HOME%\lib\tools.jar;%WL_HOME%\server\lib\WebLogic_sp.jar;%WL_HOME%\server\lib\WebLogic.jar;C:\Javalibs\SqlServerJDBC\msutil.jar;C:\Javalibs\SqlServerJDBC\mssqlserver.jar;C:\Javalibs\SqlServerJDBC\msbase.jar;%CLASSPATH%” over existing set CLASSPATH statement and save file

5. Install JDBC driver files

a. Create “C:\Javalibs\SqlServerJDBC\” directory

b. Unzip JDBC.zip into this directory (from download)

6. Start Web logic server

a. Start à Programs à BEA WebLogic platform 7.0 à user projects à mydomain à start server

b. Enter username and password when prompted

c. Wait until you see “<Server started in RUNNING mode>” in command prompt

7. Start Admin Consol

a. Start à Programs à BEA WebLogic platform 7.0 à WebLogic Server 7.0 à Server Tour and Examples à Start admin console (must have browser that can run applets)

b. Enter username and password

c. Create connection pool

i. Select “Connection Pools”

ii. Select “Configure a new JDBC Connection Pool”

iii. Enter configuration information

a. Name: arsConnectionPool

b. URL: jdbc:microsoft:sqlserver://msepc12.sp.cs.cmu.edu:1433

c. Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

d. Properties: “user=analysis

databaseName=airlinedb”

e. Leave “ACLName” blank

f. Password: analysis

g. Leave “Open String Password” blank

h. Click “Create”

iv. Select “Connections” tab

a. Change maximum capacity to 10

b. Click “apply”

v. Select “Targets” tab

a. Set myserver as chosen

b. Click “apply”

d. Create Data Source

i. In Admin console on left frame go to mydomain à Services à JDBC à Data Sources

a. Select “Configure a new JDBC Data Source”

b. Enter

i. Name: arsDataSource

ii. JNDI Name: arsDB

iii. Pool Name: arsConnectionPool

c. Click “create”

d. Select “Targets” tab

i. Set myserver as chosen

ii. Click “apply”

e. Configure Startup Class

i. In the left frame select mydomain à Startup & Shutdown

ii. Select “Configure a new startup class” in right frame

iii. Enter the following:

a. Name: ARS Startup Class

b. ClassName: common.start.ArsStartup

c. Arguments: NamingService=//[IP of Naming service]/God,CreditCard=//[IP of credit card service]/CreditCard

iv. Select “Apply”

v. Select the “Targets” tab

vi. Move “myserver” to chosen side

vii. Select “Apply”

8. Deploy application

a. Unzip arsSystem.zip

b. Put ars.jar into C:\bea\user_projects\mydomain\applications\

9. Restart Server

a. If Server command window is open

i. start the admin console (if not already open)

a. Start à Programs à BEA WebLogic platform 7.0 à WebLogic Server 7.0 à Server Tour and Examples à Start admin console

ii. select mydomain à Servers à myserver (from admin console left frame)

iii. right click "myserver" and select "Start/stop this server..."

iv. click "Shutdown this server..." on the right pane

v. click "yes" to confirm

b. Start Server: Start à Programs à BEA WebLogic platform 7.0 à user projects à mydomain à start server

i. Enter username and password when prompted

10. Start Application

a. Double click clientARS.bat (from arsSystem.zip. clientARS.bat assumes that client.jar is in the same directory.)