User Manual

jdbc.username=<HP NonStop Username>
jdbc.password=<HP NonStop Password>
jdbc.catalog=jpetstorecat
jdbc.schema=jpetstoresch
NOTE: <HP NonStop Username> must have access to the schema created for
JPetstore.
3. Build the JPetStore WAR file
(org.springframework.samples.jpetstore-1.0.0-SNAPSHOT.war).
1. Go to the <My SASH Home>\spring\samples\jpetstore directory:
command prompt> cd <My SASH Home>\spring\samples\jpetstore
2. Build the JPetStore web archive using the JDBC Type 2 driver or JDBC Type 4 driver.
• To use the JDBC Type 2 driver:
command prompt> mvn clean package
The application WAR file
(org.springframework.samples.jpetstore-1.0.0-SNAPSHOT.war) is
created in the <My SASH Home>\spring\samples\jpetstore\target
directory.
• To use the JDBC Type 4 driver:
1. Enter the following command:
command prompt> mvn clean package
The application WAR file
(org.springframework.samples.jpetstore-1.0.0-SNAPSHOT.war)
is created in the <My SASH Home>\spring\samples\jpetstore\target
directory.
2. Create the WEB-INF\lib folder in the <My SASH
Home>\spring\samples\jpetstore\target directory.
3. Copy the JDBC Type 4 driver file (t4sqlmx.jar)to <My SASH
Home>\spring\samples\jpetstore\target\WEB-INF\lib.
4. Go to <My SASH Home>\spring\samples\jpetstore\target and run
the following command:
Command Prompt> cd <My SASH Home>\spring\samples\jpetstore\target
Command Prompt> jar uf org.springframework.samples.jpetstore-1.0.0-SNAPSHOT.war WEB-INF
\lib\t4sqlmx.jar
The t4sqlmx.jar is copied to <My SASH
Home>\spring\samples\jpetstore\target\
org.springframework.samples.jpetstore-1.0.0-SNAPSHOT.war\WEB-INF\lib.
Setting up JPetStore Database on NonStop
To set up the JPetStore database on the NonStop system, complete the following steps:
1. Edit the <My SASH
Home>\spring\samples\jpetstore\db\mxci\jpetstore_tables_script.sql
file to add the following:
• <$datavol>: specify the Guardian volume for the primary partition of the table. For
example: $data01.
• <user>: specify the owner of the schema. For example: super.sashusr.
Deploying and Running Sample Spring Applications on NonStop 47