Index

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

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, 1.5.2.7
publishing, 2.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, 1.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
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, 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.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, 1.2.5.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, 1.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, 1.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, 1.4.2.1
JPublisher logical progression for mappings, 3.1.4
-lobtypes option, 6.1.6.2
mapping categories, 1.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, 1.4.2.2
Oracle mapping, 1.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
default (connection) context (SQLJ), 1.2.5.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), 1.2.5.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, 2.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, 1.5.1
properties files and INPUT files, 6.2
-props option (properties file), 6.1.4.6
input, JPublisher (overview), 1.5.1
input/output options, 6.1.10
interfaces, generation and use, 5.5
iterators (SQLJ), 1.2.5.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
-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
JAX-RPC holders, 5.1.2
JDBC mapping
corresponding Java types, 3.1.2, 6.1.6.3
overview, 1.4.2.1
JVM, specifying version, 6.1.14.3

L

limitations of JPublisher, 1.2.7
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, 2.4
nested tables, output, 1.5.2.2
non-SQLJ classes, 1.2.5.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, 1.4.2.2
object types
classes generated for, 5.3.3
inheritance, 5.7.1
output, 1.5.2
publishing (introduction), 2.1
representing in Java, 1.4.1.1
omit_schema_names option, 6.1.8.10
option syntax (command line), 1.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, 1.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, 1.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, 1.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), 2.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, 2.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, 1.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, 2.3
PL/SQL packages, 2.2
queue, 2.3.1
server-side Java classes, 2.4
SQL object types, 2.1
stream, 2.3.3
topic, 2.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, 1.4.1.1
strongly-typed, 1.4.1.2
release() method (connection contexts), 5.3.1
requirements for JPublisher
general requirements, 1.2.2
result set mapping, 3.1.6

S

s option (-sql), 6.1.4.7
sample code
generated code for SQL statement, A.1
sample translation, 1.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, 2.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, 2.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.1
SQLData interface
object types and inheritance, 5.7.3
use of, 1.4.1.1
SQLJ
connection contexts, 1.2.5.2
connection contexts and instances, use of, 5.3.4
default (connection) context, 1.2.5.2
execution contexts, 1.2.5.2
generation of SQLJ classes, 5.3
iterators, 1.2.5.2
JPublisher backward-compatibility modes and .sqlj files, 1.2.5.3
JPublisher -sqlj option to access SQLJ functionality, 6.1.12
migration options, 6.1.15
overview of SQLJ usage by JPublisher, 1.2.5.1
SQLJ classes, non-SQLJ classes, 1.2.5.1
sqlj option, 6.1.12.1
sqljutl.jar, 1.2.4
sqlstatement option, 6.1.4.8
strongly typed paradigm, 1.1
strongly-typed object references, 1.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
subclassing JPublisher-generated classes see extending
syntax, command line, 1.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
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, 2.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, 1.1
wrapper packages, PL/SQL see packages, PL/SQL
wrapper procedures, to invoke Java from PL/SQL, 6.1.4.5