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

3. Set the value of the JDBC driver locations.
1. To use the JDBC Type 2 driver, set the value of the t2jdbc variable to the <JDBC
T2 Installation Directory>
OSS directory.
For example, if <JDBC T2 Installation Directory> is /usr/tandem/
jdbcMx/current
, the t2jdbc variable must be set to t2jdbc=/usr/tandem/
jdbcMx/current .
2. To use the JDBC Type 4 driver:
•
Copy the JDBC Type 4 driver JAR file, t4sqlmx.jar, from <JDBC T4
Installation Directory>\lib
the Windows directory to an OSS directory
on the NonStop system.
•
Replace <NonStop T4 Location> with the absolute path of the OSS directory
where you have kept the t4sqlmx.jar file.
For example, if <NonStop T4 Location> is /home/sash_usr/sash/
jdbct4
, the t4jdbc variable must be set to t4jdbc=/home/sash_usr/
sash/jdbct4 .
NOTE: To view the contents of the ei_setenv script file, see “Hibernate
Environment Setup Script” (page 339) .
3. Set the execute permissions of the ei_setenv script file using the OSS command:
OSS> chmod +x ei_setenv
5. Run the ei_setenv script file to set the JDBC environment and include the dependency JAR
files in the CLASSPATH.
•
To use the JDBC Type 2 driver, type:
OSS> . ./ei_setenv T2
•
To use the JDBC Type 4 driver, type:
OSS> . ./ei_setenv T4
Running EmployeeInfo on NonStop
1. Go to the <NonStop SASH Home>/hibernate/my_samples/employeeinfo directory
on the NonStop system.
2. Extract the contents of the application JAR file EmployeeInfo.jar:
OSS> jar -xvf EmployeeInfo.jar
3. Run the EmployeeInfo application:
OSS> java com.hp.imp.Test
The following output appears:
Hibernate: select max(id) from Emp
Hibernate: insert into Emp (fname, lname, age, id) values (?, ?, ?, ?)
1237276999876
Hibernate: select employee0_.id as id0_, employee0_.fname as fname0_, employee0_
.lname as lname0_, employee0_.age as age0_ from Emp employee0_
----------1
----------Test
Employee found using HQL
o_id=1
144 Hibernate Framework