Default
A
about
DataDirect Connection Pool Manager
DataDirect Spy
DataDirect Statement Pool Monitor
extended connection failover
select failover
statement pooling
AccountingInfo
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
SQL Server
Sybase
Action (Oracle)
addresses, IP
AddToCreateTable (DB2)
AllowImplicitResultSetCloseForXA property (DB2)
alternate database servers
about
AlternateServers
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
guidelines for
specifying
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
AlternateID (DB2)
AlternateServers
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
AlwaysReportTriggerResults (SQL Server)
ANSI_NULLS option (SQL Server)
ansinull option (Sybase)
Apache Hive
authentication
auto-generated keys
cancel request timeout
connection properties
ApplicationName
AuthenticationMethod 1, 2
ClientHostName
ClientUser
ConnectionRetryDelay
ConvertNull
EnableCancelTimeout
ImportStatementPool
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
LoginTimeout
MaxPooledStatements (alias for MaxStatements)
MaxStatements
Password
PortNumber
QueryTimeout 1, 2
ServerName
SpyAttributes
TransactionMode
User
WireProtocolVersion
connection URL
data source class
data types
database limitations
delegation of credentials
driver class
isolation levels
JSR 114, Rowsets
JTA support
Kerberos authentication
configuring
Kerberos configuration file
kinit command (UNIX and Linux)
MIT Kerberos
obtaining a javax.security.auth.Subject
permissions
product requirements
service principal name
Ticket Granting Ticket (TGT)
user credentials, specifying
Windows Active Directory Kerberos
Large Object (LOB) support
locking levels
parameter metadata
performance considerations
protocol
HiveServer1
HiveServer2
ResultSet metadata
Rowsets
SQL escape sequences
timeout
query
updatable result sets
user ID/password authentication
about
configuring
applet
Java 2 Platform, permissions for
untrusted 1, 2
using drivers with
application
connecting with drivers
connection pooling
data source, calling in
multi-lingual
optimizing for performance
See performance optimization
resource adapters
permissions for
using directly
statement pooling
Unicode support
application server
Enterprise Information System (EIS)
example, setting up resource adapters
J2EE Connector Architecture
resource archive (RAR) file
Service Provider Interface (SPI)
using
drivers with
resource adapters with
ApplicationIntent
SQL Server
ApplicationName
Apache Hive
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
SQL Server
Sybase
arrays (Oracle)
attributes, DB2 Workload Manager (WLM)
authentication
Apache Hive
client
DB2
Oracle
client (SSL)
DB2
Kerberos
Apache Hive
DB2
Oracle
SQL Server
Sybase
NTLM
Oracle
SQL Server
server (SSL)
support
Sybase
types of
user
user ID/password
Apache Hive
DB2
Oracle
Sybase
AuthenticationMethod
Apache Hive 1, 2
DB2 1, 2
Oracle 1, 2
SQL Server 1, 2
Sybase 1, 2
auto-generated keys
Apache Hive, driver for
DB2
Informix
MySQL
Oracle
Progress OpenEdge
Salesforce
SQL Server
Sybase
B
batch inserts and updates
DB2 1, 2
Oracle 1, 2
SQL Server
Sybase 1, 2
batch inserts, using bulk load for
BatchPerformanceWorkaround
DB2
Oracle
Sybase
BatchUpdateException (SQL Server)
binary stream data (DB2)
Blob
and binary stream data (DB2)
searches
Informix
Progress OpenEdge
using to return long data
Apache Hive
Greenplum
MySQL
PostgreSQL
Salesforce
SQL Server
Sybase
bulk load
batch inserts
BulkLoadAsync (Salesforce)
BulkLoadBatchSize
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Salesforce
SQL Server
Sybase
BulkLoadConcurrencyMode (Salesforce)
BulkLoadPollInterval (Salesforce)
BulkLoadThreshold (Salesforce)
character set conversions
configuring
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Salesforce
SQL Server
Sybase
CSV files, using
discard file
EnableBulkLoad
Oracle
Salesforce
SQL Server
Sybase
exporting data to a CSV file from
database table
ResultSet object
external overflow files
logging
permissions
single inserts/updates/deletes (Salesforce)
specifying the operation
VarcharClobThreshold
Greenplum
PostgreSQL
bulk load configuration file
about
schema
verifying
BulkLoadAsync (Salesforce)
BulkLoadBatchSize
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Salesforce
SQL Server
Sybase
BulkLoadConcurrencyMode (Salesforce)
BulkLoadOptions
Oracle
SQL Server
BulkLoadPollInterval (Salesforce)
BulkLoadThreshold (Salesforce)
C
caches, client-side
caching long data
DB2
SQL Server
Sybase
cancel request timeout
Apache Hive, driver for
DB2
Greenplum
Oracle
PostgreSQL
SQL Server
Sybase
catalog table views (DB2)
catalog tables (Salesforce)
CatalogOptions
DB2
Greenplum
Oracle
Progress OpenEdge
CatalogSchema (DB2)
certificate
SSL
validation
DB2
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
Certificate Authority (CA), SSL 1, 2
Character data, converting
DB2
Informix
MySQL
Oracle
SQL Server
Sybase
character set conversions, bulk load
CharsetFor65535 (DB2)
choosing an optimization class (DB2)
classes
data source and driver
DB2
Greenplum 1, 2
Informix
MySQL
Oracle
PostgreSQL 1, 2
Progress OpenEdge
Salesforce
SQL Server
Sybase
J2EE Connector Architecture resource adapter
DB2
Informix
MySQL
Oracle
SQL Server
Sybase
CLASSPATH, setting
example
on UNIX
on Windows
variable
clear text user ID and password (DB2) 1, 2
client authentication
about
DB2
Oracle
configuring
DB2
Oracle
SSL
client information
about
DB2
Greenplum
how databases store
Informix
maximum length of a value, determining
metadata, returning
MySQL
Oracle
PostgreSQL
Progress OpenEdge
returning
SQL Server
storing
Sybase
client load balancing, about
ClientHostName
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
SQL Server
Sybase
ClientID (Oracle)
client-side caches
ClientUser
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
SQL Server
Sybase
Clob
searches
Informix
Progress OpenEdge
using to return long data
Apache Hive
Greenplum
MySQL
PostgreSQL
Salesforce
SQL Server
Sybase
Clob data, converting
DB2
MySQL
code page
converting Character data
DB2
Informix
MySQL
Oracle
SQL Server
stored as bit data (DB2)
Sybase
converting Clob data
DB2
Informix
MySQL
SQL Server
Sybase
overriding
DB2
Informix
MySQL
Oracle
SQL Server
Sybase
CodePageOverride
DB2
Informix
MySQL
Oracle
SQL Server
Sybase
Comma-Separated Value (CSV) files
See CSV files
CommitBehavior (Oracle)
ConcurrentAccessResolution (DB2)
ConfigOptions (Salesforce)
configuration file, database
configuring
bulk load
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Salesforce
SQL Server
Sybase
client authentication
DB2
Oracle
encryption
DB2
MySQL
Oracle
Oracle Advanced Security
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
SSL
Oracle
Sybase
failover
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
Kerberos authentication
Apache Hive
DB2
Oracle
SQL Server
Sybase
NTLM authentication
Oracle
SQL Server
user ID/password authentication
Apache Hive
DB2
Oracle
SQL Server
Sybase
connect descriptor parameters in tnsnames.ora file (Oracle)
connecting
connection URL example for SQL Server named instances
data sources
Driver Manager, JDBC
example
Driver Manager and drivers
JDBC data source
proxy server (Salesforce)
quick start guide to
SQL Server named instances
connection failover
about 1, 2
connection retry
load balancing and
connection pooling
ConnectionEventListener interface
example
transactions with connection pooling
transactions without connection pooling
javax.sql.ConnectionPoolDataSource interface
using
connection properties
Apache Hive, driver for
DB2 1, 2
driver
Greenplum
Informix
MySQL 1, 2
Oracle
PostgreSQL 1, 2
Progress OpenEdge
Salesforce
specifying
SQL Server 1, 2, 3
Sybase 1, 2
connection retry
Apache Hive 1, 2
ConnectionRetryCount
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
ConnectionRetryDelay
Apache Hive
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce 1, 2
SQL Server
Sybase
connection retry, about
connection URL
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
ConnectionPoolDataSource object, connecting with
ConnectionRetryCount
Apache Hive
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
ConnectionRetryDelay
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
connections
connection pooling
connection properties, specifying
connection URLs
data sources
JDBC Driver Manager
orphaned (SQL Server)
permissions 1, 2
testing
converting
Character data
DB2
Informix
MySQL
Oracle
SQL Server
Sybase
Clob data
DB2
MySQL
null values
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
UTF-16 encoding
ConvertNull
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
CREATE statements (DB2)
CreateDB (Salesforce)
CreateDefaultPackage (DB2)
creating DB2 packages
CSV files
example
using
CURRENT SCHEMA register (DB2)
CURRENT SQLID register (DB2)
CurrentFunctionPath (DB2)
CurrentQueryOptimization (DB2)
cursors
Apache Hive, driver for
cursor behavior in transactions (DB2)
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
D
data encryption
data integrity (Oracle)
data source class
Apache Hive, driver for
data sources
application, calling in
connecting with
connection pooling
creating data sources
DataSource interface
example
using File System JNDI Provider
using JNDI Provider for LDAP
implementing
registering with JNDI
data types
Apache Hive, driver for
date/time (Oracle9i and higher)
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
supported
Sybase
Database (alias for DatabaseName)
DB2 1, 2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
database configuration file
database errors
DATABASE SQL statement (Informix)
DatabaseName
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
DataDirect Connect Series for JDBC drivers
DB2
Greenplum
Informix
MySQL
Oracle
Progress OpenEdge
Salesforce
SQL Server
Sybase
DataDirect Connection Pool Manager, about
DataDirect DB2 Package Manager 1, 2
DataDirect Spy
about
ServerName connection property
Progress OpenEdge
SpyAttributes connection property
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server 1, 2
Sybase
DataDirect Statement Pool Monitor, about
DataDirect Test
DataIntegrityLevel (Oracle)
DataIntegrityTypes (Oracle)
DataSource object
calling in an application
connecting with 1, 2
connection pooling, ConnectionPoolDataSource interface
retrieving
date format (Informix)
date/time data types (Oracle9i and higher)
DateTimeInputParameterType (SQL Server)
DateTimeOutputParameterType (SQL Server)
DB2
alternate database servers, specifying
authentication 1, 2, 3
auto-generated keys
batch inserts and updates 1, 2
binary stream data
bulk load, configuring
caching long data
cancel request timeout
catalog table views
classes, data source and driver
clear text user ID and password 1, 2
client authentication
about
configuring 1, 2
client information
closing result sets in distributed transactions automatically
connection properties
AccountingInfo
AddToCreateTable
AllowImplicitResultSetCloseForXA
AlternateId
AlternateServers
ApplicationName
AuthenticationMethod 1, 2
BatchPerformanceWorkaround
BulkLoadBatchSize
CatalogOptions
CatalogSchema
CharsetFor65535
ClientHostName
ClientUser
CodePageOverride
ConcurrentAccessResolution
ConnectionRetryCount
ConnectionRetryDelay 1, 2
ConvertNull
CreateDefaultPackage
CurrentFunctionPath
CurrentQueryOptimization
Database (alias for DatabaseName) 1, 2
DatabaseName
DynamicSections
EnableCancelTimeout
EncryptionMethod
FailoverGranularity
FailoverMode
FailoverPreconnect
for connection failover
for DB2 packages
GrantExecute
HostNameInCertificate
ImportStatementPool
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
JDBCBehavior
KeyPassword
KeyStore
KeyStorePassword
LoadBalancing
LocationName
LoginTimeout
LongDataCacheSize
MaxPooledStatements
PackageCollection
PackageOwner
Password
PortNumber
ProgramID
QueryTimeout
ReplacePackage
ResultSetMetaDataOptions
SendStreamAsBlob
ServerName
SpyAttributes
StripNewlines
TrustStore
TrustStorePassword
UseCurrentSchema
User
ValidateServerCertificate
WithHoldCursors
XMLDescribeType
connection retry 1, 2
connection URL
CREATE statements
CURRENT SCHEMA register
CURRENT SQLID register
cursor behavior
data types
DataDirect DB2 Package Manager
DB2 packages
creating by copying packages (z/OS and i)
creating using connection properties
creating using DB2 Package Manager
creating using list files
default catalog schema
delegation of credentials
dynamic sections 1, 2
encryption
configuring
DES
user ID and password
encryption, user ID and password
failover
High Availability Disaster Recovery (HADR) 1, 2, 3
isolation levels
J2EE Connector Architecture resource adapter class
JSR 114, Rowsets
JTA support
Kerberos authentication
about
configuring
javax.security.auth.Subject
Kerberos configuration file
kinit command (UNIX and Linux)
MIT Kerberos
permissions
product requirements 1, 2
service principal name
Ticket Granting Ticket (TGT)
user credentials, specifying
Windows Active Directory Kerberos
load balancing
LOB support
newline characters
non-default schema, using
null values, handling for data conversions
optimization class
choosing
specifying
parameter metadata 1, 2
performance considerations
prepared statement pool size, setting
primary server, specifying
pureScale
reauthentication
ResultSet metadata 1, 2
Rowsets
schemas for catalog methods 1, 2
scrollable cursors, using
SSL encryption, configuring
table name information in ResultSet metadata, returning
timeout
connection
query
transaction level workload balancing
unqualified function names
URL
user ID/password authentication
about
configuring
Workload Manager (WLM) 1, 2
Workload Manager (WLM) service class
workloads
about
performance
XML
inserting
returning
updating
DB2 packages
connection properties
for creating
GrantExecute
PackageCollection
PackageOwner
ReplacePackage
creating
automatically
copying packages (z/OS and i)
using connection properties
using DataDirect DB2 Package Manager
using list files
DataDirect DB2 Package Manager
dynamic sections
example
DB2 for i
DB2 for Linux/UNIX/Windows
DB2 for z/OS
DB2 Workload Manager (WLM) attributes
DBDate (Informix)
DDBulkLoad object, using
default catalog schema (DB2)
delegation of credentials for Kerberos
Apache Hive
DB2
Oracle
SQL Server
Sybase
DELIMIDENT environment variable, setting (Informix)
deployment descriptor, resource adapters 1, 2
DescribeInputParameters (SQL Server)
DescribeOutputParameters (SQL Server)
discard file for bulk load
distributed transactions
See JTA support
DLL, NTLM authentication
Oracle
SQL Server
DML with results (SQL Server)
Domain (SQL Server)
double quote (") characters in SQL statements (Informix)
driver class
Apache Hive
driver classes
DB2
Greenplum 1, 2
Informix
MySQL
Oracle
PostgreSQL 1, 2
Progress OpenEdge 1, 2
Salesforce
SQL Server
Sybase 1, 2
driver errors
DynamicSections (DB2)
E
EditionName (Oracle)
element descriptions
EnableBulkLoad
Oracle
Salesforce
SQL Server
Sybase
EnableCancelTimeout
Apache Hive, driver for
DB2
Oracle
SQL Server
Sybase
EnableServerResultCache (Oracle 11g)
encryption
data
DB2
MySQL
Oracle
performance optimization
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
SSL
support
Sybase
types of
EncryptionMethod
DB2
Greenplum
MySQL
Oracle
Progress OpenEdge
SQL Server
Sybase
Enterprise Information System (EIS)
error handling
ErrorBehavior (Sybase)
example
connection pooling data source
connection URL
for SQL Server named instances
specifying
CSV file
data source
File System JNDI Provider, using
JNDI Provider for LDAP, using
DB2 packages
DB2 for i
DB2 for Linux/UNIX/Windows
DB2 for z/OS
Driver Manager, using to connect
inserting data into an array (Oracle)
inserting data into an object (Oracle)
IPv4/IPv6
logging, enabling for bulk load 1, 2
obtaining a javax.security.auth.Subject for authentication
Apache Hive
DB2
Oracle
SQL Server
Sybase
permissions, granting access to temporary files
reauthentication
REF CURSOR (Oracle) 1, 2
registering driver using Class.forName()
resource adapters
application using directly
using with a J2EE application server
returning REF CURSORs (Oracle)
selecting data from an array (Oracle)
selecting data from an object (Oracle)
setting CLASSPATH
on UNIX
on Windows
transactions
with connection pooling
without connection pooling
exporting data for bulk load
extended connection failover
external overflow files, bulk load
F
failover
about
AlternateServers
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
FailoverGranularity
DB2
Informix
MySQL
Oracle
Progress OpenEdge
SQL Server
Sybase
FailoverMode
DB2
Informix
MySQL
Oracle
Progress OpenEdge
SQL Server
Sybase
FailoverPreconnect
DB2
Informix
MySQL
Oracle
Progress OpenEdge
SQL Server
Sybase
FetchBufferSize (Informix)
FetchSize (Salesforce)
FetchTSWTZasTimestamp (Oracle)
FetchTSWTZAsTimestamp (SQL Server)
FetchTWFSasTime (Sybase)
File System JNDI Provider
G
getColumns(), type of metadata returned
DB2
Oracle
Progress OpenEdge
getting version information of Web Service API (Salesforce)
GrantExecute (DB2)
Greenplum
alternate server, specifying
Blobs and Clobs, using to return long data
bulk load, configuring
cancel request timeout
classes, data source and driver 1, 2
client information, storing and returning
connection properties
AccountingInfo
AlternateServers
ApplicationName
BulkLoadBatchSize
CatalogOptions
ClientHostName
ClientUser
ConnectionRetryCount
ConnectionRetryDelay 1, 2
ConvertNull
Database (alias for DatabaseName) 1, 2
DatabaseName
EncryptionMethod
HostNameInCertificate
ImportStatementPool
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
KeyPassword
KeyStore
KeyStorePassword
LoadBalancing
LoginTimeout
MaxLongVarcharSize
MaxNumericPrecision
MaxNumericScale 1, 2
MaxPooledStatements
MaxStatements (alias for MaxPooledStatements)
MaxVarcharSize
Password
PortNumber
ProgramID
QueryTimeout
ResultSetMetaDataOptions
ServerName
SpyAttributes
SupportsCatalogs
TransactionErrorBehavior
TrustStore
TrustStorePassword
User
ValidateServerCertificate
VarcharClobThreshold
connection retry 1, 2
connection URL
data types
failover
isolation levels 1, 2
JSR 114, Rowsets
JTA support
Large Object (LOB) support
load balancing
null values, handling for data conversions
parameter metadata
prepared statement pool size, setting
primary server, specifying
ResultSet metadata 1, 2
Rowsets
scrollable cursors, using
SQL escape sequences
timeout
connection
query
Greenplum driver
stored procedures
guidelines for primary and alternate servers
H
handshake, SSL
High Availability Disaster Recovery (HADR) 1, 2, 3
HiveServer1, supported Apache Hive and distribution versions
HiveServer2, supported Apache Hive and distribution versions
HostNameInCertificate
DB2
Greenplum
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
HostProcess (alias for ProgramID) (SQL Server)
I
identifiers, using
ImportStatementPool
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
Informix
auto-generated keys
Blob and Clob searches
bulk load, configuring
classes, data source and driver
client information
connection properties
AccountingInfo
AlternateServers
ApplicationName
BulkLoadBatchSize
ClientHostName
ClientUser
CodePageOverride
ConnectionRetryCount
ConnectionRetryDelay 1, 2, 3, 4
ConvertNull
Database (alias for DatabaseName) 1, 2
DatabaseName
DBDate
FailoverGranularity
FailoverMode
FailoverPreconnect
FetchBufferSize
for connection failover
ImportStatementPool
InformixServer
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
JDBCBehavior
LoadBalancing
LoginTimeout
MaxPooledStatements
Password
PortNumber
ProgramID
QueryTimeout
ResultSetMetaDataOptions
ServerName
SpyAttributes
UseDelmitedIdentifier
User
connection retry
connection URL
data types
DATABASE SQL statement, using
date format
DELIMIDENT environment variable, setting
double quote (") characters in SQL statements, interpreting
failover
isolation levels
J2EE Connector Architecture resource adapter class
JSR 114, Rowsets
JTA support
load balancing
null values, handling for data conversions
parameter metadata
performance considerations
prepared statement pool size, setting
primary server, specifying
ResultSet metadata 1, 2
Rowsets
scrollable cursors
table name information in ResultSet metadata, returning 1, 2, 3, 4
timeout, connection
timeout, query
URL
InformixServer (Informix)
initial column buffer size (Oracle)
InitialColumnBufferSize (Oracle)
InitializationString
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
InOrderColumnAccess (MySQL)
insensitive cursors, access to temporary files required
InsensitiveResultSetBufferSize
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
inserting XML
DB2
Oracle
PostgreSQL
SQL Server
interactive_timeout variable (MySQL)
InteractiveClient (MySQL)
IP addresses (IPv4/IPv6)
isolation levels
Apache Hive, driver for
Snapshot isolation level (SQL Server)
support
DB2
Greenplum
Informix
MySQL 1, 2
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
TRANSACTION_SNAPSHOT constant (SQL Server)
J
J2EE application server, example using resource adapters with
J2EE Connector Architecture
resource adapter class
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
SQL Server
Sybase
Service Provider Interface (SPI)
Java 2 Platform
permissions
bulk load
for establishing connections
granting access to temporary files
Java properties, accessing
Kerberos authentication
Security Manager 1, 2
using drivers on
Java Authentication and Authorization Service (JAAS) login module
Apache Hive
DB2
Oracle 1, 2
SQL Server
Sybase
Java Management Extensions (JMX) MBean, DataDirect Statement Pool Monitor
Java Naming Directory Interface (JNDI)
data source
application, using in
connecting with
example
registering with
initializing environment 1, 2
naming service
Java properties, accessing
Java Security Architecture
relationship to Security Manager
specification
Java Transaction API
JavaDoubleToString
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
javax.security.auth.Subject
Apache Hive
DB2
Oracle 1, 2
SQL Server
Sybase
JConsole
JDBC 4.0
JDBC Connector
JDBC data sources
See data sources
JDBC data type mappings
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
JDBC Driver Manager
connecting with 1, 2
connection URL format
registering drivers 1, 2
JDBCBehavior
DB2
Informix
MySQL
Oracle
Progress OpenEdge
SQL Server
Sybase
JNDI Provider for LDAP
JSR 114, Rowsets
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge 1, 2
Salesforce
SQL Server
Sybase
JTA support
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle 1, 2
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
transaction
cleanup methods (SQL Server)
closing results sets automatically (DB2)
explicit cleanup (SQL Server) 1, 2
group identifier (SQL Server) 1, 2
timeout for orphaned transactions (SQL Server)
K
Kerberos authentication
about
Apache Hive
Oracle
SQL Server
Sybase
configuring
Apache Hive
DB2
Oracle
SQL Server
Sybase
delegation of credentials
Apache Hive
DB2
Oracle
SQL Server
Sybase
javax.security.auth.Subject
Apache Hive
DB2
Oracle
SQL Server
Sybase
kinit command (UNIX and Linux)
Apache Hive
DB2
Oracle
SQL Server
Sybase
MIT Kerberos
Apache Hive
DB2
Oracle
Sybase
permissions
Apache Hive
DB2
SQL Server
Sybase
product requirements
Apache Hive
DB2 1, 2
Oracle
SQL Server 1, 2
Sybase
service principal name
Apache Hive
DB2
Sybase 1, 2
Ticket Granting Ticket (TGT)
Apache Hive
DB2
Oracle
SQL Server
Sybase
user credentials, specifying
Apache Hive
DB2
Oracle
SQL Server
Sybase
using with reauthentication
Windows Active Directory Kerberos
Apache Hive
DB2
Oracle
SQL Server
Sybase
Kerberos configuration file
Apache Hive
DB2
Oracle
SQL Server
Sybase
Kerberos Key Distribution Center (KDC)
name, specifying
Apache Hive 1, 2, 3
DB2 1, 2, 3, 4
Oracle 1, 2, 3
SQL Server 1, 2, 3
Sybase 1, 2, 3
service principal name 1, 2, 3
Kerberos realm 1, 2, 3, 4
KeyPassword
DB2
Greenplum
MySQL
Oracle
PostgreSQLL
KeyStore
DB2
Greenplum
MySQL
Oracle
PostgreSQL
keystore, SSL
KeyStorePassword
DB2
Greenplum
MySQL
Oracle
PostgreSQL
kinit command, Kerberos authentication
Apache Hive
DB2
Oracle
SQL Server
Sybase
L
large binary object (DB2)
LDAP
linked servers (Oracle)
load balancing
about
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
LoadBalancing
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
LoadLibraryPath
Oracle
SQL Server
LOB support
Apache Hive, driver for
DB2
Greenplum
MySQL
PostgreSQL
Salesforce
SQL Server
Sybase
LobCommandSize (MySQL)
local tables (Salesforce)
LocationName (DB2)
locking levels
Apache Hive, driver for
LogConfigFile (Salesforce)
logging for bulk load
LoginTimeout
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
long data
caching
DB2
SQL Server
Sybase
using Blobs and Clobs to return
Apache Hive
Greenplum
MySQL
PostgreSQL
Salesforce
SQL Server
Sybase
LongDataCacheSize
DB2
SQL Server
Sybase
lost connections
extended connection failover
recovering work in progress
select failover
M
ManagedConnectionFactory class
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
SQL Server
Sybase
man-in-the-middle (MITM) attacks
DB2
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
mapping
objects to tables (Salesforce)
Oracle driver properties to tnsnames.ora
mapping objects to tables (Salesforce)
materialized views, Apache Hive
max_allowed_packet system variable (MySQL)
MaxLongVarcharSize
Greenplum
PostgreSQL
MaxNumericPrecision
Greenplum
PostgreSQL
MaxNumericScale
Greenplum
PostgreSQL
MaxPooledStatements
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
MaxPooledStatements (alias for MaxStatements)
Apache Hive
Salesforce
MaxStatements
Apache Hive, driver for
Salesforce
MaxVarcharSize
Greenplum
PostgreSQL
memory usage, tuning
BulkLoadBatchSize
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Salesforce
SQL Server
Sybase
FetchBufferSize (Informix)
InitialColumnBufferSize (Oracle)
InsensitiveResultSetBufferSize
Apache Hive
DB2
Informix
MySQL
Oracle
Progress OpenEdge
Salesforce
SQL Server
Sybase
LongDataCacheSize
DB2
SQL Server
Sybase
VarcharClobThreshold
Greenplum
PostgreSQL
metadata about client information
Microsoft Cluster Server (MSCS) 1, 2, 3
Microsoft SQL Server
See SQL Server
MIT Kerberos
Apache Hive
Oracle
Sybase
MITM attacks
DB2
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
modifyThreadGroup permission
multi-lingual applications
MySQL
alternate server, specifying
auto-generated keys
Blobs and Clobs, using to return long data
bulk load, configuring
certificate validation
classes, data source and driver
client information, storing and returning
connection properties
AccountingInfo
AlternateServers
ApplicationName
BulkLoadBatchSize
ClientHostName
ClientUser
CodePageOverride
ConnectionRetryCount
ConnectionRetryDelay
ConvertNull
Database (alias for DatabaseName) 1, 2
DatabaseName
EncryptionMethod
FailoverGranularity
FailoverMode
FailoverPreconnect
HostNameInCertificate
ImportStatementPool
InitializationString
InOrderColumnAccess
InsensitiveResultSetBufferSize
InteractiveClient
JavaDoubleToString
JDBCBehavior
KeyPassword
KeyStore
KeyStorePassword
LoadBalancing
LobCommandSize
LoginTimeout
MaxPooledStatements
Password
PortNumber
ProgramID
QueryTimeout
ResultSetMetaDataOptions
ServerName
SpyAttributes
TreatBinaryAsChar
TrustStore
TrustStorePassword
User
ValidateServerCertificate
connection retry 1, 2
connection URL
data types
encryption, configuring
failover
interactive_timeout variable
isolation levels 1, 2, 3
J2EE Connector Architecture resource adapter class
JSR 114, Rowsets
JTA support
Large Object (LOB) support
load balancing
max_allowed_packet system variable
null values, handling for data conversions
parameter metadata
prepared statement pool size, setting
primary server, specifying
ResultSet metadata 1, 2
Rowsets
scrollable cursors, using 1, 2
SQL escape sequences
timeout
connection
query
wait_timeout variable
N
named instances (SQL Server)
connecting to
permissions required for
specifying connections to for connection failover
NetAddress (SQL Server)
newline characters (DB2)
NewPassword (Oracle)
NLS_TIMESTAMP_FORMAT session parameter (Oracle9i and higher)
NLS_TIMESTAMP_TZ_FORMAT session parameter (Oracle9i and higher)
NTLM authentication
about
Oracle
SQL Server
configuring
Oracle
SQL Server
DLL
Oracle
SQL Server
product requirements
Oracle
SQL Server
null values
handling for data conversions
Apache Hive
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
interpreting
SQL Server
Sybase
O
object
ConnectionPoolDataSource, connecting with
DataSource
calling in an application
connecting with 1, 2
connection pooling
retrieving
DBClob (DB2)
DDBulkLoad
large binary (DB2)
mapping to tables (Salesforce)
OBJECT data type (Oracle) 1, 2
OpenEdge
See Progress OpenEdge
optimization class (DB2)
choosing
specifying
ORA_CHAR vs ORA_VARCHAR bindings for non-output parameters in a Where clause (Oracle)
Oracle
arrays
authentication
auto-generated keys
batch inserts and updates 1, 2
bulk load, configuring
cancel request timeout
classes, data source and driver
client authentication
about
configuring
client information
collection data types, using
configuring
client authentication
driver to retrieve connection information from tnsnames.ora file
Kerberos authentication
tnsnames.ora file
user ID/password authentication
connection information, retrieving from tnsnames.ora files
connection properties
AccountingInfo
Action
AlternateServers
ApplicationName
AuthenticationMethod 1, 2
BatchPerformanceWorkaround
BulkLoadBatchSize
BulkLoadOptions
CatalogOptions
ClientHostName
ClientID
ClientUser
CodePageOverride
CommitBehavior
ConnectionRetryCount
ConnectionRetryDelay 1, 2
ConvertNull
Database (alias for DatabaseName) 1, 2
DatabaseName
DataIntegrityLevel
DataIntegrityTypes
EditionName
EnableBulkLoad
EnableCancelTimeout
EnableServerResultCache
EncryptionMethod
FailoverGranularity
FailoverMode
FailoverPreconnect
FetchTSWTZasTimestamp
for connection failover
HostNameInCertificate
ImportStatementPool
InitialColumnBufferSize
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
JDBCBehavior
KeyPassword
KeyStore
KeyStorePassword
LoadBalancing
LoadLibraryPath
LoginTimeout
MaxPooledStatements
NewPassword
Password
PortNumber
ProgramID
QueryTimeout
ReportRecycleBin
ResultSetMetaDataOptions
SDUSize
SendFloatParametersAsString
ServerName
ServerType
ServiceName
SID
SpyAttributes
StringParamsMustMatchCharColumns
SupportLinks
SysLoginRole
TNSNamesFile
TNSServerName
TrustStore
TrustStorePassword
User
ValidateServerCertificate
WireProtocolMode
connection retry 1, 2
connection URL
data integrity
data types
date/time data types
delegation of credentials
double parameters
encryption
Oracle Advanced Security
encryption, configuring 1, 2, 3, 4
example, REF CURSOR 1, 2, 3
failover
float parameters
getting accurate column information for VARRAY, TABLE, and OBJECT data types
initial column buffer size
isolation levels 1, 2
J2EE Connector Architecture resource adapter class
JSR 114, Rowsets
JTA support 1, 2
Kerberos authentication
configuring
Java Authentication and Authorization Service (JAAS) login module
javax.security.auth.Subject
Kerberos configuration file
kinit command (UNIX and Linux)
MIT Kerberos
product requirements
Ticket Granting Ticket (TGT)
user credentials, specifying
Windows Active Directory Kerberos
linked servers
load balancing
NLS_TIMESTAMP_FORMAT session parameter
NLS_TIMESTAMP_TZ_FORMAT session parameter
NTLM authentication
about
configuring
DLL
product requirements
null values, handling for data conversions
ORA_CHAR vs ORA_VARCHAR bindings for non-output parameters in a Where clause
parameter metadata 1, 2
password, changing when a connection is established
prepared statement pool size, setting
primary server, specifying
Real Application Clusters (RAC) 1, 2, 3, 4, 5
reauthentication
REF CURSOR data types
restricted mode, connecting to
RESTRICTED SESSION system privilege
ResultSet metadata 1, 2
RETURNING clause
Rowsets
scrollable cursors
server-side resultset caching
Session Data Unit (SDU)
SYSDBA privilege
SYSOPER privilege
table name information in ResultSet metadata, returning
TIME_ZONE session parameter
timeout
connection
query
TIMESTAMP data type
timestamp data types
TIMESTAMP WITH LOCAL TIME ZONE data type
TIMESTAMP WITH TIME ZONE data type
timestamps
tnsnames.ora file
configuring driver to reference
configuring file
connect descriptor parameters
driver property mappings to
permissions for Java 2 Platform
TNSServerName
transaction redo changes
URL
user ID/password authentication
about
configuring 1, 2
using scrollable cursors
Wallet
XML
inserting
returning
updating
XMLType data type
Oracle Advanced Security
data integrity
encryption
orphaned connections (SQL Server)
overflow files, bulk load
P
PackageCollection (DB2)
PackageOwner (DB2)
PacketSize
SQL Server
Sybase
parameter metadata
Apache Hive, driver for
DB2 1, 2
Greenplum
Informix
MySQL
Oracle 1, 2
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase 1, 2
Password
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
password, changing when a connection is established (Oracle)
performance considerations
Apache Hive
Apache Hive, driver for
performance optimization
application
DB2 workloads
encryption
restricting results to tables in current catalog (DB2)
permissions
bulk load
for establishing connections
granting access to temporary files, example
Java properties, granting access
Kerberos authentication
named instances (SQL Server)
PortNumber
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
PostgreSQL
alternate server, specifying
Blobs and Clobs, using to return long data
bulk load, configuring
cancel request timeout
certificate validation
classes, data source and driver 1, 2
client information, storing and returning
connection properties
AccountingInfo
AlternateServers
ApplicationName
BulkLoadBatchSize
ClientHostName
ClientUser
ConnectionRetryCount
ConnectionRetryDelay 1, 2
ConvertNull
Database (alias for DatabaseName) 1, 2
DatabaseName
HostNameInCertificate
ImportStatementPool
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
KeyPassword
KeyStore
KeyStorePassword
LoadBalancing
LoginTimeout
MaxLongVarcharSize
MaxNumericPrecision
MaxPooledStatements
MaxVarcharSize
Password
PortNumber
ProgramID
QueryTimeout
ResultSetMetaDataOptions
ServerName
SpyAttributes
SupportsCatalogs
TrustStore
TrustStorePassword
User
ValidateServerCertificate
VarcharClobThreshold
connection retry 1, 2
connection URL
data types
encryption, configuring
failover
isolation levels 1, 2
JSR 114, Rowsets
JTA support
Large Object (LOB) support
load balancing
null values, handling for data conversions
parameter metadata
prepared statement pool size, setting
primary server, specifying
ResultSet metadata 1, 2
Rowsets
scrollable cursors, using
SQL escape sequences
stored procedures
timeout
connection
query
XML
inserting
returning
updating
prepared statement pooling
setting size of statement pool
Apache Hive
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
prepared statements, creating stored procedures for (Sybase)
PrepareMethod (Sybase)
primary server
guidelines for
specifying
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
product requirements
Kerberos authentication
Apache Hive
DB2
Oracle
SQL Server
Sybase
NTLM authentication
Oracle
SQL Server
ProgramID
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
SQL Server
Sybase
ProgramName (alias for ApplicationName) (SQL Server)
Progress OpenEdge
alternate database servers, specifying
auto-generated keys
Blob and Clob searches
client information
connection properties
AlternateServers
CatalogOptions
ConnectionRetryCount
ConnectionRetryDelay 1, 2
ConvertNull
Database (alias for DatabaseName) 1, 2
DatabaseName
EncryptionMethod
FailoverGranularity
FailoverMode
FailoverPreconnect
for connection failover
HostNameInCertificate
ImportStatementPool
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
JDBCBehavior
LoadBalancing
LoginTimeout
MaxPooledStatements
overview
Password
PortNumber
QueryTimeout
ServerName
SpyAttributes
syntax
TrustStore
TrustStorePassword
User
ValidateServerCertificate
connection retry
connection URL
data source
data types
driver class
driver classes
encryption
isolation levels
JSR 114, Rowsets
JTA support
load balancing
null values, handling for data conversions
parameter metadata
performance considerations
prepared statement pool size, setting
primary server, specifying
ResultSet metadata 1, 2
Rowsets
scrollable cursors
scroll-sensitive result sets
supported versions
timeout
connection
query
updatable result sets
proxy server (Salesforce), connecting through
ProxyHost (Salesforce)
ProxyPassword (Salesforce)
ProxyPort (Salesforce)
ProxyUser (Salesforce)
pureScale (DB2)
Q
querying REMOTE_SESSIONS system table to get version information of Web Service API (Salesforce)
QueryTimeout
Apache Hive, driver for 1, 2
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
quick start guide to connecting
R
ReadOnly (Salesforce)
Real Application Clusters (RAC) (Oracle) 1, 2
realm, Kerberos 1, 2, 3, 4
reauthentication
about
DB2
example, performing on a connection explicitly
Kerberos, using with
Oracle
performing explicitly
SQL Server
support
using
ReceiveStringParameterType (SQL Server)
REF CURSOR data types (Oracle)
refcursor, Greenplum
refcursor, PostgreSQL
RefreshDirtyCache (Salesforce)
RefreshSchema (Salesforce)
registering drivers
remote tables (Salesforce)
ReplacePackage (DB2)
ReportRecycleBin (Oracle)
reports (Salesforce)
resource adapters
about
deployment descriptor 1, 2
example
application using resource adapters directly
using with a J2EE application server
J2EE Connector Architecture
JDBC Connector
modifyThreadGroup permission
resource archive (RAR) file 1, 2
Security Manager
security permissions
resource archive (RAR) file 1, 2, 3
restricted mode, connecting to (Oracle)
RESTRICTED SESSION system privilege (Oracle)
result sets, scrollable
Apache Hive
Informix
Oracle
Progress OpenEdge
Salesforce
SQL Server
Sybase
using
ResultSet metadata
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge 1, 2
Salesforce
SQL Server
Sybase
ResultSetMetaDataOptions
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
SQL Server
Sybase
RETURNING clause (Oracle)
returning client information
returning XML
DB2
PostgreSQL
SQL Server
Rowsets
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
S
Salesforce
auto-generated keys
Blobs and Clobs, using to return long data
bulk load, configuring
classes, data source and driver
connection properties
BulkLoadAsync
BulkLoadBatchSize
BulkLoadConcurrencyMode
BulkLoadPollInterval
BulkLoadThreshold
ConfigOptions
ConnectionRetryCount
ConnectionRetryDelay
ConvertNull
CreateDB
Database (alias for DatabaseName)
DatabaseName
EnableBulkLoad
FetchSize
ImportStatementPool
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
LogConfigFile
LoginTimeout
MaxPooledStatements (alias for MaxStatements)
MaxStatements
Password
ProxyHost
ProxyPassword
ProxyPort
ProxyUser
ReadOnly
RefreshDirtyCache
RefreshSchema
SecurityToken
ServerName
StmtCallLimit
StmtCallLimitBehavior
TransactionMode
User 1, 2
WSCompressData
WSFetchSize
WSRetryCount
WSTimeout
connection URL
data types 1, 2
driver class
encryption
isolation levels
JSR 114, Rowsets
JTA support
Large Object (LOB) support
parameter metadata
proxy server, connecting through
querying REMOTE_SESSIONS table to get version information of Web Service API
remote/local tables
reports
ResultSet metadata
Rowsets
SQL escape sequences
timeouts
updatable result sets
version string information 1, 2
views
schemas (DB2)
default schema for unqualified objects in dynamically prepared SQL
for catalog methods 1, 2
non-default
scrollable cursors
Apache Hive, driver for
DB2
Greenplum
Informix 1, 2
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
scroll-insensitive result sets
Apache Hive, driver for
DB2 1, 2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
scroll-sensitive result sets
Informix
Oracle
Progress OpenEdge 1, 2
SQL Server
Sybase 1, 2
SDUSize (Oracle)
Secure Socket Layer
See SSL
Security Manager
and resource adapters
for Java 2 Platform
security permissions, resource adapters
security, using
SecurityToken (Salesforce)
select failover
SelectMethod
SQL Server
Sybase
SendFloatParametersAsString (Oracle)
SendStreamAsBlob (DB2)
sensitive cursors
Oracle
SQL Server
server authentication, SSL
ServerName
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
server-side resultset caching (Oracle)
server-side updatable cursors (SQL Server)
ServerType (Oracle)
service class, Workload Manager (WLM)
service principal name for Kerberos authentication
DB2
permissions 1, 2
Sybase
Service Provider Interface (SPI)
ServiceName (Oracle)
ServicePrincipalName (Sybase)
Session Data Unit (SDU) (Oracle)
SID (Oracle)
single inserts/updates/deletes, using bulk load for
Snapshot isolation level, using (SQL Server)
specifications supported
specifying optimization class (DB2)
specifying the operation for bulk load
SpyAttributes
Apache Hive, driver forr
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
SQL Server
alternate database servers, specifying 1, 2
ANSI_NULLS option
authentication
auto-generated keys
batch inserts and updates
Blobs and Clobs, using to return long data
bulk load, configuring
caching long data
cancel request timeout
classes, data source and driver
client information
connecting to named instances
connection properties
AccountingInfo
AlternateServers
AlwaysReportTriggerResults
ApplicationIntent
ApplicationName
AuthenticationMethod 1, 2
BatchUpdateException
BulkLoadBatchSize
BulkLoadOptions
ClientHostName
ClientUser
CodePageOverride
ConnectionRetryCount
ConnectionRetryDelay 1, 2
ConvertNull
Database (alias for DatabaseName) 1, 2
DatabaseName
DateTimeInputParameterType
DateTimeOutputParameterType
DescribeInputParameters
DescribeOutputParameters
Domain
EnableBulkLoad
EnableCancelTimeout
EncryptionMethod
FailoverGranularity
FailoverMode
FailoverPreconnect
FetchTSWTZAsTimestamp
for connection failover 1, 2
HostNameInCertificate
HostProcess (alias for ProgramID)
ImportStatementPool
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
JDBCBehavior
LoadBalancing
LoadLibraryPath
LoginTimeout
LongDataCacheSize
MaxPooledStatements
NetAddress
PacketSize
Password
PortNumber
ProgramID
ProgramName (alias for ApplicationName)
QueryTimeout
ReceiveStringParameterType
ResultSetMetaDataOptions
SelectMethod
ServerName
SpyAttributes
StringInputParameterType
StringOutputParameterType
SuppressConnectionWarnings
TransactionMode
TruncateFractionalSeconds
TrustStore
TrustStorePassword
User
UseServerSideUpdatableCursors
ValidateServerCertificate
WSID (alias for ClientHostName)
XATransactionGroup
XMLDescribeType
connection retry 1, 2
connection SQL Server
data types 1, 2
delegation of credentials
distributed transaction cleanup
DML with results
encryption, configuring
explicit transaction cleanup
failover
isolation levels 1, 2
J2EE Connector Architecture resource adapter class
JDBC XA procedures
JSR 114, Rowsets
JTA support
Kerberos authentication
about
configuring
javax.security.auth.Subject
Kerberos configuration file
kinit command (UNIX and Linux)
permissions
product requirements 1, 2
Ticket Granting Ticket (TGT)
user credentials, specifying
Windows Active Directory Kerberos
load balancing
LOB support
Microsoft Cluster Server (MSCS) 1, 2, 3
named instances
connecting to
permissions required for
NTLM authentication
about
configuring
DLL
product requirements
null values
handling for data conversions
interpreting
orphaned connections
parameter metadata
prepared statement pool size, setting
primary server, specifying
reauthentication
ResultSet metadata 1, 2
Rowsets
scrollable cursors, using 1, 2
server-side updatable cursors
Snapshot isolation level, using
SQL Server authentication
about
configuring
String stored procedure output parameters, describing
table name information in ResultSet metadata, returning
timeout
connection
query
timestamp data types
transaction cleanup
methods
using timeout
using transaction group identifier
TRANSACTION_SNAPSHOT constant
triggers, filtering results from
URL
user ID/password authentication
See SQL Server authentication
XML
inserting
returning
updating
SQL Server authentication
about
configuring
sqljdbc.dll 1, 2, 3, 4, 5
SSL
certificate
Certificate Authority (CA) 1, 2
client authentication 1, 2
configuring
DB2 1, 2
MySQL
Oracle 1, 2, 3
Oracle Wallet
PostgreSQL
Progress OpenEdge 1, 2
SQL Server
Sybase
encryption
handshake
keystore
server authentication 1, 2
truststore
using with Microsoft SQL Server
statement pooling
about
adding statements to the pool
Apache Hive
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
using
StmtCallLimit (Salesforce)
StmtCallLimitBehavior (Salesforce)
stored procedures
errors returned from (Sybase)
installing for JTA
String output parameters, describing (SQL Server)
stored results
Greenplum
PostgreSQL
storing client information
StringInputParameterType (SQL Server)
StringOutputParameterType (SQL Server)
StringParamsMustMatchCharColumns (Oracle)
StripNewlines (DB2)
support
authentication
encryption
SupportLinks (Oracle)
SupportsCatalogs
Greenplum
PostgreSQL
SuppressConnectionWarnings (SQL Server)
Sybase
alternate database servers, specifying
ansinull option
authentication 1, 2, 3
auto-generated keys
batch inserts and updates 1, 2
Blobs and Clobs, using to return long data
bulk load, configuring
caching long data
cancel request timeout
classes, data source and driver
client information
connection properties
AccountingInfo
AlternateServers
ApplicationName
AuthenticationMethod 1, 2
BatchPerformanceWorkaround
BulkLoadBatchSize
ClientHostName
ClientUser
CodePageOverride
ConnectionRetryCount
ConnectionRetryDelay
ConvertNull
Database (alias for DatabaseName) 1, 2
DatabaseName
EnableBulkLoad
EnableCancelTimeout
EncryptionMethod
ErrorBehavior
FailoverGranularity
FailoverMode
FailoverPreconnect
FetchTWFSasTime
HostNameInCertificate
ImportStatementPool
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
JDBCBehavior
LoadBalancing
LoginTimeout
LongDataCacheSize
MaxPooledStatements
PacketSize
Password
PortNumber
PrepareMethod
ProgramID
QueryTimeout
ResultSetMetaDataOptions
SelectMethod
ServerName
ServicePrincipalName
SpyAttributes
TransactionMode
TrustStore
TrustStorePassword
UseAlternateProductInfo
User
ValidateServerCertificate
connection retry 1, 2
connection Sybase
data types
delegation of credentials
driver class
encryption, configuring
failover
isolation levels 1, 2
J2EE Connector Architecture resource adapter class
JSR 114, Rowsets
JTA support
Kerberos authentication
configuring
Kerberos configuration file
kinit command (UNIX and Linux)
MIT Kerberos
obtaining a javax.security.auth.Subject
permissions
product requirements
service principal name 1, 2
Ticket Granting Ticket (TGT)
user credentials, specifying
Windows Active Directory Kerberos
load balancing
LOB support
native batches
null values, handling for data conversions
null values, interpreting
parameter metadata 1, 2
prepared statement pool size, setting
prepared statements, creating stored procedures for
primary server, specifying
ResultSet metadata 1, 2
Rowsets
scrollable cursors, using
stored procedures
creating for prepared statements
errors returned from
table name information in ResultSet metadata, returning
timeout
connection
query
URL
user ID/password authentication
about
configuring
SYSDBA privilege (Oracle)
SysLoginRole (Oracle)
SYSOPER privilege (Oracle)
T
TABLE data type (Oracle) 1, 2
table name information in ResultSet metadata
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
SQL Server
Sybase
tables
local (Salesforce)
mapping objects to (Salesforce)
remote (Salesforce)
testing connections
Ticket Granting Ticket (TGT), Kerberos authentication
Apache Hive
DB2
Oracle
SQL Server
Sybase
TIME_ZONE session parameter (Oracle9i and higher)
timeout, connection
Apache Hive
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
timeout, query
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
timeouts (Salesforce)
TIMESTAMP data type (Oracle9i and higher)
timestamp data types (SQL Server)
TIMESTAMP WITH LOCAL TIME ZONE data type (Oracle9i and higher)
TIMESTAMP WITH TIME ZONE data type (Oracle9i and higher)
timestamps (Oracle9i and higher)
tnsnames.ora file
configuring
driver to reference file
options for
connect descriptor parameters
connection information, retrieving
mapping Oracle driver properties to
permissions for Java 2 Platform
setting path and filename of
TNSNamesFile (Oracle)
TNSServerName (Oracle)
transaction level workload balancing (DB2)
transaction redo changes (Oracle)
TRANSACTION_SNAPSHOT constant (SQL Server)
TransactionErrorBehavior
Greenplum
TransactionMode
Apache Hive, driver for
Salesforce
SQL Server
Sybase
TreatBinaryAsChar (MySQL)
TruncateFractionalSeconds (SQL Server)
TrustStore
DB2
Greenplum
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
truststore file, SSL
TrustStorePassword
DB2
Greenplum
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
types of
authentication
encryption
U
Unicode support
unqualified function names (DB2)
updatable result sets
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
using scrollable cursors
updating XML
DB2
Oracle
PostgreSQL
SQL Server
URL
Apache Hive
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
UseAlternateProductInfo (Sybase)
UseCurrentSchema (DB2)
UseDelimitedIdentifier (Informix)
User
Apache Hive, driver for
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce 1, 2
SQL Server
Sybase
user authentication
user credentials, specifying for Kerberos authentication
Apache Hive
DB2
Oracle
SQL Server
Sybase
user ID and password
clear text (DB2) 1, 2
encryption (DB2) 1, 2
user ID/password authentication
about
Apache Hive
DB2
Oracle
SQL Server
Sybase
configuring
Apache Hive
DB2
Oracle
Sybase
user-defined functions, Greenplum
user-defined functions, PostgreSQL
UseServerSideUpdatableCursors (SQL Server)
using
bulk load for batch inserts
bulk load for single inserts/updates/deletes
collection data types (Oracle)
CSV files
DDBulkLoad object
identifiers
scrollable cursors
Apache Hive
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
statement pooling
UTF-16 encoding, converting
V
ValidateServerCertificate
DB2
Greenplum
MySQL
Oracle
PostgreSQL
Progress OpenEdge
SQL Server
Sybase
VarcharClobThreshold
Greenplum
PostgreSQL
VARRAY data type (Oracle) 1, 2
verifying bulk load configuration file
version string information (Salesforce)
views
Apache Hive
views (Salesforce)
W
wait_timeout variable (MySQL)
Web Service API (Salesforce), getting version information
Windows Active Directory Kerberos
Apache Hive
DB2 1, 2
Oracle
SQL Server
Sybase
Windows Domain 1, 2, 3, 4
WireProtocolMode (Oracle)
WireProtocolVersion
Apache Hive, driver for
WithHoldCursors (DB2)
Workload Manager (WLM)
about
service class
using client information with
WSCompressData (Salesforce)
WSFetchSize (Salesforce)
WSID (alias for ClientHostName) (SQL Server)
WSRetryCount (Salesforce)
WSTimeout (Salesforce)
X
XAResource.recover() method (SQL Server) 1, 2
XATransactionGroup (SQL Server)
XML
inserting
DB2
Oracle
PostgreSQL
SQL Server
returning
DB2
Oracle
PostgreSQL
SQL Server
updating
DB2
Oracle
PostgreSQL
SQL Server
XML data type (DB2)
XML data type (PostgreSQL)
xml data type (SQL Server)
XMLDescribeType
DB2
SQL Server
XMLType data type (Oracle9i and higher)