Setting up jpetstore database on nonstop – HP Integrity NonStop J-Series User Manual
Page 47
jdbc.username=
jdbc.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
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.
•
: specify the owner of the schema. For example: super.sashusr.
Deploying and Running Sample Spring Applications on NonStop
47