samples-readme.txt

Java示例100

This is the README file for sample programs in the JDBC demo directory.

It contains the following sections:
* File types and their roles
* Directory Structure
* Setting Up Schemas
* Steps to run demo programs 
* JDK version



File types and their roles :
-----------------------------

The file demo.tar contains the following file types:
* Makefile -- under each directory, except for jdbcthin, there is a
      Makefile.  It is for compiling and executing the demo programs
      under the same directory.  It lists the features the samples
      demonstrate and their expected behavior.  It also contains
      instructions on how to set URL, environments, and other
      preparations prior to program executions.
* .java -- the demo program files. Most of the filenames indicate
      the features that the programs demonstrate.
* .sql -- SQL scripts to set up some tables needed by demo programs.
      They are invoked by corresponding Makefiles.
* .htm -- A file to test Applet. It also contains instructions on how
      to run the applet program.
* .txt -- The README file.



Directory Structure :
---------------------

Untar the file demo.tar to find our samples. You will get
the following directories and files:

samples: contains the following sub-directories:

samples/generic: contains samples that generally apply to 
all our 3 JDBC drivers (thin, jdbc-oci, and jdbc-kprb). 
Please modify the connect URLs to refer to the appropriate
driver (protocol, host, port, sid, servicename, see the 
Makefiles) to use these samples. The samples demonstrates:
  * basic JDBC1.22 features, such as Select, Insert,
    Checkup.
  * JDBC2.0 features, such as Objects, Reference, LOBs,
    Collections, Connection Pooling, XA, ConnectionCaching,
    DataSource, Scrollable ResultSet, and JDBC2.0 Batching.
  * JDBC3.0 features, such as transaction savepoint.
  * connection wrapping features: wrapping with the
    oracle.jdbc.OracleConnectionWrapper class. This can
    also be extended to create a customized wrapper.
  * Oracle 9i features, such as SQLJ Object Types,
    inheritance, and accessing nested collections 

samples/generic contains some sub directories, which 
demonstrate some Oracle 9i features. 

samples/jdbcoci: Contains samples for oci driver-specific 
features: OCI Connection Pooling, Ntier Authentication, PL/SQL
index-by tables and OCI application failover with callbacks.
Oracle 9i features, such as native-XA, are included in the sub-
directories. The JDBC oci driver should be used for these demos.
Please modify the connect URLs to refer to the appropriate driver 
(see the Makefiles for details).

samples/jdbcthin: examples of how to write applets using the thin
driver with the jdk1.1.x and jdk 1.2. You need to change the
connect_string in JdbcApplet.java before running this sample.

Samples-Readme.txt: this file.


NOTE: examples for kprb callins and instance methods using
Oracle 8 Object Types are provided in:
[ORACLE_HOME]/javavm/demo/demo.zip
After you unzip this file, the examples are created in:
[ORACLE_HOME]/javavm/demo/examples/jsp




Setting Up Schemas :
--------------------

It is assumed that all tables in the Oracle Sample Schema have
been set up and populated in the database prior to executing
these demos. Please refer to $ORACLE_HOME/demo/schema/README.txt
for the Sample Schema setup details.

For a quick start, you could use the SQL script mksample.sql
in the database install. Before executing the demos, start your
database, and then execute mksample.sql to create/populate all
the necessary tables.  These demo programs generally use the
HR/HR schema.



Steps to run demo programs :
----------------------------

* use .htm file
  Please refer to .htm for jdbcthin to build and execute
  applet example.

* use Makefile 
  For the other demo programs, please use the Makefiles under
  each directory for building and executing instructions.

  In general, each Makefile contains the targets "all, thin,
  oci, ocitns" for building and executing the demos using
  specific Oracle-JDBC drivers. Separated targets for each
  demo programs are also listed in each Makefile.
     NOTE: some demo programs need interactive inputs. 

  Makefiles provide the following information:
  -- features the demo programs under this directory
     demonstrate
  -- instructions on how to compile and execute demo
     programs under the same directory
  -- required JDK versions information and other environment
     setting information 
  -- neccessary preparations for each demo program 
  -- how to run the Makefile



JDK version :
-------------

  Either Makefile or comments near to the top of each sample
  program tells you which JDK version you should use to 
  compile and run. In many cases, it is possible to modify a
  sample program to compile and run in a different JDK version
  if desirable. Please refer to the JDBC Developer's Guide and
  Reference for details of how to use Oracle JDBC drivers with
  different JDK versions.

                           (-: End of Readme.txt :-)