• Progress DataDirect for JDBC for Amazon Redshift Driver User's Guide
•  Preface
  • About this Guide
  • Using this Guide
  • About the Product Documentation
  • Typographical Conventions
  • Contacting Technical Support
•  Getting Started
  •  Quick Start Connect
    • Connecting with the JDBC Driver Manager
    • Setting the Classpath
    • Registering the Driver
    • Passing the Connection URL
    • Testing the Connection
•  About the Driver
  •  Progress DataDirect for JDBC for Amazon Redshift
    • Requirements
    • Components
    • Data Source and Driver Classes
    • Version String Information
    • Connection Properties
    • Data Types
  •  Supported Features
    • Authentication
    • Data Encryption
    • Unicode Support
    • Error Handling
    • IP Addresses
    • Timeouts
    • Isolation Levels
    • Client Information
    • Scrollable Cursor Support
    • Large Object (LOB) Support
    • Batch Inserts and Updates
    • Parameter Metadata Support
    • ResultSet MetaData Support
    • Rowset Support
    • Failover Support
    • Bulk Load Support
  •  Using the Driver
    •  Required Permissions for the Java Platform
      • 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
      •  Connecting Using the JDBC Driver Manager
        • Registering the Driver
        • Passing the Connection URL
      •  Connecting Using Data Sources
        • How Data Sources Are Implemented
        • Creating Data Sources
        • Calling a Data Source in an Application
      • Testing the Connection
    •  Using Connection Properties
      • Required Properties
      • Authentication Properties
      • Data Encryption Properties
      • Failover Properties
      • Timeout Properties
      • Data Type Handling Properties
      • Client Information Properties
      • Statement Pooling Properties
      • Additional Properties
    • Performance Considerations
    •  Using Data Encryption
      • Configuring SSL Encryption
      • Configuring SSL Server Authentication
      • Configuring SSL Client Authentication
    •  Using Client Information
      •  How Databases Store Client Information
        • Storing Client Information
      • Returning Client Information
      • Returning MetaData About Client Information Locations
    •  Connection Pool Manager
      •  How Connection Pooling Works
        • The Connection Pool Environment
        • The DataDirect Connection Pool Manager
        • Using a Connection Pool Data Source Object
      •  Implementing DataDirect Connection Pooling
        • Creating a Driver DataSource Object
        • Creating the Connection Pool
      •  Configuring the Connection Pool
        • Configuring the Maximum Pool Size
      • Connecting Using a Connection Pool
      • Closing the Connection Pool
      • Checking the Pool Manager Version
      • Enabling Pool Manager Tracing
      •  Connection Pool Manager Interfaces
        • PooledConnectionDataSourceFactory
        • PooledConnectionDataSource
        • ConnectionPoolMonitor
    •  Statement Pool Monitor
      • Enabling Statement Pooling
      •  Accessing the Statement Pool Monitor
        • Using JMX
        •  Using Progress DataDirect Methods
          • Using the poolEntries() Method
          • Generating a List of Statements in the Statement Pool
      • Importing Statements into a Statement Pool
      • Clearing All Statements in a Statement Pool
      • Freezing and Unfreezing the Statement Pool
      • Generating a Statement Pool Export File
      •  DataDirect Statement Pool Monitor Interfaces and Classes
        • ExtStatementPoolMonitor Class
        • ExtStatementPoolMonitorMBean Interface
    •  Using 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
    •  Using DataDirect Test
      •  DataDirect Test Tutorial
        • Configuring DataDirect Test
        • Starting DataDirect Test
        •  Connecting Using DataDirect Test
          • Connecting Using a Data Source
          • Connecting Using Database Selection
        • Executing a Simple Select Statement
        • Executing a Prepared Statement
        • Retrieving Database Metadata
        • Scrolling Through a Result Set
        • Batch Execution on a Prepared Statement
        • Returning ParameterMetaData
        • Establishing Savepoints
        •  Updatable Result Sets
          • Deleting a Row
          • Inserting a Row
          • Updating a Row
        • Retrieving Large Object Data
    •  Tracking JDBC Calls with DataDirect Spy
      •  Enabling DataDirect Spy
        • Using the JDBC Driver Manager
        • Using JDBC Data Sources
        • DataDirect Spy Attributes
    •  Troubleshooting
      •  Troubleshooting Your Application
        • Turning On and Off DataDirect Spy Logging
        • DataDirect Spy Log Example
      •  Troubleshooting Connection Pooling
        • Enabling Tracing with the setTracing Method
        • Pool Manager Trace File Example
      •  Troubleshooting Statement Pooling
        • Generating an Export File with the exportStatement Method
        • Statement Pool Export File Example
      •  Configuring Logging
        • Using the JVM for Logging
