Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Structure

Related Documents

Conventions

Documentation Accessibility

1 Understanding and Using JPublisher

Understanding JPublisher

Introduction to JPublisher

What JPublisher Does

What JPublisher Produces

JPublisher Requirements

JPublisher Input and Output

Overview of Datatype Mappings

Creating Types and Packages in the Database

JPublisher Operation

Translating and Using PL/SQL Packages and User-Defined Types

Representing User-Defined Object, Collection, and Reference Types in Java

Strongly Typed Object References for ORAData Implementations

JPublisher Command-Line Syntax

Sample JPublisher Translation

Backwards Compatibility and Migration

JPublisher Backwards Compatibility

JPublisher Compatibility Between JDK Versions

Migration Between Oracle8i JPublisher and Oracle9i JPublisher

Details of Datatype Mapping

Datatype Mapping Tables

Allowed Object Attribute Types

Using Datatypes Not Supported by JDBC

Concepts of JPublisher-Generated Classes

Passing OUT Parameters

Translating Overloaded Methods

JPublisher Generation of SQLJ Classes

Use of SQLJ Classes JPublisher Generates for PL/SQL Packages

Use of Classes JPublisher Generates for Object Types

Use of Connection Contexts and Instances in SQLJ Code Generated by JPublisher

JPublisher Generation of Java Classes

User-Written Subclasses of JPublisher-Generated Classes

Extending JPublisher-Generated Classes

Changes in User-Written Subclasses of Oracle9i JPublisher-Generated Classes

The setFrom() and setValueFrom() Methods

JPublisher Support for Inheritance

ORAData Object Types and Inheritance

ORAData Reference Types and Inheritance

SQLData Object Types and Inheritance

Effect of Using SQL FINAL, NOT FINAL, INSTANTIABLE, NOT INSTANTIABLE

JPublisher Limitations

2 Command-Line Options and Input Files

JPublisher Options

JPublisher Option Summary

JPublisher Option Tips

Notational Conventions

Detailed Descriptions--Options That Affect Datatype Mappings

Detailed Descriptions--General JPublisher Options

JPublisher Input Files

Properties File Structure and Syntax

INPUT File Structure and Syntax

INPUT File Precautions

3 JPublisher Examples

Example: JPublisher Translations with Different Mappings

JPublisher Translation with the JDBC Mapping

JPublisher Translation with the Oracle Mapping

Example: JPublisher Object Attribute Mapping

Listing and Description of Address.java Generated by JPublisher

Listing of AddressRef.java Generated by JPublisher

Listing of Alltypes.java Generated by JPublisher

Listing of AlltypesRef.java Generated by JPublisher

Listing of Ntbl.java Generated by JPublisher

Listing of AddrArray.java Generated by JPublisher

Example: Generating a SQLData Class

Listing of Address.java Generated by JPublisher

Listing of Alltypes.java Generated by JPublisher

Example: Extending JPublisher Classes

Example: Wrappers Generated for Methods in Objects

Listing and Description of Rational.sqlj Generated by JPublisher

Example: Wrappers Generated for Methods in Packages

Listing and Description of RationalP.sqlj Generated by JPublisher

Example: Using Classes Generated for Object Types

Listing of RationalO.sql (Definition of Object Type)

Listing of JPubRationalO.sqlj Generated by JPublisher

Listing of RationalORef.java Generated by JPublisher

Listing of RationalO.java Written by User

Listing of TestRationalO.java Written by User

Example: Using Classes Generated for Packages

Listing of RationalP.sql (Definition of the Object Type and Package)

Listing of TestRationalP.java Written by a User

Example: Using Datatypes Not Supported by JDBC