How to Integrate bankapp with Oracle 8 (XA RM) for a Windows 2000 Platform


	BEA Home \| Events \| Solutions \| Partners \| Products \| Services \| Download \| Developer Center \| WebSUPPORT
	http://www.oracle.com/technology/documentation/index.html \| Site Map \| Search \| PDF Files \| Contact \| Glossary

Tuxedo Documentation \| Tutorials for Developing BEA Tuxedo ATMI Applications \| Local Topics \| Previous Topic \| Next Topic \| Contents

Edit the nt\bankvar.cmd and supply suitable values for the following environment variables:

TUXDIR : Root directory for the BEA TUXEDO system installation

APPDIR : Application directory in which bankapp files are located

ORACLE_HOME : Root directory of the Oracle8 installation

ORACLE_SID : Oracle System ID

BLK_SIZE: Logical block size

DBNAME: default name of the database to be used by database utilities and database creation scripts

DBPRIVATE: indicates whether database is to be opened in share or private mode (yes or no)

FSCONFIG:Universal Device List for database

PATH=%TUXDIR%\bin;%TUXDIR%\include;%TUXDIR%\lib;%ORACLE_HOME%\bin;%PATH%

INCLUDE=%ORACLE_HOME%\rdbms80\xa; %ORACLE_HOME%\pro80\c\include;%include%

NLSPATH=%TUXDIR%\locale\C

PLATFORM=inwnt40

LIB=%TUXDIR%\lib; %ORACLE_HOME%\pro80\lib\msvc; %ORACLE_HOME%\rdbms80\xa; %lib%;

Run the script to set up the environment:
```
>bankvar
```
Edit the TUXDIR\udataobj\RM file as follows:
- Append the following line to the $TUXDIR\udataobj\RM file:
```
Oracle_XA;xaosw;%ORACLE_HOME%\pro80\lib\msvc\sqllib80.lib %ORACLE_HOME%\RDBMS80\XA\xa80.lib
```
  or if Oracle exists over the network:
- Map the machine to a drive, for example, F.
- Append the following line to the $TUXDIR\udataobj\RM file:
```
Oracle_XA;xaosw;f:\orant\pro80\lib\msvc\sqllib80.lib f:\orant\RDBMS80\XA\xa80.lib
```
- Remove any previous entry of Oracle_XA in the RM file>
Build the Transaction Manager Server for Oracle8:
```
cd $APPDIR
buildtms -r Oracle_XA -o TMS_ORA
```

Edit the nt\bankapp.mak file as indicated in the following table.

Task	Value
Specify values for the following environment variables.	TUXDIR=Root directory for the BEA Tuxedo system installation
	APPDIR=Application directory in which bankapp files are located
	RM=Oracle_XA
	ORACLE_LIBS=$(ORACLE_HOME)\PRO80\LIB
	RMNAME=Oracle_XA
	SQLPUBLIC=$(ORACLE_HOME)\PRO80\C\INCLUDE
	CFLAGS=$(HOST) -DNOWHAT=1 $(CGFLAGS) $(DFML32)
	CGFLAGS=-DWIN32 -W3 -MD -nologo
	ORACLE_DIR=$(ORACLE_HOME)\bin
	INCDIR=$(TUXDIR)\include
	CC=cl
In the .ec.c section, Edit rules for creating C programs from embedded SQL programs, (use the proc compiler), set the following values.	set TUXDIR=$(TUXDIR) & $(ORACLE_DIR)\proc80 mode=ansi release_cursor=yes include=$(SQLPUBLIC) include=$(INCDIR) $(SQL_PLATFORM_INC) -c iname=$*.ec
In the .c.obj section, Edit rule for creating object files from C programs, set the following values.	$(CC) -c $(CFLAGS) $(SQLPUBLIC) $(INCLUDE) $*.c

Update the *.ec files. Use Oracle SQL commands.

Run the makefile:

copy nt\bankapp.mak to %APPDIR%
nmake -f bankapp.mak

Edit nt\ubbshm as follows:

USER_ID=0
GROUP_ID=0
UNAME_SITE1=nodename returned by hostname
TUXDIR=same as specified in bankvar
APPDIR=same as specified in bankvar

In the GROUPS section of the configuration file, enter the following changes:

TMSNAME=TMS_ORA
BANKB1 	GRPNO=1         OPENINFO="Oracle_XA:Oracle_XA+Acc=P/user1/PaSsWd1+SesTm=0+LogDir=."
[
Oracle_XA +
 required fields:
 Acc=P/oracle_user_id/oracle_password +
 SesTm=Session_time_limit (maximum time a transaction can be inactive) +
 optional fields:
 LogDir=logdir (where XA library trace file is located) +
 MaxCur=maximum_#_of_open cursors +
 SqlNet=connect_string (if Oracle exists over the network)
 (eg. SqlNet=hqfin@NEWDB indicates the database with sid=NEWDB accessed at host hqfin by TCP/IP)
]
BANKB2 	GRPNO=2
	OPENINFO="Oracle_XA:Oracle_XA+Acc=P/user2/PaSsWd2+SesTm=0+LogDir=."
BANKB3 	GRPNO=3
OPENINFO="Oracle_XA:Oracle_XA+Acc=P/user3/PaSsWd3+SesTm=0+LogDir=."

