HP Driver for JDBC User's Manual

36 Chapter4

Using the HP Driver for JDBC

Connection Parameters

The following information is required for all HP JDBC connections to

an ALLBASE/SQL or IMAGE/SQL database:

Host name — The name of the server host on which the

ALLBASE/SQL or IMAGE/SQL database and JDBC Monitor is

running. This can either be the name of the server host, or the IP

address. For example, 'myserv.mycomp.com' or '20.45.12.122'.

Port number — The port number on which the JDBC Monitor is

listening. This is speciﬁed when the monitor is started on the server

host in the startup command or script. The default port number for use

by the JDBC Monitor is 31700. If a port number is not speciﬁed, this

default value is used.

User Name — A valid user name for the server host. The JDBC

Monitor performs user validation on the server host for all client

connections. For the HP-UX server platform, the user name is the same

as the HP-UX user id. For the MPE/iX server platform, the user name

can be composed of a user, group, account, and session id. The user

name is masked by the JDBC Driver before it is transferred over the

network to prevent casual detection.

User Password — The password(s) that match the provided user

name. For the HP-UX server platform this is the password for the

provided HP-UX user id. For the MPE/iX platform, this is composed of

the group and account passwords for the group and account provided as

the user name. The user password is masked by the JDBC Driver

before it is transferred over the network to prevent casual detection.

Database Name — This is the name of the ALLBASE/SQL or

IMAGE/SQL database ﬁle on the server. On HP-UX, this is the fully

qualiﬁed path and ﬁlename of the database ﬁle. On MPE/iX, this is

either the fully qualiﬁed three-part ﬁlename of the database, or the

database name if a user.account,group name was speciﬁed.

NOTE

Database name for MPE/iX usually includes the location of the DBE. If

the username does not include the same logon group, the full location

must be provided.

These values must be validated before a connection is made to the

JDBC Server. The sample client provided with the HP Driver for JDBC

can be used to test the correctness of these values.