beautypg.com

Defining the connection url, Establishing the connection, Defining the hibernate dialect for sql/mx database – HP Integrity NonStop J-Series User Manual

Page 108: Specifying the mapping resources

background image

...
...


NOTE:

The significance of the <session-factory> tag is explained in

“Opening a Session

for Database Operation” (page 109)

.

Defining the Connection URL

After you have specified the JDBC driver, enter the location of the SQL/MX server. URLs referring
to SQL/MX use the jdbc: protocol and have the server host, port number embedded within
the URL. Define the connection URL as follows:

For Type 2 Driver:

Enter the connection URL as jdbc:sqlmx:// under the <session-factory> tag as shown:

jdbc:sqlmx://

For Type 4 Driver:

Enter the connection URL as jdbc:t4sqlmx://:No.>

under the <session-factory> tag as shown:

jdbc:t4sqlmx://:

Establishing the Connection

For Type 2 Driver:

Add the following syntax under the <session-factory> tag:


Do not specify the username and password.

For Type 4 Driver:

Specify the username and password of your NonStop system under the <session-factory>
tag as shown.


Defining the Hibernate Dialect for SQL/MX Database

Enter org.hibernate.dialect.SqlmxDialect as the Hibernate dialect class name for
SQL/MX database under the <session-factory> tag.


org.hibernate.dialect.SqlmxDialect

This dialect file allows Hibernate to generate SQL that is optimized for the SQL/MX database.

Specifying the Mapping Resources

Specify all the mapping files (.hbm) in the <mapping resource> tag as shown:


For example:

If the mapping file used in your application is Employee.hbm.xml, specify it as:


108 Hibernate Framework

This manual is related to the following products: