Index

A  B  C  D  E  G  I  J  L  M  N  O  P  R  S  T  U  V  W 

---

A

access option, 3-13

adddefaulttypemap option, 3-14

addtypemap option, 3-14

ARRAY class, features supported, 2-33

AS clause, translation statement, 3-36

attribute mapping, sample program, 4-8

attribute types, allowed, 2-6

---

B

backward compatibility for JPublisher, 2-49

BigDecimal mapping, 1-19

builtintypes option, 3-11

---

C

case option, 3-15

case-sensitive SQL UDT names, 3-27, 3-36

classes, extending, 2-34

collection types

output, 1-17

representing in Java, 1-23

command-line options--see options

command-line syntax, 1-25

compatibility

backward, for JPublisher, 2-49

between JDK versions, 2-49

Oracle8i compatibility mode, 2-52

compatible option, 3-9

connection contexts and instances, use of, 2-27

context option, 3-16

conventions, notation, 3-6

CREATE PACKAGE BODY statement, 1-19

CREATE PACKAGE statement, 1-19

CREATE TYPE statement, 1-19

---

D

datatype mappings

allowed object attribute types, 2-6

BigDecimal mapping, 1-19

-builtintypes option, 3-11

-compatible option, 3-9

datatype tables, 2-3

details of use, 2-2

indexed-by table support (general), 2-16

indexed-by table support with JDBC OCI, 2-9

JDBC mapping, 1-18

-lobtypes option, 3-11

-mapping option (deprecated), 3-12

mapping to alternative class (subclass), syntax, 2-35

-numbertypes option, 3-10

Object JDBC mapping, 1-18

OPAQUE type support, 2-8

Oracle mapping, 1-19

overview, 1-18

PL/SQL conversion functions, 2-11

RECORD type support, 2-14

relevant options, 3-7

sample program, 4-2

-usertypes option, 3-8

using types not supported by JDBC, 2-7, 2-19

using types not supported by JDBC, sample program, 4-71

default type map, 2-18

defaulttypemap option, 3-17

dir option, 3-18

---

E

extending JPublisher-generated classes

changes in Oracle9i JPublisher, 2-36

concepts, 2-34

format of subclass, 2-35

-gensubclass option, 3-20

introduction, 2-34

sample program, 4-36

---

G

GENERATE clause, translation statement, 3-37

gensubclass option, 3-20

getConnection() method, 2-29

getConnectionContext() method, 2-29

getting started, 1-3

---

I

i option (-input), 3-20

indexed-by table support, 2-6

general support, 2-16

with JDBC OCI, 2-9

inheritance, support through ORAData, 2-39

INPUT files

package naming rules, 3-38

precautions, 3-41

structure and syntax, 3-35

translation statement, 3-35

input files

overview, 1-17

properties files and INPUT files, 3-33

-props option (properties file), 3-25

input option, 3-20

input, JPublisher (overview), 1-17

---

J

Java classes, generation and use, 2-31

JDBC mapping

overview, 1-18

sample program, 4-2

JDK versions, JPublisher compatibility, 2-49

---

L

limitations of JPublisher, 2-55

lobtypes option, 3-11

---

M

mapping option (deprecated), 3-12

mappings--see datatype mappings

method access option, 3-13

methods option, 3-21

methods, overloaded, translating, 2-23

---

N

nested table types, creating in the database, 1-19

nested tables, output, 1-17

new features in Oracle9i, 1-9

notational conventions, 3-6

numbertypes option, 3-10

---

O

Object JDBC mapping, 1-18

object types

classes generated for, 2-26

creating in the database, 1-19

inheritance, 2-39

output, 1-17

publishing (introduction), 1-4

representing in Java, 1-23

translation, 1-21

using generated classes, sample program, 4-54

with JPublisher, overview, 1-11

omit_schema_names option, 3-22

OPAQUE type support, 2-8

option syntax (command line), 1-25

options

-access option, 3-13

-adddefaulttypemap option, 3-14

-addtypemap option, 3-14