•  Reference
  •  Connection Property Descriptions
    • AccountingInfo
    • ApplicationName
    • BatchMechanism
    • BulkLoadBatchSize
    • CatalogOptions
    • ClientHostName
    • ClientUser
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CryptoProtocolVersion
    • DatabaseName
    • EnableCancelTimeout
    • EncryptionMethod
    • HostNameInCertificate
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • JavaDoubleToString
    • KeyPassword
    • KeyStore
    • KeyStorePassword
    • LoginTimeout
    • MaxNumericPrecision
    • MaxNumericScale
    • MaxPooledStatements
    • MaxVarcharSize
    • Password
    • PortNumber
    • ProgramID
    • QueryTimeout
    • ResultSetMetaDataOptions
    • ServerName
    • SpyAttributes
    • SupportsCatalogs
    • TransactionErrorBehavior
    • TrustStore
    • TrustStorePassword
    • User
    • ValidateServerCertificate
    • VarcharClobThreshold
  • getTypeInfo()
  •  JDBC Support
    • JDBC and JVM Compatibility
    •  Supported Functionality
      • Array
      • Blob
      • CallableStatement
      • Clob
      • Connection
      • ConnectionEventListener
      • ConnectionPoolDataSource
      • DatabaseMetaData
      • DataSource
      • Driver
      • ParameterMetaData
      • PooledConnection
      • PreparedStatement
      • Ref
      • ResultSet
      • ResultSetMetaData
      • RowSet
      • SavePoint
      • Statement
      • StatementEventListener
      • Struct
      • XAConnection
      • XADataSource
      • XAResource
  •  JDBC Extensions
    • Using JDBC Wrapper Methods to Access JDBC Extensions
    • DatabaseMetaData Interface
    • DDBulkLoad Interface
    • ExtConnection Interface
    • ExtDatabaseMetaData Interface
    • ExtLogControl Class
  •  SQL Escape Sequences for JDBC
    • Date, Time, and Timestamp Escape Sequences
    • Scalar Functions
    • Outer Join Escape Sequences
    • LIKE Escape Character Sequence for Wildcards
    • Procedure Call Escape Sequences
  •  Designing JDBC Applications for Performance Optimization
    •  Using Database Metadata Methods
      • Minimizing the Use of Database Metadata Methods
      • Avoiding Search Patterns
      • Using a Dummy Query to Determine Table Characteristics
    •  Returning Data
      • Returning Long Data
      • Reducing the Size of Returned Data
      • Choosing the Right Data Type
      • Retrieving Result Sets
    •  Selecting JDBC Objects and Methods
      • Using Parameter Markers as Arguments to Stored Procedures
      • Using the Statement Object Instead of the PreparedStatement Object
      • Using Batches Instead of Prepared Statements
      • Choosing the Right Cursor
      • Using get Methods Effectively
      • Retrieving Auto Generated Keys
    •  Managing Connections and Updates
      • Managing Connections
      • Managing Commits in Transactions
      • Choosing the Right Transaction Model
      • Using updateXXX Methods
      • Using getBestRowIdentifier
•  Glossary
  • authentication
  • bulk load
  • client authentication
  • client load balancing
  • connection pooling
  • connection retry
  • connection URL
  • DataDirect Connection Pool Manager
  • DataDirect DB2 Package Manager
  • DataDirect Spy
  • DataDirect Test
  • data source
  • Driver Manager
  • failover
  • index
  • isolation level
  • J2EE
  • JDBC data source
  • JNDI
  • JTA
  • Kerberos
  • load balancing
  • locking level
  • NTLM authentication
  • OS authentication
  • reauthentication
  • resource adapter
  • Secure Socket Layer
  • SSL client and server authentication
  • Unicode
  • user ID and password authentication
• Copyright