Neoview Guide to Stored Procedures in Java (R2.2)

revoking, 52
showing in DB Admin, 60
Procedure Code Files Tool, 35
PROJECT table, 111
PROJECTTEAM procedure
creating, 95
invoking, 95
projectTeam() method
code for, 95
description of, 95
R
registerOutParameter() method, 69
Required software, 23
Result sets
coding in a Java method, 27
not specifying in a CALL statement, 65
returning in JDBC client applications, 69
returning in Neoview Script, 67
returning in ODBC client applications, 68
REVOKE EXECUTE statement, 52
REVOKE statement, 52
Rowsets, 63
S
Sales class, 75
SALES schema
CUSTOMER table, 114
DAILYORDERS procedure, 78
description of, 114
LOWERPRICE procedure, 76
MONTHLYORDERS procedure, 80
ODETAIL table, 116
ORDERS table, 115
ORDERSUMMARY procedure, 88
PARTDATA procedure, 84
PARTS table, 118
TOTALPRICE procedure, 82
Sample database, 107
Script files, 53
SHOW PROCEDURES command, example of, 49
Software, required, 23
SPJ (see Stored procedure in Java (SPJ))
SPJ JAR files (see JAR files)
SPJ method
accessing a Neoview database, 29
coding guidelines, 25
examples of, 75
referring to database objects, 31
returning output values, 26
returning result sets, 27
signature restrictions, 25
SQL data types, 26
SQL database objects, referring to, 31
SQL parameters, 64
SQLException, 32
sqlj.defaultconnection system property, 30
Static Java variables, 29
Stored procedure in Java (SPJ)
altering, 50
argument list, 64
benefits of, 19
creating, 43
description of, 19
displaying
in DB Admin, 47
in Neoview Script, 49
dropping, 49
examples of, 75
granting privileges on, 51
invoking, 63
revoking privileges from, 52
steps for using, 21
Stored procedure result set, 27
SUPPLIER table, 119
SUPPLIERINFO procedure
creating, 99
invoking, 101
supplierInfo() method
code for, 99
description of, 99
SUPPLYNUMBERS procedure
creating, 102
invoking, 103
supplyQuantities() method
code for, 102
description of, 102
T
throw statement, 32
TOPSALESREPS procedure
creating, 96
invoking, 97
topSalesReps() method
code for, 96
description of, 96
TOTALPRICE procedure
creating, 82
invoking, 83
totalPrice() method
code for, 82
description of, 82
Transaction behavior, 63
Triggers, 63, 70
Troubleshooting guidelines, 73
Types data types, 69
U
Unnamed parameter, 66
User-defined exceptions, 32
V
VERSION command, example of, 23
W
WITH GRANT OPTION privilege, 51
127