win32_11gR2_client.zip

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