-builtintypes option, 3-11

-case option, 3-15

-compatible option, 3-9

-context option, 3-16

-defaulttypemap option, 3-17

-dir option, 3-18

general options, 3-13

general tips, 3-5

-gensubclass option, 3-20

-i option (-input), 3-20

-input option, 3-20

-lobtypes option, 3-11

-mapping option (deprecated), 3-12

-methods option, 3-21

-numbertypes option, 3-10

-omit_schema_names option, 3-22

-p option (-props), 3-25

-package option, 3-23

-plsqlfile option, 3-24

-plsqlmap option, 3-24

-plsqlpackage option, 3-25

-props option (properties file), 3-25

-s option (-sql), 3-26

-serializable option, 3-26

-sql option, 3-26

summary and overview, 3-2

that affect type mappings, 3-7

-tostring option, 3-29

-typemap option, 3-29

-types option (deprecated), 3-30

-u option (-user), 3-32

-user option, 3-32

-usertypes option, 3-8

Oracle mapping

overview, 1-19

sample program, 4-5

Oracle8i compatibility mode, 2-52

Oracle9i, new JPublisher features, 1-9

ORAData interface

object types and inheritance, 2-39

reference types and inheritance, 2-42

use by JPublisher, 1-11

OUT parameters, passing, 2-20

output

-dir option, 3-18

from JPublisher (overview), 1-17

overview, what JPublisher produces, 1-13

overloaded methods, translating, 2-23

---

P

p option (-props), 3-25

packages

creating in the database, 1-19

naming rules in INPUT file, 3-38

-package option, 3-23

using generated classes, sample program, 4-66

PL/SQL conversion functions, 2-11

PL/SQL packages

generated classes for, 2-25

output, 1-17

publishing (introduction), 1-7

translation, 1-21

with JPublisher, overview, 1-11

PL/SQL subprograms, translating top level, 3-27

PL/SQL wrapper code

controlling generation, 3-24

generation of toString() method, 3-29

serializability of object wrappers, 3-26

specifying file name, 3-24

specifying package name, 3-25

plsqlfile option, 3-24

plsqlmap option, 3-24

plsqlpackage option, 3-25

properties files

overview, 1-17

structure and syntax, 3-33

props option (properties file), 3-25

---

R

RECORD type support, 2-14

reference types

inheritance, 2-42

representing in Java, 1-23

strongly typed, 1-24

release() method (releasing connection contexts), 2-30, 4-44

requirements for JPublisher, 1-15

---

S

s option (-sql), 3-26

sample translation, 1-26

schema names, -omit_schema_names option, 3-22

serializable option, 3-26

setConnectionContext() method, 2-28

setContextFrom() method, 2-38

setFrom() method, 2-38

setValueFrom() method, 2-38

SQL name clause, translation statement, 3-35

sql option, 3-26

SQLData interface

object types and inheritance, 2-47

sample, generated SQLData class, 4-28

use by JPublisher, 1-11

SQLJ classes, generation and use, 2-24

strongly typed object references, 1-24

subclassing JPublisher-generated classes--see extending

syntax, command line, 1-25

---

T

TABLE types--see indexed-by tables

toplevel keyword (-sql option), 3-27

tostring option, 3-29

TRANSLATE...AS clause, translation statement, 3-37

translation

declare objects/packages to translate, 3-26

of types, steps involved, 1-21

translation statement

in INPUT file, 3-35

sample statement, 3-40

type mappings--see datatype mappings

type maps

add to default type map, 3-14

add to user type map, 3-14

default type map, 2-18

option for default type map, 3-17

replace user type map, 3-29

user type map, 2-18

typemap option, 3-29

types option (deprecated), 3-30

types, creating in the database, 1-19

---

U

u option (-user), 3-32

user option, 3-32

user type map, 2-18

usertypes option, 3-8

---

V

VARRAY types, creating in the database, 1-19

VARRAY, output, 1-17

---

W

wrapper methods

for object, sample program, 4-42

-methods option, 3-21