Skip Headers
Oracle® Universal Connection Pool for JDBC Developer's Guide
11g Release 2 (11.2)

Part Number E12265-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  G  H  I  J  L  M  O  P  R  S  T  U  V  W  X 

A

abandon connection timeout property, 4.3.2
AbandonedConnectionTimeoutCallback, 6.1
admin package, 2.4
affinity
transaction-based, 8.4
web session, 8.4
API overview, 2.4
applyConnectionLabel, 5.3
applying connection labels, 5.3

B

basic connection example, 2.3
benefits of connection pools, 1.1.1
benefits of FCF, 8.2
benefits of run-time connection load balancing, 8.3
borrowing connections
basic steps, 2.2
conceptual architecture, 1.2.1
labeled, 5.4
overview, 3.1
using JNDI, 3.1.4
using the pool-enabled data source, 3.1.1
using the pool-enabled XA data source, 3.1.2

C

caching statements, 4.5
callback
connection affinity, 8.4.1.1
labeling, 5.2
checking unmatched labels, 5.5
closing connections, 3.4
conceptual architecture, 1.2.1
configure method, 5.2.1
configure ONS, 8.2.3
connection affinity
create callback, 8.4.1.1
overview, 8.4
register callback, 8.4.1.2
remove callback, 8.4.1.3
setting up, 8.4.1
statistics, 9.3.3
transaction-based, 8.4
web session, 8.4
connection factory, 2.2
conceptual architecture, 1.2.1
requirements, 2.1
setting, 3.1.1, 3.1.2
connection labels
apply, 5.3
check unmatched, 5.5
implement callback, 5.2
overview, 5.1
removing, 5.6
Connection object, 1.2.1
connection pool
benefits, 1.1.1
create explicitly, 7.1.3.1
create implicitly, 2.2, 3.1
destroy, 7.1.3.4
general overview, 1.1
maintenance, 7.1.4
purge, 7.1.4.3
recycle, 7.1.4.2
refresh, 7.1.4.1
remove connection from, 3.5
start, 7.1.3.2
stop, 7.1.3.3
understanding lifecycle, 7.1.3
connection pool manager
create, 7.1.2
create pool explicitly, 7.1.3.1
destroy pool, 7.1.3.4
overview, 1.2.3, 7.1.1
purge pool, 7.1.4.3
recycle pool, 7.1.4.2
refresh pool, 7.1.4.1
start pool, 7.1.3.2
stop pool, 7.1.3.3
connection pool properties
abandon connection timeout, 4.3.2
connection wait timeout, 4.3.4
harvest maximum count, 4.4.3
harvest trigger count, 4.4.2
inactive connection timeout, 4.3.5
initial pool size, 4.2.1
maximum connection reuse count, 4.3.1.2
maximum connection reuse time, 4.3.1.1
maximum pool size, 4.2.3
maximum statements, 4.5.1
minimum pool size, 4.2.2
optimizing, 4.1
overview, 1.2.2
setting, 3.2, 4.1
timeout check interval, 4.3.6
time-to-live connection timeout, 4.3.3
validate on borrow, 3.3.1
connection properties, 3.1.3
connection reuse properties, setting, 4.3.1
connection steps, basic, 2.2
example, 2.3
connection URL, 8.2.4
connection wait timeout property, 4.3.4
ConnectionAffinityCallback interface, 8.4.1.1
ConnectionLabelingCallback interface, 5.1, 5.2.1
connections
basic steps, 2.2
borrowing, 3.1
borrowing labeled, 5.4
borrowing using JNDI, 3.1.4
checking if valid, 3.3.2
closing, 3.4
controlling stale, 4.3
harvesting, 4.4
labeling, 5.1
removing from the pool, 3.5
run-time load balancing, 8.3
using affinity, 8.4
validate on borrow, 3.3.1
cost method, 5.2.1
create connection pool
explicit, 7.1.3.1
implicit, 2.2

D

