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

Invoking SPJs
description of, 63
examples of, 75
JDBC client application, 69
Neoview Script, 66
ODBC client application, 68
privileges, 51
restrictions, 63
transaction behavior, 63
J
JAR files
deleting on the Neoview platform, 41
downloading to a client workstation, 38
renaming on the Neoview platform, 39
uploading to the Neoview platform, 35
Java classes
accessible to an SPJ, 32
compilation of, 33
Java compilation, 33
Java data types, 26
Java Development Kit (JDK), required version, 23
Java exceptions, handling, 32
Java method (see SPJ method)
Java signature, restrictions, 25
Java variables, static, 29
java.sql.Types, 69
JDBC client application, invoking SPJs, 69
JDBC data types, 69
JDBC Type 4 driver (see Neoview JDBC Type 4 driver)
JDBC-based Java method, example of, 30
JDK, required version, 23
JOB table, 107
L
LOWERPRICE procedure
creating, 76
invoking, 77
lowerPrice() method
code for, 76
description of, 76
M
main() method, 28
MONTHLYORDERS procedure
creating, 80
invoking, 81
Multithreading, 64
N
Named parameter, 66
Neoview DB Admin (see DB Admin)
Neoview JDBC Type 4 driver, required version, 24
Neoview platform
deploying SPJ code onto, 35
required version, 23
Neoview Script
calling SPJs, 66
displaying SPJs in a schema, 49
required version, 23
Nesting SPJs, 29
Null values, input and output, 29
numDailyOrders() method
code for, 78
description of, 78
numMonthlyOrders() method
code for, 80
description of, 80
O
OBEY command files (see Script files)
ODBC client application, invoking SPJs, 68
ODETAIL table, 116
ORDERS table, 115
ORDERSUMMARY procedure
creating, 89
invoking, 89
orderSummary() method
code for, 88
description of, 88
OUT parameters, 65
Output parameter array, 26
Output parameter, SPJ method, 26
P
Parameter array, 26
PARTDATA procedure
creating, 85
invoking, 86
partData() method
code for, 84
description of, 84
PARTLOC table, 122
partLocations() method
code for, 104
description of, 104
PARTLOCS procedure
creating, 104
invoking, 105
PARTS table, 118
PARTSUPP table, 120
Payroll class, 90
Performance tip, 73
PERSNL schema
ADJUSTSALARY procedure, 91
DEPT table, 109
description of, 107
EMPLOYEE table, 107
EMPLOYEEJOB procedure, 93
JOB table, 107
PROJECT table, 111
PROJECTTEAM procedure, 95
TOPSALESREPS procedure, 96
Privileges
for creating SPJs, 43
for invoking SPJs, 51
granting, 51
on referenced database objects, 52
126 Index