Setting up petclinic database on nonstop – HP Integrity NonStop J-Series User Manual
Page 42
4.
Go to <My SASH Home>\spring\samples\petclinic\target and run
the following commands:
command prompt> cd <My SASH Home>\spring\samples\petclinic\target
command prompt> jar uf petclinic.war WEB-INF\lib\hibernate3sqlmx.jar
The hibernate3sqlmx.jar is copied to <My SASH
Home>\spring\samples\petclinic\target\petclinic.war\WEB-INF\lib
.
•
To use JDBC Type 4 driver:
1.
Enter the following command:
command prompt> mvn clean package
The application WAR file (petclinic.war) is created in the <My SASH
Home>\spring\samples\petclinic\target
directory.
2.
Create the WEB-INF\lib folder in the
directory.
3.
Copy hibernate3sqlmx.jar and t4sqlmx.jar to the <My SASH
Home>\spring\samples\petclinic\target\WEB-INF\lib
directory.
4.
Go to <My SASH Home>\spring\samples\petclinic\target and run
the following commands:
command prompt> cd
command prompt> jar uf petclinic.war WEB-INF\lib\hibernate3sqlmx.jar WEB-INF\
lib\t4sqlmx.jar
The hibernate3sqlmx.jar and t4sqlmx.jar files are copied to
<My SASH Home>\spring\samples\petclinic\target\
petclinic.war\WEB-INF\lib.
Setting up PetClinic Database on NonStop
To set up the PetClinic database on your NonStop system, complete the following steps:
1.
Edit the <My SASH Home>\spring\samples\petclinic\src\main\resources\db\
mxci\petclinic_tables_script.sql
file to include 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: SASH1
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, using the command:
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
>.
42
Installing the Spring Framework