Manual

hibernate.connection.driver_class com.tandem.t4jdbc.SQLMXDriver
hibernate.connection.url jdbc:t4sqlmx://<HP NonStop System IP Address>:<Port No.>
hibernate.connection.username <HP NonStop Username>
hibernate.connection.password <HP NonStop Password>
hibernate.connection.catalog auctioncat
hibernate.connection.schema auctionsch
NOTE: The hibernate.properties file, present in <My SASH
HOME>\hibernate\samples\eg, has the database catalog name set to
auctioncat 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:
— values for the hibernate.connection.catalog and
hibernate.connection.schema property in the hibernate.properties
file present in <My SASH HOME>\hibernate\samples\eg.
— database catalog and schema names in the caveatemptor_script.sql
script file as discussed in Setting up the Deployment Environment on NonStop.
4. Build Caveat Emptor (Caveatemptor.jar).
a. Go to the <My SASH Home>\hibernate\samples\eg directory using the command:
Command Prompt> cd <My SASH Home>\hibernate\samples\eg
b. Use ant to build the Caveat Emptor JAR file.
• If you plan to use the JDBC Type 2 driver, build the Caveat Emptor JAR using the
command:
Command Prompt> ant –buildfile build_jdbct2.xml all
• If you plan to use JDBC Type 4 driver, build the Caveat Emptor JAR using the
command:
Command Prompt> ant –buildfile build_jdbct4.xml all
After successful build of Caveat Emptor, a new directory named dist is created in the <My
SASH Home>\hibernate\samples\eg directory. The application JAR file
(caveatemptor.jar) is created in the dist directory.
This completes the building of Caveat Emptor on your Windows system.
Setting up the Deployment Environment on NonStop
Setting up the deployment environment on a NonStop system comprises the following actions:
1. Setting up SQL/MX database on NonStop
2. Setting up the Hibernate and JDBC environment on NonStop
Setting up SQL/MX database on NonStop
To set up the SQL/MX database for Caveat Emptor on your NonStop system, complete the
following steps:
1. Edit the <My SASH
Home>\hibernate\samples\eg\dbconfig\caveatemptor_script.sql file to
mention the following:
• <$datavol>: specify the Guardian volume for the primary partition of the table. For
example: $data01
• <user>: specify the owner of the schema. For example: super.sashusr
• <node.$vol>: specify the location of the metadata tables for the catalog. For example:
\NSK01.$data01
• <subvol reference>: specify the designated subvolume name for the schema. For
example: SASH1
302 Installing Hibernate Framework