Setting up petclinic database on nonstop – HP Integrity NonStop J-Series User Manual
Page 22
#-------------------------------------------------------------
# Properties that control the population of schema and data for a new data source
# SQL/MX Settings for JDBC Type 4 Driver
jdbc.driverClassName= com.tandem.t4jdbc.SQLMXDriver
jdbc.url= jdbc:t4sqlmx://
jdbc.username=
jdbc.password=
jdbc.catalog=petcliniccat
jdbc.schema=petclinicsch
hibernate.dialect=org.hibernate.dialect.SqlmxDialect
3.
Build the PetClinic web application archive (WAR)file (petclinic.war).
1.
Go to the <My SASH Home>\spring\samples\petclinic directory:
command prompt> cd <My SASH Home>\spring\samples\petclinic
2.
Build the PetClinic web archive using JDBC Type 2 driver or 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 and copy the SQL/MX
hibernate dialect JAR file (hibernate35sqlmx.jar) to this directory.
3.
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\hibernate35sqlmx.jar
The hibernate35sqlmx.jar is copied to the <My SASH
Home>\spring\samples\petclinic\target\petclinic.war\WEB-INF\lib
directory.
NOTE:
If you are using the JDBC Type 4 driver:
•
In step 2, copy the t4sqlmx.jar file also to the \WEB-INF\lib directory in
addition to the hibernate35sqlmx.jar file.
•
In step 3, run this jar command:
jar uf petclinic.war
WEB-INF\lib\hibernate35sqlmx.jar WEB-INF\lib\t4sqlmx.jar
Setting up PetClinic Database on NonStop
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:
22
Spring Framework