JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)

12 Providing a secure JDBC connection using NonStop SSL
This chapter discusses JDBC connection encryption by using NonStop SSL. This chapter includes
the following topics:
• “Encrypting the JDBC connection” (page 107)
• “Secure JDBC connection architecture” (page 107)
• “Installing a NonStop SSL Server process for ODBC/MX” (page 107)
• “Installing and configuring the Remote Proxy Client on the Windows workstation” (page 108)
• “Modifying the connection string and properties file of the JDBC Type 4 driver” (page 109)
Encrypting the JDBC connection
To encrypt the JDBC connection by using NonStop SSL, complete the following tasks:
1. On the HP NonStop server, install a NonStop SSL Server process for the ODBC/MX Association
Server of the target MXCS subsystem.
2. On each workstation, install the RemoteProxy software. Next, configure each Remote Proxy
to route plain ODBC and JDBC connections to the NonStop SSL Server process installed in
step 1.
3. To enable the JDBC Type 4 driver on your workstation to connect to RemoteProxy, on each
workstation, modify the connection string and the properties file of the appropriate Java
applications.
Secure JDBC connection architecture
Figure 4 (page 107) describes the architecture of the secure JDBC connection.
Figure 4 Secure JDBC connection
Installing a NonStop SSL Server process for ODBC/MX
Installing a NonStop SSL Server process is a privileged task that is restricted to the super.super
user. Users configuring only client workstations can ignore the following section that summarizes
the NonStop SSL installation process.
To install a NonStop SSL Server process for ODBC/MX, complete the following steps on the
NonStop server:
1. Log on as super.super.
2. To change to the NonStop SSL directory:
$SYSTEM STARTUP 1> volume $system.znsssl
Encrypting the JDBC connection 107