skip to main content
Quick Start: Progress DataDirect for JDBC for Apache Hive Driver : Using Connection Properties
  

Try DataDirect Drivers Now

Using Connection Properties

You can use connection properties to customize the driver for your environment. You can use these connection properties with either the JDBC Driver Manager or a JDBC data source. For a Driver Manager connection, a property is expressed as a key value pair and takes the form property=value. For a data source connection, a property is expressed as a JDBC method and takes the form setProperty(value). For a complete list of supported properties, refer to "Connection Property Descriptions" in the Progress DataDirect for JDBC for Apache Hive Driver User's Guide
The following table summarizes the minimum connection properties required to connect to a database. The first section describes properties required for both binary (TCP) mode and HTTP modes, while the second documents additional properties required to establish an HTTP connection. For a list of properties that affect performance, see "Tuning for Performance."
Note: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such.
Note: The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.
Table 1. Required Properties
Property
Characteristic
Required properties for all connections
DatabaseName
Specifies the name of the database. The database must exist, or the connection attempt will fail.
PortNumber
The TCP port of the primary database server that is listening for connections to the database.
The default is 10000 for binary connections and 10001 for HTTP connections.
ServerName
Specifies either the IP address or the server name (if your network supports named servers) of the primary database server.
Additional properties required for enabling HTTP mode
HTTPPath
Specifies the path of the HTTP/HTTPS endpoint used for connections when HTTP mode is enabled (TransportMode=http).
The default is cliservice.
TransportMode
Specifies whether binary (TCP) mode or HTTP mode is used to access Apache Hive data sources.
If set to binary, Thrift RPC requests are sent to directly to data sources using a binary connection (TCP mode).
If set to http, Thrift RPC requests are sent using HTTP transport (HTTP mode). HTTP mode is typically used when connecting to a reverse-proxy server, such as a gateway, for improved security, or a load balancer.
Note: To configure the driver to use HTTPS end points, set TransportMode=http and EncryptionMethod=SSL.
The default is binary.