Index

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

A

access option, 5.1.8.1

adddefaulttypemap option, 5.1.7.1

addtypemap option, 5.1.7.2

ARRAY class, features supported, 3.4

AS clause, translation statement, 5.3.2.1

attribute types, allowed, 2.1.5

B

backward compatibility

compatibility modes, 4.3.1

related option, 5.1.13

BigDecimal mapping

corresponding Java types, 5.1.6.3

overview, 1.4.2.3

builtintypes option, 5.1.6.1

C

call specs, PL/SQL, 5.1.11.1

call-ins, Web services, 1.2.1.2

call-outs, Web services, 1.2.1.2

case option, 5.1.8.2

case-sensitive SQL UDT names, 5.1.4.4, 5.3.2.1

classes, extending, 3.6.1

classpath option, 5.1.14.1

classpath, awareness of environment classpath, 1.2.1.2

code generation, Java

class generation with handles, 5.2.2

class generation without handles, 5.2.1

for method parameters, 5.2.3

for wrapper classes, 5.2

generation of Java interfaces, 3.5

generation of non-SQLJ classes, 3.4

generation of SQLJ classes, 3.3

generation of toString() method, 5.1.8.13

mapping for JavaBeans arguments, 5.2.3

related options, 5.1.8

serializability of object wrappers, 5.1.8.12

subclasses for Java-to-Java transformations, 3.6.2

support for inheritance, 3.7

treatment of output parameters, 3.1

treatment of overloaded methods, 3.2

code generation, PL/SQL

for table functions, 5.2.4

names of wrapper and dropper scripts, 5.1.9.1

PL/SQL wrappers (call specs), 5.2

related options, 5.1.9

specifying generation of wrapper functions, 5.1.9.2

collection types

output, 1.5.2.2

representing in Java, 1.4.1.1

command-line options--see options

command-line syntax, 1.6.2

compatibility

backward, for JPublisher, 4.3.1

Oracle8i compatibility mode, 4.3.4.3

Oracle9i compatibility mode, 4.3.4.2

compatible option, 5.1.13.1

compile option, 5.1.10.1

compiler, specifying version, 5.1.14.2

compiler-executable option, 5.1.14.2

connection contexts (SQLJ)

definition, 1.2.2.2

release() method, 3.3.1

use of connection contexts and instances, 3.3.4

context option, 5.1.5.1

conventions, notation, 5.1.3

conversion functions, PL/SQL

introduction, predefined conversion functions, 1.4.1.3

use for PL/SQL types, 2.2.3

use with wrapper functions, 2.2.5

D

d option, 5.1.10.2

data link (URI type) mapping, 2.1.7

datatype mappings

allowed object attribute types, 2.1.5

BigDecimal mapping, 1.4.2.3

-builtintypes option, 5.1.6.1

-compatible option, 5.1.13.1

data links, URI types, 2.1.7

indexed-by table support (general), 2.2.4

JDBC mapping, 1.4.2.1

JPublisher logical progression for mappings, 2.1.4

-lobtypes option, 5.1.6.2

mapping categories, 1.4.2

-mapping option (deprecated), 5.1.6.5

mapping to alternative class (subclass), syntax, 3.6.1.1

-numbertypes option, 5.1.6.3

Object JDBC mapping, 1.4.2.2

OPAQUE type support, 2.2.1.1

Oracle mapping, 1.4.2.4

overview, 2.1.1

PL/SQL conversion functions, 2.2.3

RECORD type support, 2.2.4

REF CURSORs and result sets, 2.1.6

relevant options, 5.1.6

scalar indexed-by table support with JDBC OCI, 2.2.2

special support for PL/SQL types, 2.2

table of mappings, 2.1.2

-usertypes option, 5.1.6.4

XMLTYPE support, 2.2.1.2

default (connection) context (SQLJ), 1.2.2.2

default type map, 2.1.3

defaulttypemap option, 5.1.7.3

dir option, 5.1.10.2

DML statements, publishing, 1.3.4

E

endpoint option, 5.1.11.5

environment, options for Java classpath, compiler, JVM, 5.1.14

execution contexts (SQLJ), 1.2.2.2

extending JPublisher-generated classes

changes after Oracle8i JPublisher, 4.3.3

concepts, 3.6.1

format of subclass, 3.6.1.2

-gensubclass option, 5.1.8.7

