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 PostgreSQL User's Guide Release 6.0.0

Additional features and functionality

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 PostgreSQL Driver
    • What's new in this release?
    • Requirements
    • Installing and setting up the driver
    • Driver and DataSource classes
    • Connection URL examples
    • 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
      • User ID and password authentication
      • Kerberos authentication
        • Kerberos authentication requirements
        • The JAAS login configuration file
      • Microsoft Entra ID authentication
      • AWS IAM authentication
    • Data encryption
      • TLS/SSL encryption
        • TLS/SSL server authentication
        • TLS/SSL client authentication
        • Configuring TLS/SSL encryption
        • FIPS (Federal Information Processing Standard)
    • Using client information
    • Bulk load
    • Performance considerations
  • Additional features and functionality
    • Statement pooling
    • Connection pooling
    • Failover
      • Configuring failover
        • Specifying primary and alternate servers
        • Specifying connection retry
    • Refcursors
    • Returning and inserting/updating XML data
      • Returning XML data
      • Inserting/updating XML data
        • Character data
        • Binary data
    • Isolation levels
    • Using scrollable cursors
    • JTA support
    • Batch inserts
    • Large object (LOB) support
    • Using COPY command
    • Parameter metadata support
      • User-defined function results
    • ResultSet metadata support
    • Rowset support
    • Auto-generated keys support
    • Using proxy tunneling
  • Connection property descriptions
    • AccessKey
    • AccountingInfo
    • AlternateServers
    • ApplicationName
    • AuthenticationMethod
    • AzureTenantID
    • BatchMechanism
    • BulkLoadBatchSize
    • CallEscapeBehavior
    • CatalogOptions
    • ClientHostName
    • ClientUser
    • CodePageOverride
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CryptoProtocolVersion
    • DatabaseName
    • EnableCancelTimeout
    • EnablePrepareThreshold
    • EncryptionMethod
    • ExtendedColumnMetadata
    • HostNameInCertificate
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • JavaDoubleToString
    • KeyPassword
    • KeyStore
    • KeyStorePassword
    • LoadBalancing
    • LoginConfigName
    • LoginTimeout
    • MaxLongVarcharSize
    • MaxNumericPrecision
    • MaxNumericScale
    • MaxPooledStatements
    • MaxStatements
    • MaxVarcharSize
    • Password
    • PortNumber
    • PrepareThreshold
    • ProgramID
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • ProxyHost
    • QueryTimeout
    • Region
    • RegisterStatementPoolMonitorMBean
    • ResultSetMetaDataOptions
    • SecretKey
    • ServerName
    • ServicePrincipalName
    • SpyAttributes
    • SupportsCatalogs
    • TransactionErrorBehavior
    • TrustStore
    • TrustStorePassword
    • User
    • ValidateServerCertificate
    • VarcharClobThreshold
  • Copyright
Table of Contents

Additional features and functionality

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: March 30, 2020
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • PostgreSQL 6.0
    • Documentation

The following section describes additionally supported features and functionality that are specific to the driver.

Contents
  • Statement pooling
  • Connection pooling
  • Failover
  • Refcursors
  • Returning and inserting/updating XML data
  • Isolation levels
  • Using scrollable cursors
  • JTA support
  • Batch inserts
  • Large object (LOB) support
  • Using COPY command
  • Parameter metadata support
  • ResultSet metadata support
  • Rowset support
  • Auto-generated keys support
  • Using proxy tunneling
Related Links
  • Installing and setting up the driver
TitleResults for “How to create a CRG?”Also Available inAlert