data source
PoolDataSource, 1.2.1, 3.1.1
PoolXADataSource, 1.2.1, 3.1.2
database requirements, 2.1
destroyConnectionPool, 7.1.3.4
destroying a connection pool, 7.1.3.4

E

enable FCF property, 8.2.2
errors
connection pool layer messages, A.2
general UCP message structure, A.1
JDBC data sources and dynamic proxies messages, A.3
example
basic connection, 2.3
connection affinity callback, 8.4.1.1
FCF, 8.2.1
labeling callback, 5.2.1.1

F

FAN, 8.2
Fast Connection Failover
See FCF
FCF, 8.2
configure connection URL, 8.2.4
configure ONS, 8.2.3
enable, 8.2.2
example, 8.2.1
statistics, 9.3.1

G

getAffinityPolicy, 8.4.1.1
getConnection methods, 3.1.1, 5.4
getPoolDataSource, 3.1.1
getPoolXADataSource, 3.1.2
getStatistics, 9.3
getting a connection, 3.1.1
getting an XA connection, 3.1.2
getUniversalConnectionPoolManager, 7.1.2
getUnmatchedConnectionLabels, 5.5
getXAConnection methods, 3.1.2

H

harvest connections, 4.4
harvest maximum count property, 4.4.3
harvest trigger count property, 4.4.2
HarvestableConnection interface, 4.4.1
high availability, 1.2.4, 8.1

I

inactive connection timeout property, 4.3.5
initial pool size property, 4.2.1
integration
third-party, 3.6
isValid, 3.3.2

J

JDBC connection pool
See UCP for JDBC
JDBC driver
connection properties, 3.1.3
requirements, 2.1
jdbc package, 2.4
JNDI, 3.1.4
JRE requirements, 2.1

L

LabelableConnection interface, 5.1, 5.3
labeled connections
apply label, 5.3
borrowing, 5.4
check unmatched, 5.5
implement callback, 5.2
overview, 5.1
remove label, 5.6
labeling callback
create, 5.2.1
example, 5.2.1.1
register, 5.2.2
removing, 5.2.3
run-time algorithm, 5.2.1
lifecycle of connection pools, 7.1.3
lifecycle states, 7.1.3
Load Balance Advisory, 8.3
load balancing, 8.2.4, 8.3
logging, 9.4
logging configuration
programmatically, 9.4.2
properties file, 9.4.1
logging levels, 9.4.3

M

manager, connection pool, 7.1.1
maximum connection reuse count property, 4.3.1.2
maximum connection reuse time property, 4.3.1.1
maximum pool size property, 4.2.3
maximum statements property, 4.5.1
method, 3.1.2
minimum pool size property, 4.2.2

O

ONS, 8.2.3
ons.config file, 8.2.3
optimizing a connection pool, 4.1
Oracle Client software, 8.2.3
Oracle Client software requirements, 2.1
Oracle Notification Service
See ONS
overview
API, 2.4
connection pool manager, 7.1.1
connection pool properties, 4.1
connection pools, general, 1.1
connection steps, 2.2
high availability and performance features, 1.2.4
labeling connections, 5.1
RAC features, 8.1
UCP for JDBC, 1.2

P

password, 2.2, 3.1.1, 3.1.2
pool manager
See connection pool manager
pool properties
See connection pool properties
pool size, controlling
initial size, 4.2.1
maximum, 4.2.3
minimum, 4.2.2
PoolDataSource interface, 1.2.1, 3.1.1
PoolDataSourceFactory class, 3.1.1, 3.1.2
PoolDataSourceImpl, 3.6
pool-enabled data source
create instance, 3.1.1
pool-enabled XA data source
create instance, 3.1.2
PoolXADataSource interface, 1.2.1, 3.1.2
PoolXADataSourceImpl, 3.6
purgeConnectionPool, 7.1.4.3
purging a connection pool, 7.1.4.3

R

