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

OSS> mkdir -p <NonStop SASH Home>/spring/samples/petclinic/dbconfig
For example:
OSS> mkdir -p /home/sash_usr/sash/spring/samples/petclinic/dbconfig
NOTE: <NonStop SASH Home> can be any working directory. It is suggested that you
create spring/samples/petclinic/dbconfig directory structure in <NonStop SASH
Home
>.
3. Copy the following scripts from the <My SASH
Home>\spring\samples\petclinic\src\main\resources\db\mxci\
Windows
directory to the OSS directory created in Step 2:
•
petclinic_tables_script.sql
•
petclinic_dataload_script.sql
NOTE:
•
The petclinic_tables_script.sql script creates the SQL/MX database catalog,
schema, and tables for PetClinic.
•
The petclinic_dataload_script.sql script loads the database with sample data.
4. Go to the OSS directory where the petclinic_tables_script.sql and
petclinic_dataload_script.sql
files are copied, and create the PetClinic database
catalog, schema, and tables, using the SQL/MX command:
OSS> obey petclinic_tables_script.sql;
NOTE: By default, the petclinic_tables_script.sql file creates the database catalog
name as petcliniccat and schema name as petclinicsch. If these names conflict with
any of the existing catalog and schema names, modify the database catalog and schema
names in the petclinic_tables_script.sql script file.
If you modify the database catalog and schema names, edit the jdbc.properties file
present in the <My SASH Home>\spring\samples\petclinic\src\main\resources
directory, present in the SAMPLES.zip file.
5. Load the sample data in the PetClinic sample application database tables using the SQL/MX
command:
OSS> obey petclinic_dataload_script.sql;
The PetClinic database is setup on your NonStop system.
Deploying PetClinic on NonStop
For information on how to deploy PetClinic on the NonStop system, see Appendix C: Deploying
Sample Applications on NonStop .
Running PetClinic on NonStop
To run PetClinic on the NonStop system, in the NSJSP Web Application Manager screen, under
Applications, click /<servlet directory>/petclinic.
You can now perform the following actions using PetClinic:
•
View a list of veterinarians and their specialties
•
View and update information of a pet owner
•
Add a new pet owner to the system
•
View and update information of a pet
Installing the Spring Framework 23