HP Integrity NonStop J-Series - Manual (Page 26)

3. Copy the following scripts from the Home>\spring\samples\jpetstore\db\mxci
Windows directory to the OSS directory
created in Step 2:
•
jpetstore_tables_script.sql
•
jpetstore_dataload_script.sql
NOTE:
•
The jpetstore_tables_script.sql script creates the SQL/MX database catalog,
schema, and tables for JPetStore.
•
The jpetstore_dataload_script.sql script loads the database with sample data.
4. Go to the OSS directory where the jpetstore_tables_script.sql and
jpetstore_dataload_script.sql
files are copied, and create the JPetStore database
catalog, schema, and tables, using the SQL/MX command:
OSS> obey jpetstore_tables_script.sql;
NOTE: By default, the jpetstore_tables_script.sql file creates the database catalog
name as jpetstorecat and schema name as jpetstoresch. If these names conflict with
the existing catalog and schema names, modify the database catalog and schema names in
the jpetstore_tables_script.sql script file.
If you modify the database catalog and schema names, the new names must be updated in
the jdbc.properties file located in the Home>\spring\samples\jpetstore\src\main\webapp\WEB-INF
directory, included
in the SAMPLES.zip file.
5. Load the sample data in the JPetStore database tables:
OSS> obey jpetstore_dataload_script.sql;
The JPetStore database is setup on the NonStop system.
Deploying JPetStore on NonStop
For information on how to deploy JPetStore on the NonStop system, see Appendix C: Deploying
Sample Applications on NonStop .
Running JPetStore on NonStop
To run JPetStore on the NonStop system, in the NSJSP Web Application Manager screen, under
Applications, click /<servlet
directory
>/org.springframework.samples.jpetstore-1.0.0-SNAPSHOT.
As a visitor, you can now perform the following activities:
•
Select a Product Category labeled with words or icons, view the item detail, or access the
MenuBar features.
•
Search by entering a keyword or phrase to locate items.
•
Add an item to a Cart, either from a summary list or from a detail view.
•
Collect items for later purchase.
•
Increase or decrease the quantity for any item in a Cart, up to available inventory, or remove
the item from the Cart by changing the quantity to zero.
•
Complete an online form to create an Account.
26 Spring Framework