oracle数据库客户端

Oracle JDBC Drivers release 10.2.0.1.0 production (10g R2) README ===================================================== What Is New In This Release ? ----------------------------- Support for J2SE 5.0 J2SE 5.0 (AKA J2SE 1.5 and Tiger) is fully supported. 5.0 supports JDBC 3.0, the same as J2SE 1.4, so there are no additional standard JDBC features. Prior to this release J2SE 5.0 was not officially supported. Duplicate copy of orai18n.jar has been removed. In 10.1.0.1.0 we replaced nls_charset12.jar with a new file for providing National Character Set support, orai18n.jar. This file was located in [ORACLE_HOME]/jdbc/lib/. Unfortunately this was a duplicate of the same file located in [ORACLE_HOME]/jlib/. Since orai18n.jar is used by other parts of Oracle, not just JDBC, the jlib directory is the correct location for this file. In this release we have removed the unneeded duplicate in [ORACLE_HOME]/jdbc/lib. Please update your classpaths to reference [ORACLE_HOME]/jlib/orai18n.jar as needed. Proxy Authentication In Oracle 10g R1 we introduced a new API for proxy authentication that was supported only by the Thin driver. In this release we extend support of that API to the OCI driver as well. We strongly recommend that you use the common API instead of the OCI specific API. JDBC 3.0 Features Complete support for all JDBC 3.0 features. - Autogenerated Keys are now supported. - Cursor Holdability methods now return the correct values rather rather than throwing SQLException. There is no change in the actual rdbms support for cursor holdability. - Local/Global Transaction Switching Runtime Connection Load Balancing RCLB is an exciting new feature that works in cooperation with RAC Load Balancer Advisory to dynamically allocate/reallocate connections based on real-time load and performance information. XA Connection Pooling Oracle JDBC has long supported connection caching, but not for XA connections. Oracle 10gR2 introduces the ability to cache XA connections as well as local connections. DML Returning Can you believe it! After all these years of saying "next release", DML returning is now supported in the Thin and OCI drivers. DML returning is a SQL language feature that permits SQL DMS statements (insert, update, delete) to return result sets. This is especially advantageous to return columns modified by triggers or autogenerated keys. Rowsets (JSR 114) JSR 114 defines substantial new functionality for RowSets. The oracle.jdbc.rowset classes are updated to implement the new functionality defined in JSR 114. SSL The ability to connect to the rdbms via Secure Socket Layer (SSL). Driver Versions --------------- These are the driver versions in the 10.2.0.1.0 release: - JDBC Thin Driver 10.2.0.1.0 100% Java client-side JDBC driver for use in client applications, middle-tier servers and applets. - JDBC OCI Driver 10.2.0.1.0 Client-side JDBC driver for use on a machine where OCI 10.2.0.1.0 is installed. - JDBC Thin Server-side Driver 10.2.0.1.0 JDBC driver for use in Java program in the database to access remote Oracle databases. - JDBC Server-side Internal Driver 10.2.0.1.0 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: - classes12.jar Classes for use with JDK 1.2 and JDK 1.3. It contains the JDBC driver classes, except classes for NLS support in Oracle Object and Collection types. - classes12_g.jar Same as classes12.jar, except that classes were compiled with "javac -g" and contain some tracing information. - classes12dms.jar Same as classes12.jar, except that it contains additional code to support Oracle Dynamic Monitoring Service. Can only be used when dms.jar is in the classpath. dms.jar is provided as part of recent Oracle Application Server releases. - classes12dms_g.jar Same as classes12dms.jar except that classes were compiled with "javac -g" and contain some tracing information. - ojdbc14.jar Classes for use with JDK 1.4 and 5.0. It contains the JDBC driver classes, except classes for NLS support in Oracle Object and Collection types. - ojdbc14_g.jar Same as ojdbc14.jar, except that classes were compiled with "javac -g" and contain some tracing information. - ojdbc14dms.jar Same as ojdbc14.jar, except that it contains additional code to support Oracle Dynamic Monitoring Service. Can only be used when dms.jar is in the classpath. dms.jar is provided as part of recent Oracle Application Server releases. - ojdbc14dms_g.jar Same as ojdbc14dms.jar except that classes were compiled with "javac -g" and contain some tracing information. [ORACLE_HOME]/jdbc/doc/javadoc.tar contains the JDBC Javadoc for the public API of the public classes of Oracle JDBC. [ORACLE_HOME]/jdbc/demo/demo.tar contains sample JDBC programs. [ORACLE_HOME]/jlib/orai18n.jar NLS classes for use with JDK 1.2, 1.3, 1.4, and 5.0. 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 ocijdbc10.dll and heteroxa10.dll, which are the libraries used by the JDBC OCI driver. For non-Windows platforms: [ORACLE_HOME]/lib directory contains libocijdbc10.so, libocijdbc10_g.so, libheteroxa10.so and libheteroxa10_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 (classes12.jar and ojdbc14.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 Collection type. - NLS support for CHAR/VARCHAR data members of Objects and Collections for a few commonly used character sets. These character sets are: US7ASCII, WE8DEC, WE8ISO8859P1, WE8MSWIN1252, and UTF8. Users must include the NLS extension jar file ([ORACLE_HOME]/jlib/orai18n.jar) in their CLASSPATH if utilization of other character sets in CHAR/VARCHAR data members of Objects/Collections is desired. The new orai18n.jar replaces the nls_charset*.* files in the 9i and older releases. The file orai18n.jar contains many important character-related files. Most of these files are essential to globalization support. Instead of extracting only the character-set files your application uses, it is safest to follow this three-step process: 1. Unpack orai18n.jar into a temporary directory. 2. Delete the character-set files that your application does not use. Do not delete any territory, collation sequence, or mapping files. 3. Create a new orai18n.jar file from the temporary directory and add the altered file to your CLASSPATH. See the JDBC Developers Guide for more information. In addition, users can also