Index

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

A

access option, 6.1.8.1

adddefaulttypemap option, 6.1.7.1

addtypemap option, 6.1.7.2

Advanced Queue see AQ

AQ (Advanced Queue)

Java output, 2.5.2.7

publishing, 1.3

ARRAY class, features supported, 5.4

AS clause, translation statement, 6.2.2.1

attribute types, allowed, 3.1.5

B

backward compatibility

compatibility modes, 4.3.1

related option, 6.1.13

BigDecimal mapping

corresponding Java types, 6.1.6.3

overview, 2.4.2.3

builtintypes option, 6.1.6.1

C

case option, 6.1.8.2

case-sensitive SQL UDT names, 6.1.4.7, 6.2.2.1

classes, extending, 5.6.1

classpath option, 6.1.14.1

code generation, Java

generation of Java interfaces, 5.5

generation of non-SQLJ classes, 5.4

generation of SQLJ classes, 5.3

generation of toString() method, 6.1.8.14

related options, 6.1.8

serializability of object wrappers, 6.1.8.13

subclasses for Java-to-Java transformations, 5.6.2

support for inheritance, 5.7

treatment of output parameters, 5.1

treatment of overloaded methods, 5.2

code generation, PL/SQL

names of wrapper and dropper scripts, 6.1.9.2

related options, 6.1.9

specifying generation of wrapper functions, 6.1.9.3

collection types

output, 2.5.2.2

representing in Java, 2.4.1.1

command-line options see options

command-line syntax, 2.6.2

compatibility

backward, for JPublisher, 4.3.1

Oracle8i compatibility mode, 4.3.5.3

Oracle9i compatibility mode, 4.3.5.2

compatible option, 6.1.13.1

compile option, 6.1.10.1

compiler, specifying version, 6.1.14.2

compiler-executable option, 6.1.14.2

connection contexts (SQLJ)

definition, 2.2.2.2

release() method, 5.3.1

use of connection contexts and instances, 5.3.4

context option, 6.1.5.1

conventions, notation, 6.1.3

conversion functions, PL/SQL

introduction, predefined conversion functions, 2.4.1.3

use for PL/SQL types, 3.2.3

use with wrapper functions, 3.2.5

D

d option, 6.1.10.2

data link (URI type) mapping, 4.3.2

data type mappings

allowed object attribute types, 3.1.5

BigDecimal mapping, 2.4.2.3

-builtintypes option, 6.1.6.1

-compatible option, 6.1.13.1

data links, URI types, 4.3.2

indexed-by table support (general), 3.2.4

JDBC mapping, 2.4.2.1

JPublisher logical progression for mappings, 3.1.4

-lobtypes option, 6.1.6.2

mapping categories, 2.4.2

-mapping option (deprecated), 6.1.6.5

mapping to alternative class (subclass), syntax, 5.6.1.1

-numbertypes option, 6.1.6.3

Object JDBC mapping, 2.4.2.2

OPAQUE type support, 3.2.1.1

Oracle mapping, 2.4.2.4

overview, 3.1.1

PL/SQL conversion functions, 3.2.3

RECORD type support, 3.2.4

REF CURSORs and result sets, 3.1.6

relevant options, 6.1.6

scalar indexed-by table support with JDBC OCI, 3.2.2

special support for PL/SQL types, 3.2

table of mappings, 3.1.2

-usertypes option, 6.1.6.4

XMLTYPE support, 3.2.1.2

default (connection) context (SQLJ), 2.2.2.2

default type map, 3.1.3

defaulttypemap option, 6.1.7.3

dir option, 6.1.10.2

E

endpoint option, 6.1.11.2

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

execution contexts (SQLJ), 2.2.2.2

extending JPublisher-generated classes

changes after Oracle8i JPublisher, 4.3.4

concepts, 5.6.1

format of subclass, 5.6.1.2

-gensubclass option, 6.1.8.8

introduction, 5.6

F

filtering output

according to parameter modes, 4.2.2, 6.1.8.4

according to parameter types, 4.2.2, 6.1.8.5

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

to adhere to JavaBeans specification, 4.2.3, 6.1.8.6

filtermodes option, 6.1.8.4

filtertypes option, 6.1.8.5

G

GENERATE clause, translation statement, 6.2.2.1

generatebean option, 6.1.8.6

generation see code generation

genpattern option, 6.1.8.7

gensubclass option, 6.1.8.8

getConnection() method, 5.3.4

getConnectionContext() method, 5.3.4

H

handles, handle mechanism for wrapping instance methods, 1.6

holders

for passing output parameters, 5.1

-outarguments option for holder types, 6.1.8.11

using JAX-RPC holders, 5.1.2

httpproxy option, 6.1.11.3

I

i option (-input), 6.1.4.1

indexed-by table support

details, general indexed-by tables, 3.2.4

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

summary, general indexed-by tables, 3.1.2

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

inheritance, support through ORAData, 5.7

INPUT files

