WebLogic Server (WLS) 7.0

Pet Store Sample Application
HP NonStop Server Platform Guide for WebLogic Server—525779-001
6-5
Running the SQL/MX Form of Pet Store
Also, the scripts that control the catalog are copied to the directory where you are
running the application. If you are running in the installed WebLogic Server location,
this is:
$BEA_HOME/user_projects/hpns/samples/server/config/petstore/schema
The defaults used with NonStop SQL are:
To specify other values for these, modify the shell variables CATSCH and SQLVOL in
the script create_petdb.sh. Be sure to escape the $ character in the volume name.
To use any of these scripts, change to the correct directory and run the script. For
example, to repopulate the catalog:
ksh [142] cd $BEA_HOME/user_projects/hpns/samples/server/config/petstore/
schema
ksh [143] create_petdb.sh -reload
The other scripts are input files to mxci or sqlci. Be sure to use the correct
command interpreter. For example, to remove the catalog after you have finished using
the sample application:
ksh [144] cd $WL_HOME/samples/server/config/petstore/schema
ksh [145] gtacl -p sqlci < dropcatalog.sql > dropcatalog.log
Change to the SQL/MX form of Pet Store by using the swapPetStore.sh script. The
-mx option tells the script to change Pet Store’s files from the PointBase versions to
the SQL/MX versions. For example:
ksh [146]. ./swapPetStore.sh -mx -w $SAMPLES
Pet Store will use NonStop SQL/MX. To start it, use:
cd /usr/bea/user_projects/hpns/samples/server/config/petstore
. ./startPetStore_NSSQL.sh
create_petdb.sh Shell script to create and reload the NonStop SQL catalog
for Pet Store.
dropalias.sql Input file to mxci to drop NonStop SQL/MP aliases.
dropcatalog.sql Input file to sqlci to drop NonStop SQL/MP catalog.
makealias.sql Input file to mxci to add NonStop SQL/MP aliases.
petcheck.sql Input file to sqlci to check the contents of the NonStop
SQL/MP tables by reporting the data in the tables.
petdata.sql Input file to sqlci to load data into NonStop SQL/MP
tables.
petschema.sql Input file to sqlci to create the NonStop SQL/MP catalog
and tables.
SQL/MX catalog The current user’s group. For example, DEV.
SQL/MX schema The current user’s ID. For example, USER.
SQL/MP subvolume The current user’s default subvolume.