Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Organization

Related Documentation

Conventions

1 Introduction to JPublisher

Introduction to JPublisher Features

Invitation to JPublisher

Getting Started with JPublisher

New JPublisher Features in Oracle9i Release 2

Understanding JPublisher

JPublisher Object Type Mappings and PL/SQL Mappings

JPublisher Processes

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

2 JPublisher Concepts

Details of Datatype Mapping

SQL and PL/SQL Mappings to Oracle and JDBC Types

Allowed Object Attribute Types

Using Datatypes Unsupported by JDBC

Concepts of JPublisher-Generated Classes

Passing OUT Parameters

Translating Overloaded Methods

JPublisher Generation of SQLJ Classes (.sqlj)

Important Notes About 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 (.java)

User-Written Subclasses of JPublisher-Generated Classes

Extending JPublisher-Generated Classes

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

The setFrom(), setValueFrom(), and setContextFrom() 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

Backward Compatibility and Migration

JPublisher Backward Compatibility

JPublisher Compatibility Between JDK Versions

Migration Between Oracle8i JPublisher and Oracle9i JPublisher

JPublisher Limitations

3 Command-Line Options and Input Files

JPublisher Options

JPublisher Option Summary

JPublisher Option Tips

Notational Conventions

Detailed Descriptions of Options That Affect Datatype Mappings

Detailed Descriptions of General JPublisher Options

JPublisher Input Files

Properties File Structure and Syntax

INPUT File Structure and Syntax

INPUT File Precautions

4 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.sqlj Generated by JPublisher and Modified 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 User

Example: Using Datatypes Unsupported by JDBC

The User-Defined BOOLEANS Datatype

Alternative 1: Using JPublisher for the Entire Process

Alternative 2: Manual Conversion

Index