Setting up jpetstore database on nonstop – HP Integrity NonStop J-Series User Manual
Page 25
3.
Build the JPetStore WAR file
(org.springframework.samples.jpetstore-1.0.0-SNAPSHOT.war).
1.
Go to the
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.
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.
If you are using JDBC Type 4 driver, proceed with Step 3.
3.
Copy the JDBC Type 4 driver file (t4sqlmx.jar) to the <My SASH
Home>\spring\samples\jpetstore\target
directory.
4.
Go to <My SASH Home>\spring\samples\jpetstore\target and run the
following commands:
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 file is copied to the <My SASH
Home>\Home>\spring\samples\jpetstore\target\
org.springframework.samples.jpetstore-1.0.0-SNAPSHOT.war\WEB-INF\lib
directory.
Setting up JPetStore Database on NonStop
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.
•
: specify the owner of the schema. For example: super.sashusr.
•
: specify the location of the metadata tables for the catalog. For example:
\NSK01.$data01.
•
: specify the designated subvolume name for the schema. For
example: SASH2.
NOTE:
The subvolume name is always prefixed by ZSD and must have eight characters
(including ZSD).
2.
Create a directory in OSS to place the database script files:
OSS> mkdir -p <NonStop SASH Home>/spring/samples/jpetstore/dbconfig
For example:
OSS> mkdir -p /home/sash_usr/sash/spring/samples/jpetstore/dbconfig
NOTE:
<NonStop SASH Home> can be any working directory. It is suggested that you
create the spring/samples/jpetstore/dbconfig directory structure in <NonStop
SASH Home
>.
Installing the Spring Framework
25