Oracle JDBC Drivers 7.3.4 README


Versions
--------
  - Oracle Servers: 
    - JDBC OCI: Oracle 7 and up
    - JDBC Thin: Oracle 7.2 and up
  - Oracle Clients: 
    - JDBC OCI: Oracle 7.3.4.0.0
    - JDBC Thin: none
  - JDK: 1.0.2 or 1.1.x.
  - JDBC: 1.22
  - For applets: Netscape 3.0 or 4.0
  - Solaris: 2.5
  - Win95/NT: Win95, NT 3.51 and NT 4.0.

Note: You need the Oracle 8.0.3.0.2 patch on Windows 95 or NT 
if you are using JDBC THIN to connect to an Oracle 8.0.3 server


Changes from 7.3.3.1.4 (Beta release)
-------------------------------------

 - JDBC Thin now supports NLS databases.

 - Numerous bug fixes.


Installation
------------

To avoid potential confusion with the previous version of the JDBC
driver we highly recommend that you uninstall the alpha and/or beta 
release(s) before installing the production release.
 
Please do not try to have multiple versions of our drivers in
your CLASSPATH.


Win95/NT with the Oracle Installer

  - Use the Oracle Installer
  - Add [ORACLE_HOME]\jdbc\lib\classes111.zip to your CLASSPATH
    (If using JDK-1.0.2 add classes102.zip instead)


Solaris

  - Use the Oracle Installer
   - Add [ORACLE_HOME]/jdbc/lib/classes111.zip to your CLASSPATH
    (If using JDK-1.0.2 add classes102.zip instead)
  - Add [ORACLE_HOME]/jdbc/lib to your LD_LIBRARY_PATH



Known bugs and restrictions
---------------------------

Please see the on-line documentation in the DOC directory



What you get in the release
---------------------------

The "lib" directory contains:
  - classes111.zip: classes for use with the JDK 1.1.1.  Contains
    all the JDBC driver classes.
  - classes102.zip: classes for use with the JDK 1.0.2.  Contains
    all the JDBC driver classes and the JDBC 1.22 classes are they
    are not a standard part of the JDK 1.0.2 distribution.
  - oci73jdbc.dll (.so on Solaris): the shared library used by
    the JDBC OCI7 driver.  On Win95/NT the library is moved to the
    [ORACLE_HOME]\bin directory.
  

The "doc" directory contains the on-line documentation of the JDBC
drivers (contents.html).

The "samples" directory contains samples.




Usage (See special case for JDBC Thin 1.0.2 at the end)
-------------------------------------------------------


You must import the JDBC classes in your programs that use JDBC.

    import java.sql.*;
    import java.math.*;


Your JDBC program must register the Oracle driver before being able to use it.
To do that, include the following line at the beginning of your
"main":

    DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver ());


You open a connection to the database with the getConnection call.
The connection URL depend on the JDBC driver you want to use:

JDBC OCI7:

  Connection conn = 
    DriverManager.getConnection ("jdbc:oracle:oci7:@<database>",
                                 "scott", "tiger");

  <database> is either an entry in tnsnames.ora or a SQL*net
  name-value pair.


JDBC Thin:

  Connection conn = 
    DriverManager.getConnection ("jdbc:oracle:thin:@<database>",
                                 "scott", "tiger");

  <database> is either a string of the form <host>:<port>:<sid>
  or a SQL*net name-value pair.



Special case for the  JDBC Thin 1.0.2
-------------------------------------

For the  JDBC Thin 1.0.2 the imports, class name and URL are
different.

Imports:

    import jdbc.sql.*;
    import jdbc.math.*;

Registering the driver:
    DriverManager.registerDriver (new oracle.jdbc.dnlddriver.OracleDriver ());


JDBC Thin 1.0.2 URL:

  Connection conn = 
    DriverManager.getConnection ("jdbc:oracle:dnldthin:@<database>",
                                 "scott", "tiger");

  <database> is either a string of the form <host>:<port>:<sid>
  or a SQL*net name-value pair.