Progress DataDirect for JDBC for Oracle Service Cloud Driver User's Guide
Preface
Welcome to the Progress DataDirect for JDBC Oracle Service Cloud Driver
What's New in this Release?
About the Product Documentation
Typographical Conventions
Contacting Technical Support
Getting Started
Getting started
Connecting with the JDBC Driver Manager
Setting the Classpath
Passing the Connection URL
Testing the Connection
About the Driver
Progress DataDirect for JDBC for Oracle Service Cloud
Requirements
Components
Data Source and Driver Classes
Version String Information
Connection Properties
Data Types
Mapping Objects to Tables
Standard and Custom Objects
Primary Objects, Sub-objects, and Lists of Sub-objects
Many-to-many Relationships
Supported Features
Data Encryption
Unicode support
Error Handling
IP Addresses
Timeouts
Scrollable Cursors
Large Objects (LOBs)
Parameter Metadata Support
ResultSet MetaData Support
Rowset Support
Auto-Generated Keys Support
Isolation Levels
SQL Support
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
Connecting from an Application
Connecting Using the JDBC Driver Manager
Registering the Driver
Passing Connection URLs
Connecting Using Data Sources
How Data Sources Are Implemented
Creating Data Sources
Calling a Data Source in an Application
Testing the Connection
Connecting Through a Proxy Server
Using Connection Properties
Required Properties
Embedded Database Properties
Proxy Server Properties
Web Service Properties
Statement Pooling Properties
Additional Properties
Performance Considerations
Using the Database Configuration File
<Database>
<User>
<UseSchema>
<Schema>
<ConfigOptions>
<SessionOptions>
Views and Remote/Local Tables
Client-Side Caches
Creating a Cache
Modifying a Cache Definition
Disabling and Enabling a Cache
Refreshing Cache Data
Dropping a Cache
Cache MetaData
Catalog Tables
SYSTEM_CACHES Catalog Table
SYSTEM_CACHE_REFERENCES Catalog Table
SYSTEM_REMOTE_SESSIONS Catalog Table
SYSTEM_SESSIONS Catalog Table
Identifiers
Reports
Statement Pool Monitor
Enabling Statement Pooling
Accessing the Statement Pool Monitor
Using JMX
Using DataDirect-specific methods to access the Statement Pool Monitor
Using the poolEntries Method
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
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 Driver Manager
Using JDBC data sources
DataDirect Spy attributes
Troubleshooting
Troubleshooting your application
Turning on and off DataDirect Spy logging
DataDirect Spy log 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
"Poor Performing Query" Error Message
Reference
Connection Property Descriptions
ConfigOptions
ConvertNull
CreateDB
DatabaseName
EnableAccessRequestHeader
EnablePagingWithOrderById
FetchSize
ImportStatementPool
InitializationString
InsensitiveResultSetBufferSize
InterfaceName
JavaDoubleToString
LogConfigFile
LoginHost
LoginTimeout
ManagedObjects
MaxPooledStatements
OracleServiceCloudDatabase
Password
ProxyHost
ProxyPassword
ProxyPort
ProxyUser
RefreshDirtyCache
RegisterStatementPoolMonitorMBean
StmtCallLimit
StmtCallLimitBehavior
TransactionMode
User
WSCompressData
WSFetchSize
WSRetryCount
WSTimeout
getTypeInfo()
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
Supported SQL Statements and Extensions
Alter Cache (EXT)
Alter Index
Alter Sequence
Alter Session (EXT)
Alter Table
Add Clause: Columns
Add Clause: Constraints
Drop Clause: Columns
Drop Clause: Constraints
Rename Clause
Checkpoint
Create Cache (EXT)
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
Column Definition for Local Tables
Constraint Definition for Local Tables
Create View
Drop Cache (EXT)
Drop Index
Drop Sequence
Drop Table
Drop View
Explain Plan
Refresh Cache (EXT)
Set Checkpoint Defrag
Set Logsize
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/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
JDBC extensions
Using JDBC wrapper methods to access JDBC extensions
DatabaseMetaData interface
DDBulkLoad interface
ExtConnection interface
ExtDatabaseMetaData interface
ExtLogControl class
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
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
Progress DataDirect for JDBC for Oracle Service Cloud Driver User's Guide
Copyright
statement_pool
datadirect_test
datadirect_spy
jdbc_support
sql_escapes
application_performance