Oracle JDBC Drivers release 11.2.0.1.0 production Readme.txt
==========================================================
What Is New In This Release ?
-----------------------------
Universal Connection Pool
In this release the Oracle Implicit Connection Cache feature is
deprecated. Users are strongly encouraged to use the new Universal
Connection Pool instead. The UCP has all of the features of the
ICC, plus much more. The UCP is available in a separate jar file,
ucp.jar.
Column Security
When a table is XDS (eXtensible Data Security) enabled, some
objects (or rows) may be invisible to the user depending on the
security constraints. Moreover, an object (or row) can be visible
but some of its attributes (or columns) may not be. Starting in
11gR2, the JDBC drivers support these new security attributes and
let you determine whether a particular column has some security
attributes and whether a column value is null because it's hidden
or because it's actually null.
Secure Lob
Additional support for the Oracle Database 11.1 Secure LOB feature.
Lob prefetch
Improves the performance of some LOB read operations by fetching
the initial bytes or chars of the LOB along with the locator. For
very small LOBs, less than a few thousand bytes, the entire LOB
value may be fetched. This improves the performance of reads on
very small lobs and reads of the initial bytes or chars on all
LOBS.
Network Connection Pool
The network connection pool allows multiple java.sql.Connection
objects to share a limited number of network level channels. Each
Connection is associated with a single database session. The
Connection object communicates with the session over a network
channel. When the network connection pool is enabled, network
channels are shared among multiple Connection/session pairs. In
some situations this can reduce the resources consumed on both the
client and server and improve performance and scalability.
XMLType Queue Support in AQ
Oracle Database 11gR1 JDBC introduced high performance access to
Oracle Advanced Queueing. This release extends this support by
providing high performance access to queues that use SQL XMLType.
Notification Grouping in AQ and DCN
Notification Grouping is a new feature of JDBC Notification which
was included in Database 11gR1 and which includes AQ Notification
as well as Database Change Notification. You can now ask the
database to group notifications for example every 60 seconds. When
using Notification Grouping, you are given the option to either
get only the last notification or a summary of them.
TimeZone Patching
Improved support for time zones that are not directly supported by
the client Java environment.
Reduced Memory Footprint
In 10gR1 we rearchitected the drivers to improve performance at
the cost of increasing memory footprint, especially when using the
(highly recommended!) statement cache. We achieved our goal of
improving performance, but the increase in memory footprint has
sometimes proved problematic. The 11gR1 release retained the
performance improvements and reduced the memory footprint for
most users. The 11gR2 release provides some tuning options for
that subset of users that need them. This is users with large
numbers of connections and large statement caches. See the JavaDoc
for oracle.jdbc.OracleConnection.CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE
and CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE for details. Don't
worry about this unless you are running out of heap.
Driver Versions
---------------
These are the driver versions in the 11R2 release:
- JDBC Thin Driver 11R2
100% Java client-side JDBC driver for use in client applications,
middle-tier servers and applets.
- JDBC OCI Driver 11R2
Client-side JDBC driver for use on a machine where OCI 11R2
is installed.
- JDBC Thin Server-side Driver 11R2
JDBC driver for use in Java program in the database to access
remote Oracle databases.
- JDBC Server-side Internal Driver 11R2
Server-side JDBC driver for use by Java Stored procedures. This
driver used to be called the "JDBC Kprb Driver".
For complete documentation, please refer to "JDBC Developer's Guide
and Reference".
Contents Of This Release
------------------------
For all platforms:
[ORACLE_HOME]/jdbc/lib contains:
- ojdbc5.jar
Classes for use with JDK 1.5. It contains the JDBC driver
classes, except classes for NLS support in Oracle Object and
Collection types.
- ojdbc5_g.jar
Same as ojdbc5.jar, except that classes were compiled with
"javac -g" and contain tracing code.
- ojdbc5dms.jar
Same as ojdbc5.jar, except that it contains instrumentation to
support DMS and limited java.util.logging calls.
- ojdbc5dms_g.jar
Same as ojdbc5_g.jar, except that it contains instrumentation to
support DMS.
- ojdbc6.jar
Classes for use with JDK 1.6. It contains the JDBC driver classes
except classes for NLS support in Oracle Object and Collection
types.
- ojdbc6_g.jar
Same as ojdbc6.jar except compiled with "javac -g" and contains
tracing code.
- ojdbc6dms.jar
Same as ojdbc6.jar, except that it contains instrumentation to
support DMS and limited java.util.logging calls.
- ojdbc6dms_g.jar
Same as ojdbc6_g.jar except that it contains instrumentation to
support DMS.
Note: The dms versions of the jar files are the same as
standard jar files, except that they contain additional code
to support Oracle Dynamic Monitoring Service. They contain a
limited amount of tracing code. These can only be used
when dms.jar is in the classpath. dms.jar is provided as part of
Oracle Application Server releases. As a result the dms versions
of the jar files can only be used in an Oracle Application Server
environment.
[ORACLE_HOME]/jdbc/doc/javadoc.tar contains the JDBC Javadoc
for the public API of the public classes of Oracle JDBC. This
JavaDoc is the primary reference for Oracle JDBC API extensions. The
Oracle JDBC Development Guide contains high level discussion of
Oracle extensions. The details are in this JavaDoc. The JavaDoc is
every bit as authorative as the Dev Guide.
[ORACLE_HOME]/jdbc/demo/demo.tar contains sample JDBC programs.
[ORACLE_HOME]/jlib/orai18n.jar
NLS classes for use with JDK 1.5, and 1.6. It contains
classes for NLS support in Oracle Object and Collection types.
This jar file replaces the old nls_charset jar/zip files. In
Oracle 10g R1 it was duplicated in [ORACLE_HOME]/jdbc/lib. We
have removed the duplicate copy and you should now get it from
its proper location.
For the Windows platform:
[ORACLE_HOME]\bin directory contains ocijdbc11.dll and
heteroxa11.dll, which are the libraries used by the JDBC OCI
driver.
For non-Windows platforms:
[ORACLE_HOME]/lib directory contains libocijdbc11.so,
libocijdbc11_g.so, libheteroxa11.so and libheteroxa11_g.so, which
are the shared libraries used by the JDBC OCI driver.
NLS Extension Jar File (for client-side only)
---------------------------------------------
The JDBC Server-side Internal Driver provides complete NLS support.
It does not require any NLS extension jar file. Discussions in this
section only apply to the Oracle JDBC Thin and JDBC OCI drivers.
The basic jar files (ojdbc5.jar and ojdbc6.jar) contain all the
necessary classes to provide complete NLS support for:
- Oracle Character sets for CHAR/VARCHAR/LONGVARCHAR/CLOB type data
that is not retrieved or inserted as a data member of an Oracle
Object or Col