RAC
connection affinity, 8.4
FCF, 8.2
features overview, 8.1
run-time connection load balancing, 8.3
statistics, 9.3
RAC Load Balance Advisory, 8.3
Real Application Clusters
See RAC
recycleConnectionPool, 7.1.4.2
recycling a connection pool, 7.1.4.2
refreshConnectionPool, 7.1.4.1
refreshing a connection pool, 7.1.4.1
registerConnectionAffinityCallback, 8.4.1.2
registerConnectionLabelingCallback, 5.2.2
removeConnectionAffinityCallback, 8.4.1.3
removeConnectionLabel, 5.6
removeConnectionLabelingCallback, 5.2.3
removing connection labels, 5.6
removing connections from the pool, 3.5
reuse properites
maximum count, 4.3.1.2
reuse properties
maximum time, 4.3.1.1
run-time connection load balancing
overview, 8.3
setting up, 8.3.1
statistics, 9.3.2

S

SERVICE_TIME, 8.3.1
setAbandonConnectionTimeout, 4.3.2
setAffinityPolicy, 8.4.1.1
setConnectionAffinityContext, 8.4.1.1
setConnectionFactoryClassName, 3.1.1, 3.1.2
setConnectionHarvestable, 4.4.1
setConnectionHarvestMaxCount, 4.4.3
setConnectionHarvestTriggerCount, 4.4.2
setConnectionProperties, 3.1.3
setConnectionWaitTimeout, 4.3.4
setFastConnectionFailoverEnabled, 8.2.2
setInactiveConnectionTimeout, 4.3.5
setInitialPoolSize, 4.2.1
setInvalid, 3.3.2, 3.5
setMaxConnectionReuseCount, 4.3.1.2
setMaxConnectionReuseTime, 4.3.1.1
setMaxPoolSize, 4.2.3
setMaxStatements, 4.5.1
setMinPoolSize, 4.2.2
setONSConfiguration, 8.2.3
setPassword, 3.1.1, 3.1.2
setSQLForValidateConnection, 3.3.1
setTimeToLiveConnectionTimeout, 4.3.3
setTimoutCheckInterval, 4.3.6
setURL, 3.1.1, 3.1.2
setUser, 3.1.1, 3.1.2
setValidateConnectionOnBorrow, 3.3.1
SHORT, 8.3.1
SQL statement caching, 4.5
stale connections, 4.3
startConnectionPool, 7.1.3.2
starting a connection pool, 7.1.3.2
statement caching, 4.5
statistics
connection affinity, 9.3.3
FCF, 9.3.1
RAC, 9.3
run-time connection load balancing, 9.3.2
stopConnectionPool, 7.1.3.3
stopping a connection pool, 7.1.3.3

T

third-party integration, 3.6
THROUGHPUT, 8.3.1
timeout check interval property, 4.3.6
timeout properties
abandon, 4.3.2
check interval, 4.3.6
inactive, 4.3.5
time-to-live, 4.3.3
wait, 4.3.4
time-to-live connection timeout property, 4.3.3
TimeToLiveConnectionTimeoutCallback, 6.2
transaction-based affinity, 8.4

U

UCP for JDBC
API overview, 2.4
basic connection steps, 2.2
conceptual architecture, 1.2.1
connection pool manager
connection pool properties, 3.2, 4.1
overview, 1.2
RAC features, 8.1
software requirements, 2.1
UCP manager
See connection pool manager
ucp package, 2.4
universal connection pool
See UCP for JDBC
UniversalConnectionPoolManager interface, 7.1.2
UniversalConnectionPoolManagerImpl, 7.1.2
unmatched labels, 5.5
URL, 2.2, 3.1.1, 3.1.2, 8.2.4
username, 2.2, 3.1.1, 3.1.2

V

validate connections
on borrow, 3.3.1
programmatically, 3.3.2
ValidConnection interface, 3.3.2, 3.5

W

web session affinity, 8.4

X

XA connections, 1.2.1, 3.1.2
XAConnection object, 1.2.1