Neoview JDBC Type 4 Driver Programmer's Reference (R2.2, R2.3, R2.4, R2.5)

If the translationVerification property’s value is FALSE, and the driver is unable to
translate all or part of an SQL statement; the translation is unspecified. In most cases, the characters
that are untranslatable are encoded as ISO88591 single-byte question marks (? or 0x3F). No
exception or warning is thrown.
If the translationVerification property’s value is TRUE and the driver cannot translation
all or part of an SQL statement or parameter, the driver throws an SQLException with this text.
Translation of parameter to {0} failed. Cause: {1}
where {0} is replaced with the target character set and {1} is replaced with the cause of the
translation failure.
If the translationVerification property is set to TRUE, the process can use significantly
more system resources. For better performance, set this property to FALSE.
For more information, see “Internationalization Support” (page 31).
url Property
The url property sets the URL value for the Neoview SQL database. This property is used in
the DriverManager object. The format to specify the URL is:
jdbc:hpt4jdbc//primary_IP_addr_or_hostname_on_Neoview_DB:18650/[:]
[property=value[;property2=value]...]
where primary_IP_addr_or_hostname_on_Neoview_DB:18650 specifies the location of
the Neoview SQL database.
Data type: String
Default: none
For example:
url=jdbc:hpt4jdbc://mynode.mycompanynetwork.net:18650/
url Property Considerations
• If the url parameter is not specified and DriverManager.getConnection() is called,
the Type 4 driver throws an SQLException.
• If you use a literal IPV4 or IPV6 address in a URL, note these guidelines:
— For IPV6 only, enclose the address in brackets ([ and ]).
— The port number is optional according to both the IPV4 and IPV6 standard.
— The default port number for the Neoview database is 18650.
user Property
The user property sets the role value for the connectivity service. The role name passed must
have adequate access permissions for SQL data accessed through the HP connectivity service.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object. For information about how to set properties, see “How to Specify JDBC
Type 4 Properties” (page 38).
Data type: String
Default: empty string
For example, user=System_rolename
50 Type 4 Driver Properties