-input option, 6.1.4.1

package naming rules, 6.2.2.1

precautions, 6.2.3

structure and syntax, 6.2.2

syntax, 6.1.4.7

translation statement, 6.2.2.1

input files (general)

-input option (INPUT file), 6.1.4.1

overview, 2.5.1

properties files and INPUT files, 6.2

-props option (properties file), 6.1.4.6

input, JPublisher (overview), 2.5.1

input/output options, 6.1.10

interfaces, generation and use, 5.5

iterators (SQLJ), 2.2.2.2

J

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

java option, 6.1.4.2

JavaBeans spec, option for adherence, 4.2.3, 6.1.8.6, 6.1.8.6

Java-to-Java type mappings

code examples, A.1

-style option for style files, 6.1.6.6

styles and style files, 3.3

summary of mappings in Oracle style files, 3.3.3

use of JPublisher-generated subclass, 5.6.2

JAX-RPC holders, 5.1.2

JDBC mapping

corresponding Java types, 3.1.2, 6.1.6.3

overview, 2.4.2.1

JVM, specifying version, 6.1.14.3

L

limitations of JPublisher, 2.2.6

lobtypes option, 6.1.6.2

M

mapping option (deprecated), 6.1.6.5

mappings see data type mappings

method access option, 6.1.8.1

methods option, 6.1.8.9

methods, overloaded, translating, 5.2

N

native Java interface, 1.4

nested tables, output, 2.5.2.2

non-SQLJ classes, 2.2.2.1, 5.4

notational conventions, 6.1.3

numbertypes option, 6.1.6.3

O

Object JDBC mapping

corresponding Java types, 6.1.6.3

overview, 2.4.2.2

object types

classes generated for, 5.3.3

inheritance, 5.7.1

output, 2.5.2

publishing (introduction), 1.1

representing in Java, 2.4.1.1

omit_schema_names option, 6.1.8.10

OPAQUE type support

general support, 3.2.1.1

XMLTYPE support, 3.2.1.2

option syntax (command line), 2.6.2

options

-access option, 6.1.8.1

-adddefaulttypemap option, 6.1.7.1

-addtypemap option, 6.1.7.2

-builtintypes option, 6.1.6.1

-case option, 6.1.8.2

-classpath option, 6.1.14.1

code generation, 6.1.8

-compatible option, 6.1.13.1

-compile option, 6.1.10.1

-compiler-executable, 6.1.14.2

-context option, 6.1.5.1

-d option, 6.1.10.2

-defaulttypemap option, 6.1.7.3

-dir option, 6.1.10.2

-endpoint option, 6.1.11.2

-filtermodes option, 6.1.8.4

-filtertypes option, 6.1.8.5

for backward compatibility, 6.1.13

for SQLJ functionality, 6.1.12

for type mappings, 6.1.6

for type maps, 6.1.7

general tips, 6.1.2

-generatebean option, 6.1.8.6

-genpattern option, 6.1.8.7

-gensubclass option, 6.1.8.8

-httpproxy option, 6.1.11.3

-i option (-input), 6.1.4.1

-input option, 6.1.4.1

input/output, 6.1.10

-java option, 6.1.4.2

-lobtypes option, 6.1.6.2

-mapping option (deprecated), 6.1.6.5

-methods option, 6.1.8.9

-numbertypes option, 6.1.6.3

-omit_schema_names option, 6.1.8.10

-outarguments option, 6.1.8.11

-p option (-props), 6.1.4.6

-package option, 6.1.8.12

-plsqlfile option, 6.1.9.2

-plsqlmap option, 6.1.9.3

-plsqlpackage option, 6.1.9.4

-props option (properties file), 6.1.4.6

-proxywsdl option, 6.1.11.1

-s option (-sql), 6.1.4.7

-serializable option, 6.1.8.13

-sql option, 6.1.4.7

-sqlj option, 6.1.12.1

-sqlstatement option, 6.1.4.8

-style option, 6.1.6.6

summary and overview, 6.1

-sysuser option, 6.1.11.4

to facilitate Web services call-outs, 6.1.11

-tostring option, 6.1.8.14

-typemap option, 6.1.7.4

-types option (deprecated), 6.1.4.9

-u option (-user), 6.1.5.5

-user option, 6.1.5.5

-usertypes option, 6.1.6.4

-vm option, 6.1.14.3

Oracle mapping

corresponding Java types, 3.1.2

overview, 2.4.2.4

Oracle8i compatibility mode, 4.3.5.3

Oracle9i compatibility mode, 4.3.5.2

ORAData interface

object types and inheritance, 5.7.1

reference types and inheritance, 5.7.2

use of, 2.4.1.1

outarguments option, 6.1.8.11

output

-compile option, 6.1.10.1

-d option, 6.1.10.2

-dir option, 6.1.10.2

filtering JPublisher output, 4.2

overview, what JPublisher produces, 2.5.2

output options, 6.1.10

output parameters, passing

holders, 5.1

