User Manual

3. Copy the following scripts from the <My SASH Home>\spring\samples\petclinic\
src\main\resources\db\mxci\Windows directory to the <NonStop SASH
Home>/spring/samples/petclinic/dbconfig OSS directory:
• 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 using the command:
OSS> cd <NonStop SASH Home>/spring/samples/petclinic/dbconfig
For example:
OSS> cd /home/sash_usr/sash/spring/samples/petclinic/dbconfig
5. Create the PetClinic database catalog, schema, and tables, using the SQL/MX command:
mxci>> 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.
6. Load the sample data in the PetClinic sample application database tables using the SQL/MX
command:
mxci>> obey petclinic_dataload_script.sql;
The PetClinic database is setup on your NonStop system.
Deploying PetClinic on NonStop
To deploy PetClinic on the NonStop system, complete the following steps:
1. Go to http://<IP Address of the iTP WebServer>:<port#>/<manager directory>.
The NSJSP Manager Login screen appears.
Figure 2 shows the NSJSP Manager Login screen.
Deploying and Running Sample Spring Applications on NonStop 43