•  Welcome to the Progress DataDirect for JDBC for Oracle Sales Cloud Driver
  • Release highlights
  • Requirements
  • Driver and DataSource classes
  • Connection URL
  • Version string information
  • Connection properties and configuration options
  •  Data types
    • getTypeInfo()
  • Mapping objects to tables
  • Contacting Technical Support
•  Getting started
  • Driver and DataSource classes
  •  Connecting using the DriverManager
    • Setting the class path
    • Passing the connection URL
    • Testing the connection
  •  Connecting using data sources
    • How data sources are implemented
    • Creating data sources
    • Calling a DataSource in an application
•  Using the driver
  •  Connecting from an application
    • Driver and DataSource classes
    •  Connecting using the DriverManager
      • Setting the class path
      • Passing the connection URL
      • Testing the connection
    •  Connecting using data sources
      • How data sources are implemented
      • Creating data sources
      • Calling a DataSource in an application
  •  Using connection properties
    • Required properties
    • Mapping properties
    • Web service properties
    • Proxy server properties
    • Additional properties
  • Proxy server support
  • Unicode support
  • Data encryption
  •  Catalog Tables
    • SYSTEM_REMOTE_SESSIONS catalog table
    • SYSTEM_SESSIONS catalog table
  • Identifiers
  • Timeouts
  • Scrollable cursors
  • Parameter metadata support
  • ResultSet metadata support
  • Error handling
  • Rowset support
  •  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
  •  Tracking JDBC calls with DataDirect Spy
    •  Enabling DataDirect Spy
      • Using the DriverManager
      • Using data sources
      • DataDirect Spy attributes
•  Connection property descriptions
  •  ConfigOptions
    • APIVersion (configuration option)
  • CreateMap
  • LogConfigFile
  • Password
  • ProxyHost
  • ProxyPassword
  • ProxyPort
  • ProxyUser
  • SchemaMap
  • ServerName
  • SpyAttributes
  • User
  • WSFetchSize
  • WSRetryCount
  • WSTimeout
•  Troubleshooting
  •  Troubleshooting your application
    • Turning on and off DataDirect Spy logging
  •  Using Java logging
    •  Logging components
      • JDBC API logger
      • SQL Engine logger
      • Web service adapter logger
    •  Configuring Logging
      • Using the JVM for logging
      • Using the Driver for Logging
  • Contacting Technical Support
•  Supported SQL functionality
  • Alter Session (EXT)
  • Refresh Map (EXT)
  •  Select
    •  Select clause
      • Aggregate functions
      •  From clause
        • Outer join escape sequences
        • Join in a From clause
        • Subquery in a From clause
        • Where clause
        • Group By clause
        • Having clause
        • Union operator
        • Intersect operator
        • Except and Minus operators
        • Order By clause
        • Limit clause
  •  SQL expressions
    • Column names
    •  Literals
      • Character string literals
      • Numeric literals
      • Binary literals
      • Date and time literals
      • Integer literals
    •  Operators
      • Unary operator
      • Binary operator
      • Arithmetic operators
      • Concatenation operator
      • Comparison operators
      • Logical operators
      • Operator precedence
    • Functions
    • Conditions
  •  Subqueries
    • IN predicate
    • EXISTS predicate
    • UNIQUE predicate
    • Correlated subqueries
•  SQL escape sequences for JDBC
  • Date, time, and timestamp escape sequences
  • Scalar functions
  • Outer join escape sequences
  • LIKE escape character sequence for wildcards
•  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
  • DatabaseMetaData interface
  • ExtLogControl class
•  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