HP Driver for JDBC User's Manual

38 Chapter4
Using the HP Driver for JDBC
URL Syntax (Including User Name and Password)
URL Syntax (Including User Name and
Password)
The first connection method specifies all connection parameters in a
URL string including the user name and password.
java.sql.DriverManager.getConnection(url)
where:
String url =
“jdbc:allbase:// host [: port ]/ database ?UID= uid &PWD= pwd ”
“[&TRACE= trace ]”;
host Name or IP address of the sever host.
port Optional port number on which the JDBC Monitor is
listening. If not specified, the default part number
31700 is used.
database ALLBASE/SQL or IMAGE/SQL database name.
uid Server host userid that is authorized to access the
database.
pwd Server host password that matches the user id provided
above.
trace Optional trace values separated by the vertical bar “|”
character. For more information on tracing, see the
Troubleshooting section.
NOTE This connection method may result in the user name and password
being logged in various places, as URLs are commonly logged on
various web servers and proxy servers. The URL is also logged if
tracing is turned on. For this reason, the second connection method is
preferred.