overview, 5.1

using arrays, 5.1.1

using function returns, 5.1.3

using JAX-RPC holders, 5.1.2

overloaded methods, translating, 5.2

P

p option (-props), 6.1.4.6

packages, Java

naming rules in INPUT file, 6.2.2.1

-package option, 6.1.8.12

packages, PL/SQL

generated classes for, 5.3.2

option for package name, 6.1.9.4

publishing (introduction), 1.2

permissions to execute PL/SQL packages, 6.1.11.4

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

PL/SQL data types, special support, 3.2

PL/SQL packages see packages, PL/SQL

PL/SQL subprograms, translating top level, 6.1.4.7

PL/SQL wrapper, 1.6

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

plsqlfile option, 6.1.9.2

plsqlmap option, 6.1.9.3

plsqlpackage option, 6.1.9.4

properties files

overview, 2.5.1

structure and syntax, 6.2.1

props option (properties file), 6.1.4.6

proxies, for Web services call-outs from database, 4.1.2, 6.1.11

proxywsdl option, 6.1.11.1

publishing

AQ, 1.3

PL/SQL packages, 1.2

queue, 1.3.1

server-side Java classes, 1.4

SQL object types, 1.1

stream, 1.3.3

topic, 1.3.2

R

RECORD type support

details, 3.2.4

summary, 3.1.2

REF CURSOR mapping, 3.1.6

reference types

inheritance, 5.7.2

representing in Java, 2.4.1.1

strongly-typed, 2.4.1.2

release() method (connection contexts), 5.3.1

requirements for JPublisher

general requirements, 2.2.3

packages and JARs in database, 2.2.4

result set mapping, 3.1.6

S

s option (-sql), 6.1.4.7

sample code

generated code for SQL statement, A.2

Java-to-Java transformations, A.1

sample translation, 2.6.3

scalar PL/SQL indexed-by table, 3.2.2

schema names, -omit_schema_names option, 6.1.8.10

serializable option, 6.1.8.13

server-side Java classes, publishing, 1.4

setConnectionContext() method, 5.3.4

setContextFrom() method, 5.3.5

setFrom() method, 5.3.5

setValueFrom() method, 5.3.5

singletons, singleton mechanism for wrapping instance methods, 1.6

SQL name clause, translation statement, 6.2.2.1

sql option, 6.1.4.7

SQL queries or DML statements

generated code example, A.2

SQLData interface

object types and inheritance, 5.7.3

use of, 2.4.1.1

SQLJ

connection contexts, 2.2.2.2

connection contexts and instances, use of, 5.3.4

default (connection) context, 2.2.2.2

execution contexts, 2.2.2.2

generation of SQLJ classes, 5.3

iterators, 2.2.2.2

JPublisher backward-compatibility modes and .sqlj files, 2.2.2.3

JPublisher -sqlj option to access SQLJ functionality, 6.1.12

migration options, 6.1.15

overview of SQLJ usage by JPublisher, 2.2.2.1

SQLJ classes, non-SQLJ classes, 2.2.2.1

sqlj option, 6.1.12.1

sqlstatement option, 6.1.4.8

strongly typed paradigm, 2.1

strongly-typed object references, 2.4.1.2

style option, 6.1.6.6

styles and style files

file formats, 3.3.2

overview, 3.3

specification and locations, 3.3.1

-style option, 6.1.6.6

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

subclassing JPublisher-generated classes see extending

syntax, command line, 2.6.2

sysuser option, 6.1.11.4

T

table functions (for Web services)

setting to return Web service data in table, 6.1.4.5

TABLE types see indexed-by tables

toplevel keyword (-sql option), 6.1.4.7

tostring option, 6.1.8.14

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

TRANSLATE...AS clause, translation statement, 6.2.2.1

translation

declare objects/packages to translate, 6.1.4.7

declare server-side classes to translate, 6.1.4.2

declare SQL statements to translate, 6.1.4.8

translation statement

in INPUT file, 6.2.2.1

sample statement, 6.2.2.2

type mappings see data type mappings

type maps

add to default type map, 6.1.7.1

add to user type map, 6.1.7.2

default type map, 3.1.3

option for default type map, 6.1.7.3

relevant options, 6.1.7

replace user type map, 6.1.7.4

user type map, 3.1.3

typemap option, 6.1.7.4

types option (deprecated), 6.1.4.9

U

u option (-user), 6.1.5.5

URI type mapping, 4.3.2

user option, 6.1.5.5

user type map, 3.1.3

usertypes option, 6.1.6.4

V

vm option, 6.1.14.3

W

Web services

options for call-outs from database, 6.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

Web services call-out, 1.8

wrapper functions, PL/SQL

introduction, 3.2.3

option to specify generation, 6.1.9.3

use for PL/SQL types, 3.2.5

wrapper methods

-methods option, 6.1.8.9

to invoke stored procedures, 2.1

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

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

X

XMLTYPE support, 3.2.1.2