HP Integrity NonStop J-Series - Manual (Page 101)

NOTE: The hibernate.properties file, located in <My SASH
HOME>\hibernate\samples\eg\src\main\resources , has the database
catalog name set toauctioncat and schema name set to auctionsch. If the
database catalog name auctioncat and schema name auctionsch already
exists, or if you want to use a different database catalog and schema name, modify
the following:
◦ values for the hibernate.connection.catalog and
hibernate.connection.schema
property in the hibernate.properties
file.
◦ database catalog and schema names in the caveatemptor_script.sql
script file, as discussed in
“Setting up the Deployment Environment on NonStop”
(page 101) .
3. Build Caveat Emptor (Caveatemptor.jar).
a.
Go to the <My SASH Home>\hibernate\samples\eg\ directory.
b. Use Maven to build the Caveat Emptor JAR file.
If you want to use the JDBC Type 2 driver, build the Caveat Emptor JAR using the
command:
command prompt> mvn clean package
After successful build of Caveat Emptor, a new directory named target is created in the
<My SASH Home>\hibernate\samples\eg
directory. The application JAR file
(hibernate-tutorial-eg-3.5.0-CR-2.jar) is created in the target directory.
Caveat Emptor is built on the Windows system.
Setting up the Deployment Environment on NonStop
Setting up the deployment environment on a NonStop system comprises the following:
1. “Setting up SQL/MX database on NonStop” (page 101)
2. “Setting up the Hibernate and JDBC environment on NonStop” (page 102)
Setting up SQL/MX database on NonStop
1. Edit the <My SASH
Home>\hibernate\samples\eg\dbconfig\caveatemptor_script.sql
file as
follows:
•
<$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:
OSS> mkdir -p <NonStop SASH Home>/hibernate/samples/eg/dbconfig
For example:
OSS> mkdir -p /home/sash_usr/sash/hibernate/samples/eg/dbconfig
Installing the Hibernate Framework 101