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

\dbconfig
includes the catalog, schema, and table creation script.
\src
includes the Java source files and mapping files of EventManger.
\etc
includes the Hibernate dialect file (hibernate3sqlmx.jar) for the SQL/MX database.
2. Configure the JDBC driver settings for the NonStop SQL/MX database.
1. Go to the <My SASH HOME>\hibernate\samples\web\src\main\resources
directory on the Windows system.
2. Modify the hibernate.properties file to update the JDBC configuration. You can
use either the JDBC Type 2 driver or the JDBC Type 4 driver. The SQL/MX settings for
each of them is as follows:
•
To use the JDBC Type 2 driver, uncomment the SQL/MX settings for JDBC Type 2
driver in the hibernate.properties file so that the SQL/MX settings for the
JDBC Type 2 driver appear as:
#------------------------------------------------------------------------------
# SQL/MX Settings for JDBC Type 2 Driver
hibernate.dialect org.hibernate.dialect.SqlmxDialect
hibernate.connection.driver_class com.tandem.sqlmx.SQLMXDriver
hibernate.connection.url jdbc:sqlmx://
hibernate.connection.username
hibernate.connection.password
hibernate.connection.catalog eventcat
hibernate.connection.schema eventsch
NOTE: Because JDBC Type 2 driver is located on the NonStop system, you need
not mention the username and password in the
hibernate.connection.username
and hibernate.connection.password
fields.
•
To use the JDBC Type 4 driver, uncomment the SQL/MX settings for JDBC Type 4
driver in the hibernate.properties file and enter the values of JDBC URL
(NonStop system IP Address and port number of the JDBC data source), NonStop
system username, and password.
The SQL/MX settings for JDBC Type 4 driver in hibernate.properties appear
as:
#-------------------------------------------------------------------------------
# SQL/MX Settings for JDBC Type 4 Driver
hibernate.dialect org.hibernate.dialect.SqlmxDialect
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 eventcat
hibernate.connection.schema eventsch
164 Installing the Hibernate Framework