HA-Related JDBC Configuration

• Default Configuration
• JDBC Connection String in HA Environment

Default Configuration

• JDK 1.6 or higher
• CUBRID 2008 R2.1 or higher
• CUBRID JDBC Driver 2008 R2.1 or higher

JDBC Connection String in HA Environment

Description

To use the HA feature in JDBC, you must additionally specify the connection information of the broker, on which failover will be performed when a broker failure occurs, to the URL string. Attributes that are specified for HA are the host information (althosts) of one or more standby brokers that will be connected when there is a failure or the interval (rctime) at which the connection (failback) to the active broker will be attempted when recovering from the failure of the active server. For details about connection configuration in JDBC, see Connection Configuration.

Syntax

jdbc:cubrid:<host>:<port>:<db-name>:[user-id]:[password]:?[<property> [& <property>]]

host :

hostname | ip_address

property :

althosts= <alternative_hosts> | rctime= <second> | charset= <character_set>

alternative_hosts :

<standby_broker1_host>:<port> [,<standby_broker2_host>:<port>]

• althosts : Specifies the information of a broker to connect subsequently (failover) if the connection to the default broker fails. Multiple brokers to failover can be specified, and a connection is attempted according to the order listed by alhosts.
• rctime : The interval for attempting failback to the active broker where a failure occurs. This value is used when a failover is performed to the standby broker due to the failure in the active broker. After a failure occurs, the system connects to the broker specified by althosts (failover), end the transaction and then attempts to connect to the existing active broker at every rctime (failback). If rctime is not specified, it is configured to 600 seconds.

Example

--connection URL string when user name and password omitted

URL=jdbc:CUBRID:127.0.0.1:31000:db1:::

--connection URL string when charset property specified

URL=jdbc:CUBRID:127.0.0.1:31000:db1:::?charset=utf-8

--connection URL string when a property(althosts) specified for HA

URL=jdbc:CUBRID:127.0.0.1:31000:db1:::?althosts=127.0.0.2:31000,127.0.0.3:31000

--connection URL string when properties(althosts,rctime) specified for HA

URL=jdbc:CUBRID:127.0.0.1:31000:db1:::?althosts=127.0.0.2:31000,127.0.0.3:31000&rctime=600

--connection URL string when properties(althosts,rctime, charset) specified for HA

URL=jdbc:CUBRID:127.0.0.1:31000:db1:::?althosts=127.0.0.2:31000,127.0.0.3:31000&rctime=600&charset=utf-8