Installation and Configuration Guide for OTN Financial Brokerage Service Application

Date : 01-SEP-2003


Table of Contents

Introduction
Software Requirements
Terminology
Configuring the Application
Deploying the Application using OC4J and ANT
Using the Application
Cleaning up the Installation
Troubleshooting the Installation


Introduction

This document will guide you through the steps used to install and configure the OTN Financial Brokerage Service Application. You will also find instructions on putting the application to use, cleaning up post installation and troubleshooting tips. The installation section is purposely minimal; merely the quick and dirty steps needed to get up and running (if you need more information on the sample application, refer to the ReadMe and tutorials).

Software Requirements

There are, at the minimum, three software packages you'll need in order to get up and running. These are as follows (in the order they are explained, not the order they are installed):

Terminology

Term Description
The directory where the source files of the sample have been extracted to. For e.g., C:\ibfbs, if the sample was unzipped to C:\
The root folder of your OC4J installation. ex D:\oc4j10g

Configuring the Application

Step 1: Execute the following command to extract the source files:

>jar xvf fbs.jar

All the files are extracted into the ibfbs directory. Click here to view the directory structure and description of sample files.

Step 2: Connect to your database as Sys or System user and create a new user by executing the following command.

SQL>Grant connect,resource to ibfbs identified by ibfbs;

This will create a database user with username: ibfbs and password: ibfbs. All the sample tables and data required by this application will be created/stored in this schema.
Step 3: Edit <SAMPLE_HOME>/config/META-INF/data-sources.xml and alter the value of 'url' and provide the Database hostname, port and SID.

       url="jdbc:oracle:thin:@<hostname>:<port>:<sid>"

Step 4: Edit <SAMPLE_HOME>/config/Connection.properties and alter the properties based on the comments mentioned above each of them.
Step 5: Edit <OC4J_HOME>/j2ee/home/config/jms.xml and add the following tags within <jms-server> tag.

<queue name="Exchange Queue" location="jms/ExchangeQueue">
  <description>FBS Exchange Queue</description>
</queue>

<queue name="Alert Queue" location="jms/AlertQueue">
  <description>FBS Alert queue</description>
</queue>

<queue-connection-factory name="jms/ExchangeQueueConnectionFactory"  location="jms/ExchangeQueueConnectionFactory"/>

<queue-connection-factory name="jms/AlertQueueConnectionFactory"  location="jms/AlertQueueConnectionFactory"/>

Step 6: Edit <SAMPLE_HOME>/build.xml and alter the value of 'oc4j.home' property to that of <OC4J_HOME>

Deploying the Application to OC4J using ANT

Step 1 :

Run ANT to build the EAR (from <SAMPLE_HOME>)

>ant make

Step 2 : Start the OC4J Server (from <OC4J_HOME>/j2ee/home, in a separate command-line window)

>java -Ddefault.cmp.pm=native_cmp -DassociateUsingThirdTable=true -jar oc4j.jar -userThreads

Note: You will have to start OC4J each time with this option, else the application data will be corrupted and needs to cleaned and redeployed.

Step 3 : Run ANT to deploy the FBS application (from <SAMPLE_HOME>)

>ant deploy

(Provide the oc4j hostname and admin details when prompted)

Using the Application

Using your favorite browser, go to http://<hostname>:8888/ibfbs/controllerservlet to run the application.

The Web Service endpoint URL is http://<hostname>:8888/fbsws/StockQuoteServicePort

A default admin account will be created with account number : 1 and password : welcome

To understand the roles, application architecture and the description of the sample application files, refer Readme.html. To learn how to browse the application, refer UsingFBS.html.

Cleaning up the Installation

Step 1 :

Start the OC4J Server (from <OC4J_HOME>/j2ee/home, in a separate command-line window)

>java -Ddefault.cmp.pm=native_cmp -DassociateUsingThirdTable=true -jar oc4j.jar -userThreads

Step 2 : Run ANT to undeploy the application (from <SAMPLE_HOME>)

>ant undeploy

(Provide the oc4j hostname and admin details when prompted)

Note: Restart OC4J Server once the application is undeployed.
Step 3 :

To cleanup the tables and sample data created by the application, connect to your database as Sys or System user and drop the user by executing the following command.

SQL> drop user ibfbs cascade;

Troubleshooting the Installation

Troubleshooting some of the common problems which may occur while deploying the sample. If you donot find the error message here, please post a message in OTN Sample Code discussion forum.


Problem : While deploying the sample the below error message appears

SQL error: Io exception: The Network Adapter could not establish the connection

Action : Check the parameters url,username and password in <SAMPLE_HOME>/config/META-INF/data-sources.xml. If any of the value is invalid, alter it, do a cleanup and redeploy the application.


Post your comments/feedback on this sample application on OTN Sample Code discussion forum.

 


E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy