Oracle9i JPublisher User’s Guide

Wright B., Pfaeffle T., Thiesen P.A.

This user’s guide describes the Oracle ]Publisher utility, which translates user-defined SQL object types and PL/SQL packages to Java classes. SQLJ and JDBC programmers who need to have Java classes in their applications to correspond to object types, VARRAY types, nested table types, object reference types, or PL/SQL packages can use the JPublisher utility.This manual assumes that yon are an experienced Java programmer with knowledge of Oracle databases, SQL, PL/SQL, JDBC, and SQLJ.

---

Table of contents :
Send Us Your Comments……Page 7
Preface……Page 9
1 Understanding and Using JPublisher……Page 15
Introduction to JPublisher……Page 16
What JPublisher Produces……Page 18
JPublisher Requirements……Page 20
JPublisher Input and Output……Page 21
Overview of Datatype Mappings……Page 22
Creating Types and Packages in the Database……Page 23
Translating and Using PL/SQL Packages and User-Defined Types……Page 25
Representing User-Defined Object, Collection, and Reference Types in Java……Page 27
Strongly Typed Object References for ORAData Implementations……Page 28
Sample JPublisher Translation……Page 29
JPublisher Compatibility Between JDK Versions……Page 35
Migration Between Oracle8i JPublisher and Oracle9i JPublisher……Page 36
Details of Datatype Mapping……Page 40
Datatype Mapping Tables……Page 41
Allowed Object Attribute Types……Page 42
Using Datatypes Not Supported by JDBC……Page 43
Passing OUT Parameters……Page 44
Translating Overloaded Methods……Page 47
Use of SQLJ Classes JPublisher Generates for PL/SQL Packages……Page 48
Use of Classes JPublisher Generates for Object Types……Page 49
Use of Connection Contexts and Instances in SQLJ Code Generated by JPublisher……Page 51
JPublisher Generation of Java Classes……Page 55
Extending JPublisher-Generated Classes……Page 58
Changes in User-Written Subclasses of Oracle9i JPublisher-Generated Classes……Page 60
The setFrom() and setValueFrom() Methods……Page 62
ORAData Object Types and Inheritance……Page 63
ORAData Reference Types and Inheritance……Page 65
Effect of Using SQL FINAL, NOT FINAL, INSTANTIABLE, NOT INSTANTIABLE……Page 70
JPublisher Limitations……Page 72
2 Command-Line Options and Input Files……Page 73
JPublisher Option Summary……Page 74
JPublisher Option Tips……Page 76
Notational Conventions……Page 77
Detailed Descriptions—Options That Affect Datatype Mappings……Page 78
Detailed Descriptions—General JPublisher Options……Page 83
Properties File Structure and Syntax……Page 97
INPUT File Structure and Syntax……Page 98
INPUT File Precautions……Page 104
3 JPublisher Examples……Page 105
JPublisher Translation with the JDBC Mapping……Page 106
JPublisher Translation with the Oracle Mapping……Page 109
Example: JPublisher Object Attribute Mapping……Page 112
Listing and Description of Address.java Generated by JPublisher……Page 114
Listing of AddressRef.java Generated by JPublisher……Page 117
Listing of Alltypes.java Generated by JPublisher……Page 118
Listing of AlltypesRef.java Generated by JPublisher……Page 124
Listing of Ntbl.java Generated by JPublisher……Page 125
Listing of AddrArray.java Generated by JPublisher……Page 128
Listing of Address.java Generated by JPublisher……Page 131
Listing of Alltypes.java Generated by JPublisher……Page 133
Example: Extending JPublisher Classes……Page 140
Example: Wrappers Generated for Methods in Objects……Page 145
Listing and Description of Rational.sqlj Generated by JPublisher……Page 147
Example: Wrappers Generated for Methods in Packages……Page 152
Listing and Description of RationalP.sqlj Generated by JPublisher……Page 154
Example: Using Classes Generated for Object Types……Page 157
Listing of RationalO.sql (Definition of Object Type)……Page 159
Listing of JPubRationalO.sqlj Generated by JPublisher……Page 160
Listing of RationalORef.java Generated by JPublisher……Page 164
Listing of RationalO.java Written by User……Page 165
Listing of TestRationalO.java Written by User……Page 167
Example: Using Classes Generated for Packages……Page 169
Listing of RationalP.sql (Definition of the Object Type and Package)……Page 170
Listing of TestRationalP.java Written by a User……Page 172
Example: Using Datatypes Not Supported by JDBC……Page 174
Index……Page 183