Communicator e3000 MPE/iX Release 6.5 (Non-Platform Software Release C.65.00 (30216-90291)

Chapter 5 155
Internet and Interoperability
HP Driver for JDBC
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.
URL Syntax (Without User Name and Password)
The second connection method specifies the user id and password as method arguments, so
this information is not present in the URL.
java.sql.DriverManager.getConnection(url, uid, pwd)
where:
String url =
“jdbc:allbase:// host [: port ]/ database [?TRACE= trace ]”;
String uid = “ uid ”;
String pwd = “ pwd ”;
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.
ALLBASE/SQL Specifics
ALLBASE/SQL to JDBC Data Type Mapping
Table 5-1. shows what the HP Driver for JDBC reports as the JDBC data type for each
ALLBASE/SQL data type. These are the java.sql.Types values that are returned from
the java.sql.ResultSetMetaData.getColumnType method. An “X” in the column