WebLogic Server (WLS) 7.0

Pet Store Sample Application
HP NonStop Server Platform Guide for WebLogic Server—525779-001
6-3
Running the SQL/MX Form of Pet Store
59:# export CATSCH=’wls.petstore’
61:# export SQLVOL=’$data10.petdb’
Then rerun Pet Store with ...
. ./startPetStore_NSSQL.sh
ksh [142] . ./startPetStore_NSSQL.sh
Using existing settings for Pet Store sample application ...
Pet Store uses SQL/MP catalog $data.user
Changing catalog-schema in
/usr/bea/user_projects/hpns/samples/server/config/petstore/
startPetStore_NSSQL.sh
...
Dropping SQL/MX aliases for SQL/MP tables (if any) ...
Deleting existing SQL/MP catalog (if any) ...
Creating SQL/MP schema in catalog $DATA.USER ...
Loading data into SQL/MP database ...
Creating SQL/MX aliases for SQL/MP tables ...
Preparing petcheck.sql for future use ...
Example of dumping data in all tables:
gtacl -p sqlci < petcheck.sql > petcheck.log 2>&1
When the catalog is no longer needed, it can be deleted.
Example:
mxci < dropalias.sql > dropalias.log 2>&1
gtacl -p sqlci < dropcatalog.sql > dropcatalog.log 2>&1
CLASSPATH=/usr/tandem/nssjava/jdk131_v31/bin/../lib/tools.jar:/usr/bea/
weblogic700/server:/usr/bea/weblogic700/server/lib/weblogic_sp.jar:/usr/
bea/weblogic700/server/lib/weblogic.jar:/usr/tandem/nssjava/jdk131_v31/bin/
./lib/tools.jar:/usr/bea/user_projects/hpns/samples/server/stage/petstore/
serverclasses:/usr/bea/user_projects/hpns/samples/server/stage/common:/usr/
/bea/weblogic700/server/lib/nsxarm.jar:/usr/bea/weblogic700/server/
lib/wlsnsxarm.jar
PATH=.:/usr/bea/weblogic700/server/bin:/usr/tandem/nssjava/jdk131_v31/jre/
bin:/usr/tandem/nssjava/jdk131_v31/bin:/bin:/bin/unsupported::/usr/bin:.:
/usr/bea/user_projects/hpns/samples/server/eval/pointbase/tools
***************************************************
* To start WebLogic Server, use a username and *
* password assigned to an admin-level user. For *
* server administration, use the WebLogic Server *
* console at http://<hostname>:<port>/console *
***************************************************
+ /usr/tandem/nssjava/jdk131_v31/bin/../bin/java -Xms128m -Xmx128m -Xss384k
-Dweblogic.NativeIOEnabled=false -
-Dcompaq.liblist=/usr/tandem/nssjava/jdk131_v31/bin/oss/posix_threads/
JavaLibList
-Dpet.mode= -Dweblogic.management.discover=false
-Dweblogic.security.SSL.trustedCAKeyStore=/usr/bea/weblogic700/server/
lib/cacerts
-DHostnameVerificationIgnored=true
-Dhp.nsk.xares.name=petstore -Dhp.nsk.xares.flags=3
-Dhp.nsk.xares.enabletrace=false -Dhp.nsk.xares.tracefile=nsxarm.txt
-Dhp.nsk.xares.dummy.enabletrace=false -Dhp.nsk.xares.dummy.tracefile=
dummyrm.txt
-Dhp.nsk.xares.dummy.ignoreerrors=false -Dhp.nsk.jdbc.enabletrace=false
-Dhp.nsk.jdbc.tracefile=jdbctrc.txt -Dnametype=ANSI
-Dcatalog=softdev -Dschema=user -Dmploc=$data01.user
-classpath /usr/tandem/nssjava/jdk131_v31/lib/tools.jar:
/usr/bea/weblogic700/server:/usr/bea/weblogic700/server/lib/
weblogic_sp.jar:
/usr/bea/weblogic700/server/lib/weblogic.jar: