Setting up the deployment environment on nonstop, Setting up sql/mx database on nonstop – HP Integrity NonStop H-Series User Manual
Page 302
hibernate.connection.driver_class com.tandem.t4jdbc.SQLMXDriver
hibernate.connection.url jdbc:t4sqlmx://
hibernate.connection.username
hibernate.connection.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
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
•
: 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
302
Installing Hibernate Framework