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 Amazon Redshift Driver User's Guide Release 5.1.4

Getting started

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 Amazon Redshift Driver
    • What's new in this release?
    • Requirements
    • Driver and data source classes
    • Connection properties
    • Version string information
    • Data types
      • getTypeInfo()
    • DataDirect tools
    • Troubleshooting
    • Contacting Technical Support
  • Getting started
    • Driver and data source classes
    • Setting the classpath
    • Connecting using the DriverManager
      • 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
  • Using the driver
    • Required permissions for Java SE with the standard Security Manager enabled
      • Permissions for establishing connections
      • Granting access to Java properties
      • Granting access to temporary files
      • Permissions for bulk load from a CSV file
    • Connecting from an application
      • Driver and data source classes
      • Setting the classpath
      • Connecting using the DriverManager
        • 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
      • Interactive SQL for JDBC (JDBCISQL)
    • Using connection properties
      • Required properties
      • Authentication properties
      • Data encryption properties
      • Failover properties
      • Proxy server properties
      • Timeout properties
      • Data type handling properties
      • Client information properties
      • Statement pooling properties
      • Additional properties
    • Performance considerations
    • Authentication
    • Data encryption
      • Configuring SSL encryption
      • Configuring SSL server authentication
      • Configuring SSL client authentication
    • Client information
      • How databases store client information
        • Storing client information
      • Returning client information
      • Returning metadata about client information locations
    • Failover support
    • Connecting Through a Proxy Server
    • IP addresses
    • Parameter metadata support
    • ResultSet metadata support
    • Unicode support
    • Error handling
    • Timeouts
    • Isolation levels
    • Client information
    • Scrollable cursor support
    • Large object (LOB) support
    • Batch inserts and updates
    • Rowset support
    • DataDirect Bulk Load
      • Using a DDBulkLoad object
        • Exporting data to a CSV file
        • Loading Data from a ResultSet object
        • Loading data from a CSV file
        • Specifying the bulk load operation
        • Logging
    • Using CSV files
      • Bulk load configuration file
      • Bulk load configuration file schema
        • Verifying the bulk load configuration file for database connections
      • Character set conversions
      • External overflow files
      • Discard file
  • Connection property descriptions
    • AccountingInfo
    • ApplicationName
    • BatchMechanism
    • BulkLoadBatchSize
    • CatalogOptions
    • ClientHostName
    • ClientUser
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CryptoProtocolVersion
    • DatabaseName
    • EnableCancelTimeout
    • EncryptionMethod
    • ExtendedColumnMetadata
    • HostNameInCertificate
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • JavaDoubleToString
    • KeyPassword
    • KeyStore
    • KeyStorePassword
    • LoginTimeout
    • MaxNumericPrecision
    • MaxNumericScale
    • MaxPooledStatements
    • MaxVarcharSize
    • Password
    • PortNumber
    • ProgramID
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • QueryTimeout
    • ResultSetMetaDataOptions
    • ServerName
    • SpyAttributes
    • SupportsCatalogs
    • TransactionErrorBehavior
    • TrustStore
    • TrustStorePassword
    • User
    • ValidateServerCertificate
    • VarcharClobThreshold
  • Copyright
Table of Contents

Getting started

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: May 13, 2025
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Documentation
After the driver has been installed and defined on your class path, you can connect from your application to your database in either of the following ways.
  • Using the JDBC DriverManager, by specifying the connection URL in the DriverManager.getConnection() method.
  • Creating a JDBC DataSource that can be accessed through the Java Naming Directory Interface (JNDI).
Contents
  • Driver and data source classes
  • Setting the classpath
  • Connecting using the DriverManager
  • Connecting using data sources
TitleResults for “How to create a CRG?”Also Available inAlert