SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

diagram of, 24
initialization, 26
invoking an SPJ, 23
loading Java classes, 28
registering an SPJ, 21
server process, 25
SQLException, 57
Static CALL statement, 76
Static Java variables, 52
Stored procedure in Java (SPJ), 68, 88, 97
argument list, 73
benefits of, 19
description of, 17
granting privileges on, 83
invoking, 22, 71
naming, 60
on systems running H-series RVUs, 35
registering, 21, 59
revoking privileges from, 85
SQL/MX processing of, 21, 23
steps for using, 18
syntax, 92
Stored procedure result set, 51
SUPPLIERINFO procedure
creating, 112, 119
invoking, 120
supplierInfo() method
code for, 111, 119
description of, 110
SUPPLYNUMBERS procedure
creating, 112, 120
invoking, 120
supplyQuantities() method
code for, 111, 120
description of, 110
Surrogate file see Procedure label
Syntax, SPJ, 92
System class loader, 28
System classes
description of, 28
required permissions, 48
System.err.println() method, 57
System.out.println() method
printing output, 57
SYSTEM_SQLJ_SCHEMA schema, 21
T
TBL_PRIVILEGES system metadata table, 22
TEXT system metadata table, 22
throw statement, 57
TOTALPRICE procedure
creating, 112, 117
invoking, 117
totalPrice() method
code for, 109, 116
description of, 107
Transaction behavior, 71
transactionMode property, 72
Troubleshooting guidelines, 101
Types data types, 81
U
UDR extensions class path, 36, 42
UDR_JAVA_OPTIONS default attribute
description of, 36
multiple settings, 39
performance considerations, 40
setting in a CONTROL QUERY DEFAULT statement, 37
setting in the SYSTEM_DEFAULTS table, 36
unique settings, 39
Unnamed parameter, 75
User-defined exceptions, 57
V
VALIDATEROUTINE, 21
Versions
See Software product versions, 32
W
WITH GRANT OPTION privilege, 83
126 Index