Welcome to the Progress DataDirect for JDBC for Salesforce Driver
What's New in this Release?
Requirements
Version String Information
Data Source and Driver Classes
Connection URL
Connection Properties
Mapping Objects to Tables
Data Types
getTypeInfo()
Contacting Technical Support
Getting Started
Setting the Classpath
Data Source and Driver Classes
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
Testing a data source connection
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
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
Using Connection Properties
Required Properties
Mapping Properties
Authentication Properties
Failover Properties
Proxy Server Properties
Web Service Properties
Bulk API Properties
Timeout Properties
Statement Pooling Properties
Additional Properties
Connecting Through a Proxy Server
Performance Considerations
Client-Side Caches
Creating a Cache
Modifying a Cache Definition
Disabling and Enabling a Cache
Refreshing Cache Data
Dropping a Cache
Caching MetaData
Catalog Tables
SYSTEM_CACHES Catalog Table
SYSTEM_CACHE_REFERENCES Catalog Table
SYSTEM_REMOTE_SESSIONS Catalog Table
SYSTEM_SESSIONS Catalog Table
Reports
Authentication
Configuring user ID/password authentication
Configuring OAuth 2.0 authentication
Data Encryption
Using Identifiers
Failover Support
IP Addresses
Timeouts
Views and Remote/Local Tables
SQL escape sequences
Isolation Levels
Scrollable cursors
Unicode support
Error Handling
Large Object (LOB) Support
Parameter Metadata Support
Insert and Update Statements
Select Statements
ResultSet MetaData Support
Rowset Support
Auto-Generated Keys Support
Connection Pool Manager
How connection pooling works
The connection pool environment
The DataDirect Connection Pool Manager
Using a connection pool DataSource 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
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
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
CSV files
Bulk load configuration file
Bulk load configuration file schema
Character set conversions
External overflow files
Discard file
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 DriverManager
Using JDBC Data Sources
DataDirect Spy attributes
Connection Property Descriptions
AccessToken
AuthenticationMethod
BulkFetchThreshold
BulkLoadAsync
BulkLoadBatchSize
BulkLoadConcurrencyMode
BulkLoadPollInterval
BulkLoadThreshold
CatalogOptions
ClientID
ClientSecret
ConfigOptions
AuditColumns (Configuration Option)
CustomSuffix (Configuration Option)
KeywordConflictSuffix (Configuration Option)
MapSystemColumnNames (Configuration Option)
NumberFieldMapping (Configuration Option)
UppercaseIdentifiers (Configuration Option)
ConnectionRetryCount
ConnectionRetryDelay
ConvertNull
CreateMap
EnableBulkFetch
EnableBulkLoad
EnablePKChunking
FetchSize
ImportStatementPool
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
LogConfigFile
LoginTimeout
MaxPooledStatements
Password
PKChunkSize
ProxyHost
ProxyPassword
ProxyPort
ProxyUser
ReadOnly
RefreshToken
RegisterStatementPoolMonitorMBean
SchemaMap
SecurityToken
ServerName
SpyAttributes
StmtCallLimit
StmtCallLimitBehavior
TransactionMode
User
WSCompressData
WSFetchSize
WSPoolSize
WSRetryCount
WSTimeout
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 for Logging
Using the Driver for Logging
Supported SQL Statements and Extensions
Alter Cache (EXT)
Relational Caches
Alter Index
Alter Sequence
Alter Session (EXT)
Alter Table
Altering a Remote Table
Add Clause: Columns
Add Clause: Constraints
Drop Clause: Columns
Altering a Local Table
Add Clause: Columns
Add Clause: Constraints
Drop Clause: Columns
Drop Clause: Constraints
Rename Clause
Create Cache (EXT)
Relational Caches
Referencing Clause
Refresh Interval Clause
Initial Check Clause
Persist Clause
Enabled Clause
Call Limit Clause
Filter Clause
Create Index
Create Sequence
Next Value For Clause
Create Table
Creating a Remote Table
Column Definition for Remote Tables
Constraint Definition for Remote Tables
Foreign Key Clause
Creating a Local Table
Column Definition for Local Tables
Constraint Definition for Local Tables
Create View
Delete
Drop Cache (EXT)
Drop Index
Drop Sequence
Drop Table
Drop View
Explain Plan
Insert
Specifying an External ID Column
Refresh Cache (EXT)
Refresh Map (EXT)
Select
Select Clause
Aggregate Functions
From Clause
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
Update
SQL Expressions
Column Names
Literals
Character String Literals
Numeric Literals
Binary Literals
Date/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
Native and Refresh Escape Sequences
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
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
Copyright
Welcome to the Progress DataDirect for JDBC for Salesforce Driver
Copyright
connection_pool
statement_pool
datadirect_test
datadirect_spy
sql_escapes
jdbc_support
application_performance