Welcome to the Progress DataDirect for JDBC for Oracle Driver
What's new in this release?
Quick start
Requirements
Data source and driver classes
Connection URL
Version string information
Connection properties
Data types
Using extended data types
Using date/time data types
Date/time session parameters
TIMESTAMP data type
TIMESTAMP WITH LOCAL TIME ZONE data type
TIMESTAMP WITH TIME ZONE data type
Using collection data types
VARRAY/TABLE
OBJECT
getTypeInfo
Contacting Technical Support
Using the driver
Connecting from an application
Data source and driver classes
Setting the classpath
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 tnsnames.ora files
Connecting to the database
Configuring the tnsnames.ora file
Connecting to Oracle instances running in restricted mode
Oracle Connection Manager
Using LDAP
Using connection properties
Required properties
Authentication properties
Data encryption properties
Failover properties
Bulk load properties
Data type handling properties
Timeout properties
Statement pooling properties
Client information properties
Additional properties
Performance considerations
Support for Oracle RAC
Authentication
Using the AuthenticationMethod property
Configuring user ID/password authentication
Configuring Kerberos authentication
Product requirements
Configuring the driver
Specifying user credentials for Kerberos authentication (delegation of credentials)
Constrained delegation
Configuring NTLM authentication
Product requirements
Configuring the driver
Configuring client authentication
Oracle Wallet SSL authentication
Oracle Internet Directory (OID)
Reauthentication
Data encryption
Configuring SSL Encryption
SSL client authentication
SSL server authentication
Implementing Oracle Advanced Security
Configuring random number generator secure seeding
Using Oracle Wallet as a Keystore
Using failover
Configuring failover
Specifying primary and alternate servers
Specifying connection retry
Connection failover
Extended connection failover
Select connection failover
Using client load balancing
Using connection retry
Returning and inserting/updating XML data
Returning XML data
Inserting/updating XML data
REF CURSOR data type
Using client information
How databases store client information
Storing client information
Returning client information
Returning metadata about client information locations
Using IP addresses
Parameter metadata support
Insert and update statements
Select statements
Stored procedures
ResultSet metadata support
Isolation levels
Using scrollable cursors
JTA support
Unicode support
Error handling
Batch inserts and updates
Rowset support
Auto-generated keys support
Executing Insert/Update/Delete statements with a Returning clause
Configuring Bulk Load
Bulk Load limitations
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
Logging
CSV files
Bulk load configuration file
Bulk load configuration file schema
Verifying the bulk load configuration file for database connections
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 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 JDBC DriverManager
Using JDBC data sources
DataDirect Spy attributes
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
Granting access to an Oracle tnsnames.ora file
Permissions for Kerberos authentication
Permissions for bulk load from a CSV file
Connection property descriptions
AccountingInfo
Action
AlternateServers
ApplicationName
AuthenticationMethod
BatchMechanism
BulkLoadBatchSize
BulkLoadOptions
CatalogOptions
ClientHostName
ClientID
ClientUser
CodePageOverride
CommitBehavior
ConnectionRetryCount
ConnectionRetryDelay
ConvertNull
CryptoProtocolVersion
Database
DatabaseName
DataIntegrityLevel
DataIntegrityTypes
EditionName
EnableBulkLoad
EnableCancelTimeout
EnableServerResultCache
EncryptionLevel
EncryptionMethod
EncryptionTypes
FailoverGranularity
FailoverMode
FailoverPreconnect
FetchTSWTZasTimestamp
GSSCredential
HostNameInCertificate
ImportStatementPool
InitialColumnBufferSize
InitializationString
InsensitiveResultSetBufferSize
JavaDoubleToString
JDBCBehavior
KeyPassword
KeyStore
KeyStorePassword
LDAPDistinguishedName
LoadBalancing
LoadLibraryPath
LOBPrefetchSize
LoginTimeout
MaxPooledStatements
MaxStatements
Module
NewPassword
Password
PortNumber
ProgramID
QueryTimeout
RandomGenerator
RegisterStatementPoolMonitorMBean
ReportRecycleBin
ResultSetMetaDataOptions
SDUSize
SecureRandomAlgorithm
SendFloatParametersAsString
ServerName
ServerType
ServiceName
SID
SpyAttributes
StringParamsMustMatchCharColumns
SupportBinaryXML
SupportLinks
SysLoginRole
TNSNamesFile
TNSServerName
TrustStore
TrustStorePassword
User
ValidateServerCertificate
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
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
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
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
Welcome to the Progress DataDirect for JDBC for Oracle Driver
Copyright
connection_pool
statement_pool
datadirect_test
datadirect_spy
sql_escapes
jdbc_support
application_performance