Oracle8
i
JPublisher User's Guide
Release 2 (8.1.6)
Part Number A81357-01
Library
Service
Index
Contents
Title and Copyright Information
Send Us Your Comments
Preface
1 JPublisher
Understanding JPublisher
Introduction
JPublisher Requirements
What JPublisher Does
What JPublisher Produces
Type Mappings
Translating and Using PL/SQL Packages and Oracle Objects
Representing User-defined Object, Collection, and REF Types in Your Program
Sample JPublisher Command Line
Sample JPublisher Translation
Using JPublisher
Creating Types and Packages in the Database
Overview of JPublisher Input and Output
JPublisher Input
JPublisher Output
JPublisher Command Line Syntax
JPublisher Options
JPublisher Option Tips
Notational Conventions
Options That Affect Type Mappings
Other Options
Case of Java Identifiers (-case)
Output Directory for Generated Files (-dir)
JDBC Driver for Database Connection (-driver)
Java Character Encoding (-encoding)
File Containing Names of Objects and Packages to Translate (-input)
Generate Classes for Packages and Wrapper Methods for Methods (-methods)
Omit Schema Name from Generated Names (-omit_schema_names)
Name for Generated Packages (-package)
Input Properties File (-props)
Declare Object Types and Packages to Translate (-sql)
Declare Object Types to Translate (-types)
Connection URL for Target Database (-url)
User Name and Password for Database Connection (-user)
Input Files
Properties File Structure and Syntax
INPUT File Structure and Syntax
Understanding the Translation Statement
Sample Translation Statement
Extending JPublisher Classes
INPUT File Precautions
Requesting the Same Java Class Name for Different Object Types
Requesting the Same Attribute Name for Different Object Attributes
Specifying Nonexistent Attributes
Understanding Datatype Mappings
Datatype Mapping Tables
Allowed Object Attribute Types
Using Datatypes Not Supported by JDBC
Passing OUT Parameters
Passing the"this" Parameter
Translating Overloaded Methods
Using SQLJ Classes JPublisher Generates
Using SQLJ Classes JPublisher Generates for PL/SQL Packages
Using Classes JPublisher Generates for Object Types
General Comments about SQLJ Code JPublisher Generates
Using Java Classes JPublisher Generates
JPublisher Limitations
2 JPublisher Examples
Example: JPublisher Translations with Different Mappings
JPublisher Translation with the JDBC mapping
JPublisher Translation with the Oracle mapping
Example: JPublisher Type Mapping
JPublisher Type Mapping Example Output
Listing and Description of Address.java Generated by JPublisher
Listing and Description of AddressRef.java Generated by JPublisher
Listing and Description of Alltypes.java Generated by JPublisher
Listing and Description of AlltypesRef.java Generated by JPublisher
Listing and Description of Ntbl.java Generated by JPublisher
Listing and Description 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
Examples: JPublisher Wrapper Methods
Wrappers Generated for Methods in an Object Type
Listing and Description of Rational.sqlj Generated by JPublisher
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 to Create the Object Type
Listing of JPubRationalO.sqlj Generated by JPublisher
Listing of RationalORef.java Generated by JPublisher
Listing of RationalO.java Written by a User
Listing of TestRationalO.java Written by a User
Example: Using Classes Generated for Packages
Listing of RationalP.sql to Create the Object Type and Package
Listing of TestRationalP.java Written by a User
Example: Using Datatypes not Supported by JDBC
Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.
Library
Service
Index