introduction, 3.6

F

filtering output

according to parameter modes, 4.2.2, 5.1.8.3

according to parameter types, 4.2.2, 5.1.8.4

publishing a subset of stored procedures or functions, 4.2.1, 5.1.4.4

to adhere to JavaBeans specification, 4.2.3, 5.1.8.5

filtermodes option, 5.1.8.3

filtertypes option, 5.1.8.4

G

GENERATE clause, translation statement, 5.3.2.1

generatebean option, 5.1.8.5

generation--see code generation

genpattern option, 5.1.8.6

gensubclass option, 5.1.8.7

getConnection() method, 3.3.4

getConnectionContext() method, 3.3.4

graphs, for table functions, 5.2.4

H

handles, handle mechanism for wrapping instance methods, 5.1.11.1

holders

for passing output parameters, 3.1

-outarguments option for holder types, 5.1.8.10

using JAX-RPC holders, 3.1.2

httpproxy option, 5.1.11.6

I

i option (-input), 5.1.4.1

indexed-by table support

details, general indexed-by tables, 2.2.4

details, scalar indexed-by tables (JDBC OCI), 2.2.2

summary, general indexed-by tables, 2.1.2

summary, scalar indexed-by tables (JDBC OCI), 2.1.2

inheritance, support through ORAData, 3.7

INPUT files

-input option, 5.1.4.1

package naming rules, 5.3.2.1

precautions, 5.3.3

structure and syntax, 5.3.2

syntax, 5.1.4.4

translation statement, 5.3.2.1

input files (general)

-input option (INPUT file), 5.1.4.1

overview, 1.5.1

properties files and INPUT files, 5.3

-props option (properties file), 5.1.4.3

input, JPublisher (overview), 1.5.1

input/output options, 5.1.10

interfaces, generation and use, 3.5

iterators (SQLJ), 1.2.2.2

J

Java environment, options for classpath, compiler, JVM, 5.1.14

java option, 5.1.4.2

JavaBeans arguments, mapping to STRUCT, 5.2.3

JavaBeans spec, option for adherence, 4.2.3, 5.1.8.5, 5.1.8.5

Java-to-Java type mappings

code examples, A.1

-style option for style files, 5.1.6.6

styles and style files, 2.3

summary of mappings in Oracle style files, 2.3.3

use of JPublisher-generated subclass, 3.6.2

JAX-RPC holders, 3.1.2

JDBC mapping

corresponding Java types, 2.1.2, 5.1.6.3

overview, 1.4.2.1

JVM, specifying version, 5.1.14.3

L

limitations of JPublisher, 1.2.6

lobtypes option, 5.1.6.2

M

mapping option (deprecated), 5.1.6.5

mappings--see datatype mappings

method access option, 5.1.8.1

methods option, 5.1.8.8

methods, overloaded, translating, 3.2

N

nested tables, output, 1.5.2.2

new features in Oracle Database 10g, 1.2.1

non-SQLJ classes, 1.2.2.1, 3.4

notational conventions, 5.1.3

numbertypes option, 5.1.6.3

O

Object JDBC mapping

corresponding Java types, 5.1.6.3

overview, 1.4.2.2

object types

classes generated for, 3.3.3

inheritance, 3.7.1

output, 1.5.2

publishing (introduction), 1.3.1

representing in Java, 1.4.1.1

omit_schema_names option, 5.1.8.9

OPAQUE type support

general support, 2.2.1.1

XMLTYPE support, 2.2.1.2

option syntax (command line), 1.6.2

options

-access option, 5.1.8.1

-adddefaulttypemap option, 5.1.7.1

-addtypemap option, 5.1.7.2

-builtintypes option, 5.1.6.1

-case option, 5.1.8.2

-classpath option, 5.1.14.1

code generation, 5.1.8

-compatible option, 5.1.13.1

-compile option, 5.1.10.1

-compiler-executable, 5.1.14.2

-context option, 5.1.5.1

-d option, 5.1.10.2

-defaulttypemap option, 5.1.7.3

-dir option, 5.1.10.2

-endpoint option, 5.1.11.5

-filtermodes option, 5.1.8.3

-filtertypes option, 5.1.8.4

for backward compatibility, 5.1.13

for SQLJ functionality, 5.1.12

for type mappings, 5.1.6

for type maps, 5.1.7

