Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for JDBC for Greenplum User's Guide Release 6.0.0

Configuring failover

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for JDBC for Greenplum Driver
    • What's new in this release?
    • Requirements
    • Installing and setting up the driver
    • Driver and DataSource classes
    • Connection URL examples
      • User ID/password authentication
      • Kerberos authentication
      • Proxy server
    • Data types
      • getTypeInfo()
    • SQL escape sequences
      • Supported scalar functions
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Tutorials
    • Tableau
    • DbVisualizer
      • Adding a driver
      • Connecting and executing SQL statements
  • Configuring and connecting
    • Setting the classpath
    • Connecting using the JDBC Driver Manager
      • Passing the connection URL
      • Testing the connection
    • Connecting using data sources
      • How data sources are implemented
      • Creating data sources
        • Example data source
      • Calling a data source in an application
      • Testing a data source connection
    • Authentication
      • Configuring the driver for user ID/password authentication
      • Configuring the driver for Kerberos authentication
        • Kerberos authentication requirements
        • The JAAS login configuration file
    • Data Encryption
      • Configuring TLS/SSL encryption
      • Configuring TLS/SSL Server Authentication
      • Configuring TLS/SSL Client Authentication
      • FIPS (Federal Information Processing Standard)
    • Performance considerations
  • Additional features and functionality
    • Statement pooling
    • Connection pooling
    • Using client information
    • Bulk load support
    • Failover
      • Configuring failover
        • Specifying primary and alternate servers
        • Specifying connection retry
        • Failover properties
    • Refcursors
    • Isolation levels
    • Using scrollable cursors
    • JTA support
    • Large object (LOB) support
    • Using COPY command
    • Parameter metadata support
      • User-defined functions' results
    • ResultSet metadata support
    • Rowset support
  • Connection property descriptions
    • AccountingInfo
    • AlternateServers
    • ApplicationName
    • AuthenticationMethod
    • BulkLoadBatchSize
    • CatalogOptions
    • ClientHostName
    • ClientUser
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CryptoProtocolVersion
    • Database
    • DatabaseName
    • EnableCancelTimeout
    • EncryptionMethod
    • ExtendedColumnMetadata
    • HostNameInCertificate
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • JavaDoubleToString
    • KeyPassword
    • KeyStore
    • KeyStorePassword
    • LoadBalancing
    • LoginConfigName
    • LoginTimeout
    • MaxLongVarcharSize
    • MaxNumericPrecision
    • MaxNumericScale
    • MaxPooledStatements
    • MaxStatements
    • MaxVarcharSize
    • Password
    • PortNumber
    • PrepareThreshold
    • ProgramID
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • QueryTimeout
    • RegisterStatementPoolMonitorMBean
    • ResultSetMetaDataOptions
    • ServerName
    • ServicePrincipalName
    • SpyAttributes
    • SupportsCatalogs
    • TransactionErrorBehavior
    • TrustStore
    • TrustStorePassword
    • User
    • ValidateServerCertificate
    • VarcharClobThreshold
  • Copyright
Table of Contents

Configuring failover

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: June 25, 2021
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Documentation

The driver allows you to specify a list of alternate database servers that are tried at connection time if the primary server is not accepting connections. Connection attempts continue until a connection is successfully established or until all the database servers in the list have been tried the specified number of times.

Contents
  • Specifying primary and alternate servers
  • Specifying connection retry
  • Failover properties
TitleResults for “How to create a CRG?”Also Available inAlert