• Welcome to the Progress DataDirect for JDBC Drivers Reference
•  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
  •  Using Java logging
    •  Logging components
      • JDBC API logger
      • SQL engine logger
      • Web service adapter logger
    •  Configuring logging
      • Using the JVM
      • Using the driver
  • Contacting Technical Support
•  Failover
  • Connection failover
  • Extended connection failover
  • Select connection failover
  • Guidelines for primary and alternate servers
  • Using client load balancing
  • Using connection retry
•  Client information
  •  How databases store client information
    • Storing client information
  • Returning client Information
  • Returning metadata about client information locations
•  JDBC support
  • 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
    • String functions
    • Numeric functions
    • Date and time Functions
    • System functions
  • Outer join escape sequences
  • LIKE escape character sequence for wildcards
  • Native and refresh 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
•  DataDirect tools
  •  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 parameter metadata
      • Establishing savepoints
      •  Updatable result sets
        • Deleting a row
        • Inserting a row
        • Updating a row
      • Retrieving large object (LOB) data
  •  Connection Pool Manager
    •  How connection pooling works
      • The connection pool environment
      • The DataDirect Connection Pool Manager
      • Using a connection pool DataSource object
      • Using Reauthentication
    •  Implementing DataDirect connection pooling
      • Creating a driver DataSource object
      • Creating the connection pool
    •  Configuring the connection pool
      • Configuring the maximum pool size
      • Using Reauthentication with the Pool Manager
    • 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
    •  Using DataDirect-specific methods to access the Statement Pool Monitor
      • Using the poolEntries method
      • Generating a list of statements in the statement pool
    • Using JMX to access the Statement Pool Monitor
    • 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
  •  Tracking JDBC calls with DataDirect Spy
    •  Enabling DataDirect Spy
      • Using the JDBC DriverManager
      • Using JDBC data sources
      • DataDirect Spy attributes