Using This Reference
JDBC Support
JDBC/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 (Salesforce Driver)
DDBulkLoad Interface
ExtConnection Interface
ExtDatabaseMetaData Interface
ExtLogControl Class
Supported SQL Functionality and Extensions for The Driver for Apache Hive
Data Definition Language (DDL)
Selecting Data With the Driver
Select List
Between Clause
Column Name Qualification
From Clause
Group By Clause
Having Clause
Order By Clause
For Update Clause
Set Operators
Subqueries
SQL Expressions
Constants
Numeric Operators
Character Operator
Relational Operators
Logical Operators
Functions
Restrictions
Insert and Update Restrictions
Stored Procedures
Views
Other Restrictions
Supported SQL Statements and Extensions for the Salesforce Driver
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
Checkpoint
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 Schema (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
Set Checkpoint Defrag
Set Logsize
Update
SQL Expressions
Column Names
Literals
Character String Literals
Integer Literals
Numeric Literals
Binary Literals
Date/Time 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
getTypeInfo()
DB2 Driver
Informix Driver
MySQL Driver
Oracle Driver
PostgreSQL Driver
Progress OpenEdge Driver
SQL Server Driver
Sybase Driver
The Driver for Apache Hive
Greenplum Driver
Salesforce Driver
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()
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
Using DataDirect Test
DataDirect Test Tutorial
Configuring DataDirect Test
Starting DataDirect Test
Connecting Using DataDirect Test
Connecting Using a Data Source
Connecting Using Driver/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
Large Object (LOB) Support
Tracking JDBC Calls with DataDirect Spy
Enabling DataDirect Spy
Using the JDBC Driver Manager
Using JDBC Data Sources
DataDirect Spy Attributes
Connection Pool Manager
About JDBC Connection Pools
Configuring the Connection Pool
Understanding the Maximum Pool Size
Using Reauthentication with the Pool Manager
Checking the Pool Manager Version
Enabling Pool Manager Tracing
Using a DataDirect Connection Pool
Creating a Driver DataSource Object
Creating the Connection Pool
Connecting Using a Connection Pool
Closing the Connection Pool
DataDirect Connection Pool Manager Interfaces
PooledConnectionDataSourceFactory
PooledConnectionDataSource
ConnectionPoolMonitor
Statement Pool Monitor
Enabling Statement Pooling
Accessing the Statement Pool Monitor
Using JMX
Using Progress DataDirect-Specific Methods
Using the poolEntries() Method
Example: 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
Troubleshooting
Troubleshooting Your Application
Turning On and Off DataDirect Spy Logging
DataDirect Spy Log Example
Troubleshooting Connection Pooling
Enabling Pool Manager Tracing
Pool Manager Trace File Example
Troubleshooting Statement Pooling
Generating a Statement Pool Export File
Statement Pool Export File Example
Using Java Logging (Salesforce)
Logging Components
JDBC API Logger
SQL Engine Logger
Web Service Adapter Logger
Configuring Logging
Using the JVM
Using the Driver
Using This Reference
Using the Driver