general tips, 5.1.2

-generatebean option, 5.1.8.5

-genpattern option, 5.1.8.6

-gensubclass option, 5.1.8.7

-httpproxy option, 5.1.11.6

-i option (-input), 5.1.4.1

-input option, 5.1.4.1

input/output, 5.1.10

-java option, 5.1.4.2

-lobtypes option, 5.1.6.2

-mapping option (deprecated), 5.1.6.5

-methods option, 5.1.8.8

-numbertypes option, 5.1.6.3

-omit_schema_names option, 5.1.8.9

-outarguments option, 5.1.8.10

-p option (-props), 5.1.4.3

-package option, 5.1.8.11

-plsqlfile option, 5.1.9.1

-plsqlmap option, 5.1.9.2

-plsqlpackage option, 5.1.9.3

-props option (properties file), 5.1.4.3

-proxyclasses option, 5.1.11.2

-proxyopts option, 5.1.11.3

-proxywsdl option, 5.1.11.4

-s option (-sql), 5.1.4.4

-serializable option, 5.1.8.12

-sql option, 5.1.4.4

-sqlj option, 5.1.12.1

-sqlstatement option, 5.1.4.5

-style option, 5.1.6.6

summary and overview, 5.1

-sysuser option, 5.1.11.7

to facilitate Web services call-outs, 5.1.11

-tostring option, 5.1.8.13

-typemap option, 5.1.7.4

-types option (deprecated), 5.1.4.6

-u option (-user), 5.1.5.4

-user option, 5.1.5.4

-usertypes option, 5.1.6.4

-vm option, 5.1.14.3

Oracle Database 10g, new JPublisher features, 1.2.1

Oracle mapping

corresponding Java types, 2.1.2

overview, 1.4.2.4

Oracle8i compatibility mode, 4.3.4.3

Oracle9i compatibility mode, 4.3.4.2

ORAData interface

object types and inheritance, 3.7.1

reference types and inheritance, 3.7.2

use of, 1.4.1.1

outarguments option, 5.1.8.10

output

-compile option, 5.1.10.1

-d option, 5.1.10.2

-dir option, 5.1.10.2

filtering JPublisher output, 4.2

overview, what JPublisher produces, 1.5.2

output options, 5.1.10

output parameters, passing

holders, 3.1

overview, 3.1

using arrays, 3.1.1

using function returns, 3.1.3

using JAX-RPC holders, 3.1.2

overloaded methods, translating, 3.2

P

p option (-props), 5.1.4.3

packages, Java

naming rules in INPUT file, 5.3.2.1

-package option, 5.1.8.11

packages, PL/SQL

generated classes for, 3.3.2

option for package name, 5.1.9.3

publishing (introduction), 1.3.2

permissions to execute PL/SQL packages, 5.1.11.7, A.3.4

PL/SQL call specs, 5.1.11.1

PL/SQL conversion functions--see conversion functions, PL/SQL

PL/SQL datatypes, special support, 2.2

PL/SQL packages--see packages, PL/SQL

PL/SQL subprograms, translating top level, 5.1.4.4

PL/SQL wrapper functions--see wrapper functions, PL/SQL

PL/SQL wrappers (call specs), 5.1.11.1

plsqlfile option, 5.1.9.1

plsqlmap option, 5.1.9.2

plsqlpackage option, 5.1.9.3

privileges--see permissions

properties files

overview, 1.5.1

structure and syntax, 5.3.1

props option (properties file), 5.1.4.3

proxies, for Web services call-outs from database, 4.1.2, 5.1.11, A.3

proxyclasses option, 5.1.11.2

proxyopts option, 5.1.11.3

proxywsdl option, 5.1.11.4

publishing

PL/SQL packages, 1.3.2

proxy classes and wrappers for Web services call-outs, 1.3.5

server-side Java classes, 1.3.3

SQL object types, 1.3.1

SQL queries or DML statements, 1.3.4

Q

queries, publishing, 1.3.4

R

RECORD type support

details, 2.2.4

summary, 2.1.2

REF CURSOR mapping, 2.1.6

reference types

inheritance, 3.7.2

representing in Java, 1.4.1.1

strongly typed, 1.4.1.2

release() method (connection contexts), 3.3.1

requirements for JPublisher

general requirements, 1.2.3

packages and JARs in database, 1.2.4

