A
accessing the DataDirect Statement Pool Monitor
1
,
2
Add clause (for local tables)
Add clause (for remote tables)
aggregate functions
Alter Cache (EXT)
Alter Index
Alter Sequence
Alter Session (EXT)
Alter Table
Apache Hive, driver for
between clause
column name qualification
From clause
Group By clause
Having clause
Insert and Update
maximum length of a SQL string
Order By clause
restrictions
SQL statement support
subqueries
views
Apache Hive, getTypeInfo()
application
connection pooling
1
,
2
DataDirect Spy, using to troubleshoot
troubleshooting problems
arithmetic operators
1
,
2
Array interface, methods
attributes, DataDirect Spy
Autocommit mode
auto-generated keys
example, retrieving
performance optimization
B
batch inserts and updates
example
batch execution on a prepared statement (DataDirect Test)
using instead of prepared statements
binary
literals
operators
Blob
retrieving data (DataDirect Test)
Blob interface, methods
C
Call Limit clause
CallableStatement interface, methods
changing the maximum pool size behavior
character operators
character string literals
checking version of DataDirect Connection Pool Manager
Checkpoint
clearing statements in the statement pool
Clob
retrieving data (DataDirect Test)
Clob interface, methods
closing the connection pool
column
definition
names
com.ddtek.jdbc.extensions package
1
,
2
committing transactions
comparison operators
components, Java logging (Salesforce)
concatenation operator
1
,
2
concurrency type of result set in statement pool
conditions
connecting
DataDirect Test
using a data source
using driver/database selection
example
DataDirect Test
Driver Manager and DataDirect Spy
using connection pool
Connection interface, methods
connection management
Connection object
ExtLogControl interface
managing connections
transaction model
connection pool
See connection pooling
Connection Pool Monitor
connection pooling
connection pool
closing
configuring
connecting using
creating
1
,
2
PooledConnectionDataSource object, creating
Connection Pool Monitor
driver DataSource object for connection pooling, creating
example
DataDirect Connection Pool Manager trace file
pooled data source
performance optimization
PooledConnectionDataSource object, creating
ConnectionEventListener interface, methods
ConnectionPoolDataSource interface, methods
ConnectionPoolMonitor interface, methods
constants
Apache Hive, driver for
constraint definition
1
,
2
correlated subqueries
Create Cache (EXT)
Create Index
Create Sequence
Create Table
Create View
creating
connection pool
driver DataSource object for connection pooling
PooledConnectionDataSource object
cursors, choosing for performance
D
data sources
creating
driver DataSource object for connection pooling
PooledConnectionDataSource object
data types, choosing for performance
database
metadata, retrieving (DataDirect Test)
table characteristics, using dummy query to determine
DatabaseMetaData interface (Salesforce)
DatabaseMetaData interface, methods
DataDirect Connection Pool Manager
checking the version
trace file
example
using
tracing, enabling
1
,
2
,
3
using reauthentication with
DataDirect Spy
attributes
enabling
using JDBC data sources
using JDBC Driver Manager
example
JDBC data source connection
1
,
2
JDBC Driver Manager connection
1
,
2
logging
generating a log
JDBC calls to System.out
log example
turning on and off
setEnableLogging() method
SpyAttributes connection property, using
DataDirect Statement Pool Monitor
accessing
using DataDirect-specific methods
using the JMX API
classes and interfaces
using
1
,
2
DataDirect Test
batches
configuring
connecting with
database metadata, retrieving
example
executing
prepared statement
Select statement
LOB support
ParameterMetaData, returning
result set, scrolling through
rows, deleting
savepoints, establishing
starting
1
,
2
tutorial
updatable result sets
using
DataSource interface, methods
DataSource object
connection pooling
creating DataSource object for
1
,
2
obtaining a connection
1
,
2
referencing for
1
,
2
date, time, timestamp escape sequences
date/time literals
DB2
getTypeInfo() method
DDBulkLoad interface, methods
Delete
Driver interface, methods
driver, DataSource object for connection pooling
Drop Cache (EXT)
Drop clause
1
,
2
Drop Index
Drop Sequence
Drop Table
Drop View
dummy query, using to determine table characteristics
E
Enabled clause
enabling statement pooling
escape sequences
date, time, and timestamp
LIKE escape character for wildcards
outer join
procedure call
establishing savepoints (DataDirect Test)
example
data source for connection pooling
DataDirect Spy
JDBC data source connection
1
,
2
JDBC Driver Manager connection
1
,
2
log
DataDirect Test
date, time, and timestamp escape sequence
Driver Manager, using to connect
1
,
2
outer join escape sequence
scalar functions
statement pool export file
1
,
2
trace file, DataDirect Connection Pool Manager
Except operator
executing
prepared statement (DataDirect Test)
Select statement (DataDirect Test)
EXISTS predicate
Explain Plan
export file for statement pool
example
generating
ExtConnection interface, methods
ExtDatabaseMetaData interface, methods
1
,
2
extensions for metadata (Salesforce)
external ID column, specifying
ExtLogControl class, methods
ExtStatementPoolMonitor class
ExtStatementPoolMonitorMBean interface
F
Filter clause
Foreign Key clause
forward-only cursor
freezing the statement pool
From clause
functions
Apache Hive
Salesforce
G
generating statement pool export file
1
,
2
getBestRowIdentifier() method
getBlob() method
getClob() method
getObject() method
getting network timeout (SQL Server)
getTypeInfo() method
Apache Hive
DB2
Greenplum
Informix
MySQL
Oracle
PostgreSQL
Progress OpenEdge
Salesforce
SQL Server
Sybase
Windows Azure
Greenplum, getTypeInfo()
Group By clause
H
Having clause
I
importing statements into the statement pool
IN predicate
Informix, getTypeInfo() method
Initial Check clause
initial pool size
InputStream object (DataDirect Spy)
1
,
2
,
3
insensitive cursors, performance implications
Insert
inserting a row (DataDirect Test)
integer literals
Interfaces, JDBC
Intersect operator
J
Java 2 Platform
batch execution on a prepared statement (DataDirect Test)
scrollable result sets (DataDirect Test)
Java logging (Salesforce)
components
JDBC API logger
SQL engine logger
using
Web service adapter logger
Java Management Extensions (JMX) MBean, DataDirect Statement Pool Monitor
JConsole
JDBC
functionality supported
interfaces
JVM compatibility
1
,
2
methods supported
versions supported
1
,
2
JDBC API logger (Salesforce)
JDBC Driver Manager, specifying SpyAttributes connection property with
JDBC extensions
1
,
2
join in a From clause
JTA support
transaction
managing commits
model, choosing for performance
JVM
JDBC compatibility
1
,
2
K
keyset-driven cursor
See sensitive cursors
L
LIKE escape character for wildcards escape sequence
Limit clause
literals
about
arguments, using parameter markers
binary
character string
date/time
escape sequences
integer
numeric
LOB support, executing a query that uses Clobs, Blobs (DataDirect Test)
log for DataDirect Spy, using
logging, Java (Salesforce)
components
JDBC API logger
SQL engine logger
using
Web service adapter logger
logical operators
1
,
2
long data, retrieving and performance
M
materialized views
maximum idle time
maximum pool size
maximum pool size behavior
MBean name, registering
metadata methods, minimizing use of
methods
Array interface
Blob interface
CallableStatement interface
Clob interface
Connection interface
ConnectionEventListener interface
ConnectionPoolDataSource interface
DatabaseMetaData interface
DataSource interface
Driver interface
ExtConnection class
ExtDatabaseMetaData class
ExtLogControl class
ExtStatementPoolMonitorMBean interface
ParameterMetaData interface
PooledConnection interface
PooledConnectionDataSource interface
PooledConnectionDataSourceFactory interface
PreparedStatement interface
Ref interface
ResultSet interface
ResultSetMetaData interface
RowSet interface
SavePoint interface
Statement interface
StatementEventListener interface
Struct interface
XAConnection interface
XADataSource interface
XAResource interface
minimum pool size
Minus operator
MySQL, getTypeInfo()
N
network timeout (SQL Server)
getting
setting
Next Value For clause
numeric literals
O
object
Connection
ExtLogControl interface
managing connections
transaction model
DataSource
connection pooling
1
,
2
,
3
,
4
,
5
,
6
DDBulkLoad, methods
ExtConnection, methods
ExtControl, methods
ExtDatabaseMetaData, methods
InputStream (DataDirect Spy)
1
,
2
,
3
Long (DB2)
pooled data source
PooledConnectionDataSource
connecting with
connection pooling
1
,
2
,
3
ConnectionPoolMonitor
creating
1
,
2
,
3
PreparedStatement
using Statement object instead of
1
,
2
Reader (DataDirect Spy)
1
,
2
,
3
Reference, connection pooling
1
,
2
,
3
ResultSet
database metadata
generating
updating data
1
,
2
Statement
using instead of PreparedStatement object
using multiple
1
,
2
using addBatch() instead of PreparedStatement
OpenEdge
See Progress OpenEdge
operators
arithmetic
1
,
2
comparison
concatenation
1
,
2
logical
1
,
2
precedence
relational
Oracle, getTypeInfo() method
Order By clause
outer join escape sequence, example
P
parameter markers, using as arguments to stored procedures
parameter metadata, returning (DataDirect Test)
ParameterMetaData interface, methods
performance optimization
auto-generated keys, retrieving
batches, using instead of prepared statements
commits, managing
connection
management
pooling
database metadata methods
designing JDBC applications
get methods, using effectively
getBestRowIdentifier()
result sets, retrieving
retrieving long data
scrollable cursors
selecting JDBC objects and methods
transaction model, choosing
update methods of the ResultSet object
updating data
Persist clause
PooledConnection interface, methods
PooledConnectionDataSource interface, methods
PooledConnectionDataSource object
connecting with
ConnectionPoolMonitor
creating
1
,
2
,
3
,
4
,
5
,
6
,
7
PooledConnectionDataSourceFactory interface, methods
poolEntries() parameters
PostgreSQL, getTypeInfo()
predicate
EXISTS
IN
UNIQUE
prepared statement pooling, performance optimization
prepared statements
using batches instead of
PreparedStatement interface, methods
PreparedStatement object
performance
implications of using Statement object instead
of prepared statement pool
prepared statement pooling
using Statement object instead of
1
,
2
Primary Key clause
procedure call
Progress OpenEdge, getTypeInfo()
properties file for Java logging (Salesforce)
driver
JVM
R
Reader object (DataDirect Spy)
1
,
2
,
3
reauthentication
enabling in DataDirect Connection Pool Manager
using with the DataDirect Connection Pool Manager
Ref interface, methods
Reference object
using to create a PooledConnectionDataSource object
1
,
2
Referencing clause
Refresh Cache (EXT)
Refresh Interval clause
Refresh Schema (EXT)
registering MBean name
relational operators
Rename clause
result set type in statement pool
result sets, scrollable
performance optimization
requirements for
scrolling through a result set (DataDirect Test)
ResultSet interface, methods
ResultSet object
database metadata
generating
updating data
1
,
2
ResultSetMetaData interface, methods
rows, deleting (DataDirect Test)
RowSet interface, methods
S
Salesforce
getTypeInfo()
Java logging
Java logging components
JDBC API logger
Remote Object Mapping
SQL engine logger
Web Service adapter logger
SavePoint interface, methods
savepoints, establishing (DataDirect Test)
scalar functions
search patterns, avoiding
Select clause
Select statement
sensitive cursors, performance implications
server-side RPCs
Set Checkpoint Defrag
Set Logsize
setEnableLogging(), using to turn on and off DataDirect Spy logging
setting the network timeout (SQL Server)
SQL
expressions
driver for Apache Hive
SQL engine logger (Salesforce)
SQL escape sequences
date, time, timestamp
LIKE escape character for wildcards
outer join
procedure call
scalar functions
SQL expressions
SQL Server
getTypeInfo() method
network timeout
getting
setting
SQL statements
Alter Cache
Alter Index
Alter Sequence
Alter Session
Alter Table
Checkpoint
Create Cache (EXT)
Create Index
Create Sequence
Create Table
Create View
Delete
Drop Cache
Drop Index
1
,
2
Drop Sequence
Drop Table
Drop View
Explain Plan
Insert
Refresh Cache
Refresh Schema
Select
Set Checkpoint Defrag
Set Logsize
SQL expressions
Update
Statement interface, methods
Statement object
Connection object association
using instead of PreparedStatement object
using multiple
1
,
2
when to use
statement pool
clearing statements
concurrency type of result set in
export file, generating
freezing
importing statements to
result set type in
statement type in
unfreezing
statement pool export file
example
1
,
2
generating
statement pooling
enabling
statement pool export file
troubleshooting problems
statement type in statement pool
StatementEventListener interface, methods
stored procedures
escape sequences
parameter markers as arguments, using
Struct interface, methods
subqueries
Apache Hive, driver for
correlated
overview
subquery in a From clause
Sybase, getTypeInfo() method
System.out, logging JDBC calls to using DataDirect Spy
T
time literal escape sequence
timestamp literal escape sequence
tracing, enabling for Pool Manager
transactions
See JTA support
troubleshooting
application problems
connection pooling problems
statement pooling problems
turning on and off DataDirect Spy logging
U
unary operator
understanding the maximum pool size
unfreezing the statement pool
Union operator
Unique clause
UNIQUE predicate
updatable result sets
deleting a row
inserting a row
Update
updating a row
using
DataDirect Spy log
DataDirect Statement Pool Monitor
1
,
2
DataDirect-specific methods
JMX API
Wrapper methods
V
views
Apache Hive, driver for
W
Web service adapter logger (Salesforce)
Where clause
Windows Azure
getTypeInfo() method
Wrapper methods
X
XAConnection interface, methods
XADataSource interface, methods
XAResource interface, methods