Create the BEA Tuxedo configuration binary file:
```
tmloadcf -y nt/ubbshm
```
Create the device list and the TLOG device on the master machine:
```
crtlog -m
```
Start up the Oracle database instance if not already started.
Boot the BEA Tuxedo system servers:
```
tmboot -y
```
Ensure that the view v$XATRANS$ exists on the database. (The view V$XATRANS$ should have been created during the XA library installation.)
If the v$XATRANS$ view has not been created, create it as follows:
- Ensure that the environment variables ORACLE_HOME and ORACLE_SID are set.
- Log in to the database as user SYS:
```
Execute the sql script ${ORACLE_HOME}/RDBMS80/ADMIN/XAVIEW.sql
```
- Grant select privileges to this view for all Oracle account applications that will use the XA library.

Create the bankapp database and database objects for Oracle RM:

Log in to any of the Oracle utilities SQL*plus or SQL*DBA as any Oracle user.
notepad crbank-ora8.sql
When Oracle8 is installed, a sample database is created. You can use this database for the bankapp application. The sql script provided, creates a new tablespace in the database to hold all the database objects of bankapp.The script prompts for the Oracle system user password as well as a full path name of a file to use as the new tablespace.

Edit crbank-ora8.sql as follows:

WHENEVER OSERROR EXIT ;
/*Obtain the password for user "system" */
PROMPT
PROMPT
PROMPT -- Some of the operations require "system" user privileges
PROMPT -- Please specify the Oracle "system" user password
PROMPT
ACCEPT syspw CHAR PROMPT 'system passwd:' HIDE ;
CONNECT system/&syspw ;
SHOW user ;
PROMPT
/* Create a new tablespace in the default DB for use with "bankapp" */
DROP TABLESPACE bank1
    INCLUDING CONTENTS
CASCADE CONSTRAINTS;
PROMPT
PROMPT
PROMPT -- Will create a 3MB tablespace for bankapp ;
PROMPT -------- Please specify full pathname below for Datafile ;
PROMPT -------- Ex: %ORACLE_HOME%/dbs/bankapp.dbf
PROMPT
ACCEPT datafile CHAR PROMPT 'Datafile:' ;

CREATE TABLESPACE bank1
    DATAFILE '&datafile'  SIZE 3M REUSE
    DEFAULT STORAGE (INITIAL 10K   NEXT 50K
            MINEXTENTS 1           MAXEXTENTS 120
            PCTINCREASE 5)
    ONLINE;

/***************** Create a user called "user1" ***************/

DROP USER user1 CASCADE;

PROMPT Creating user "user1"

CREATE USER user1 IDENTIFIED by PaSsWd1
    DEFAULT TABLESPACE bank1
    QUOTA UNLIMITED ON bank1 ;

GRANT CREATE SESSION TO user1 ;
GRANT CREATE TABLE TO user1 ;

CONNECT user1/PaSsWd1 ;
SHOW user ;

PROMPT Creating database objects for user "user1" ;
PROMPT Creating table "branch" ;

    CREATE TABLE branch (
          branch_id       NUMBER NOT NULL PRIMARY KEY,
          balance         NUMBER,
          last_acct       NUMBER,
          last_teller     NUMBER,
          phoneCHAR(14),
          address         CHAR(60)

 )
          STORAGE         (INITIAL 5K   NEXT 2K
                          MINEXTENTS 1 MAXEXTENTS 5  PCTINCREASE 5) ;

PROMPT Creating table "account" ;

    CREATE TABLE account (
          account_id      NUMBER NOT NULL PRIMARY KEY,
          branch_id       NUMBER NOT NULL,
          ssn             CHAR(12) NOT NULL,
          balance         NUMBER,
          acct_type       CHAR,
          last_name       CHAR(20),
          first_name      CHAR(20),
          mid_init        CHAR,
          phoneCHAR(14),
          address         CHAR(60)

 )
          STORAGE         (INITIAL 50K NEXT 25K
                          MINEXTENTS 1 MAXEXTENTS 50   PCTINCREASE 5) ;

PROMPT Creating table "teller" ;
     CREATE TABLE teller (
          teller_id       NUMBER NOT NULL PRIMARY KEY,
          branch_id       NUMBER NOT NULL,
          balance         NUMBER,
          last_name       CHAR(20),
          first_name      CHAR(20),
          mid_init        CHAR
 )
          STORAGE         (INITIAL 5K  NEXT 2K
                          MINEXTENTS 1  MAXEXTENTS 5    PCTINCREASE 5) ;
PROMPT Creating table "history" ;
    CREATE TABLE history (
          account_id      NUMBER NOT NULL,
          teller_id       NUMBER NOT NULL,
          branch_id       NUMBER NOT NULL,
          amount          NUMBER

 )
          STORAGE         (INITIAL 400K   NEXT 200K
                          MINEXTENTS 1   MAXEXTENTS 5     PCTINCREASE 5) ;

Write the code to create user2 and user3 with passwords PaSsWd2 and PaSsWd3, respectively, following the method described in the above steps:
```
SQL*plus> start $APPDIR/ crbank-ora8.sql
```
Populate the database:
```
nt\populate
```
Generate transactions against the database:
```
driver
```
Run the bankapp client:
```
run
```
Shut down the application:
```
tmshutdown -y
```