result set mapping, 2.1.6

S

s option (-sql), 5.1.4.4

sample code

generated code for SQL statement, A.2

generated Java and PL/SQL wrappers for general use, A.4

generated Java and PL/SQL wrappers for Web services, A.3

Java-to-Java transformations, A.1

proxies, for Web services call-outs from database, A.3

sample translation, 1.6.3

schema names, -omit_schema_names option, 5.1.8.9

serializable option, 5.1.8.12

server-side Java classes, publishing, 1.3.3

setConnectionContext() method, 3.3.4

setContextFrom() method, 3.3.5

setFrom() method, 3.3.5

setValueFrom() method, 3.3.5

singletons, singleton mechanism for wrapping instance methods, 5.1.11.1

SQL name clause, translation statement, 5.3.2.1

sql option, 5.1.4.4

SQL queries or DML statements

generated code example, A.2

publishing, 1.3.4

SQLData interface

object types and inheritance, 3.7.3

use of, 1.4.1.1

SQLJ

connection contexts, 1.2.2.2

connection contexts and instances, use of, 3.3.4

default (connection) context, 1.2.2.2

execution contexts, 1.2.2.2

generation of SQLJ classes, 3.3

iterators, 1.2.2.2

JPublisher backward compatibility modes and .sqlj files, 1.2.2.3

JPublisher -sqlj option to access SQLJ functionality, 5.1.12

overview of SQLJ usage by JPublisher, 1.2.2.1

SQLJ classes, non-SQLJ classes, 1.2.2.1

sqlj option, 5.1.12.1

sqlstatement option, 5.1.4.5

strongly typed, 1.1

strongly typed object references, 1.4.1.2

style option, 5.1.6.6

styles and style files

file formats, 2.3.2

overview, 2.3

specification and locations, 2.3.1

-style option, 5.1.6.6

subclasses, JPublisher-generated for Java-to-Java, 3.6.2

subclassing JPublisher-generated classes--see extending

syntax, command line, 1.6.2

sysuser option, 5.1.11.7

T

table functions (for Web services)

code generation, 5.2.4

definition in PL/SQL wrapper, A.3.3

graphs, 5.2.4

setting to return Web service data in table, 5.1.11.3

TABLE types--see indexed-by tables

toplevel keyword (-sql option), 5.1.4.4

tostring option, 5.1.8.13

transformations, Java-to-Java--see Java-to-Java type mappings

TRANSLATE...AS clause, translation statement, 5.3.2.1

translation

declare objects/packages to translate, 5.1.4.4

declare server-side classes to translate, 5.1.4.2

declare SQL statements to translate, 5.1.4.5

translation statement

in INPUT file, 5.3.2.1

sample statement, 5.3.2.2

type mappings--see datatype mappings

type maps

add to default type map, 5.1.7.1

add to user type map, 5.1.7.2

default type map, 2.1.3

option for default type map, 5.1.7.3

relevant options, 5.1.7

replace user type map, 5.1.7.4

user type map, 2.1.3

typemap option, 5.1.7.4

types option (deprecated), 5.1.4.6

U

u option (-user), 5.1.5.4

URI type mapping, 2.1.7

user option, 5.1.5.4

user type map, 2.1.3

usertypes option, 5.1.6.4

V

VARRAY, output, 1.5.2.2

vm option, 5.1.14.3

W

Web services

call-ins, 1.2.1.2

call-outs, 1.2.1.2

code generation for Web services call-outs, 5.2

options for call-outs from database, 5.1.11

overview of JPublisher support, 4.1

support for call-ins to database, 4.1.1

support for call-outs from database, 4.1.2

table functions, 5.2.4

wrapper functions, PL/SQL

introduction, 2.2.3

option to specify generation, 5.1.9.2

use for PL/SQL types, 2.2.5

wrapper methods

-methods option, 5.1.8.8

to invoke stored procedures, 1.1

wrapper packages, PL/SQL--see packages, PL/SQL

wrapper procedures, to invoke Java from PL/SQL, 5.1.11.3

wrappers, PL/SQL (call specs), 5.1.11.1

wrappers, sample Java and PL/SQL wrappers for general use, A.4

wrappers, sample Java and PL/SQL wrappers for Web services, A.3

WSDL, 1.3.5

X

XMLTYPE support, 2.2.1.2