Foreword
Introduction
1 Scope
2 Normative references
3 Introduction
3.1 SQLJ
3.2 Technical components
3.3 Conformance
4 Tutorial
4.1 Overview
4.2 Example Java methods: region and correctStates
4.3 Installing region and correctStates in SQL
4.4 Defining SQL names for region and correctStates
4.5 A Java method with output parameters: bestTwoEmps
4.6 A CREATE PROCEDURE best2 for bestTwoEmps
4.7 Calling the best2 procedure
4.8 A Java method returning a result set: orderedEmps
4.9 A CREATE PROCEDURE rankedEmps for orderedEmps
4.10 Calling the rankedEmps procedure
4.11 Overloading Java method names and SQL names
4.12 Java main methods
4.13 Java method signatures in the CREATE statements
4.14 Null argument values and the RETURNS NULL clause
4.15 Static variables
4.16 Dropping SQL names of Java methods
4.17 Removing Java classes from SQL
4.18 Replacing Java classes in SQL
4.19 Visibility
4.20 Exceptions
4.21 Deployment descriptors
4.22 Paths
4.23 SQL Privileges
5 Common elements
5.1 Jar names
5.2 SQL-Java paths
6 SQLJ Procedures
6.1 SQLJ.INSTALL_JAR procedure
6.2 SQLJ.REPLACE_JAR procedure
6.3 SQLJ.REMOVE_JAR procedure
6.4 SQLJ.ALTER_JAVA_PATH procedure
7 SQL Extensions
7.1 CREATE PROCEDURE/FUNCTION statement
7.2 DROP PROCEDURE/FUNCTION statement
7.3 GRANT statement
7.4 REVOKE statement
7.5 SQLJ function call
7.6 SQLJ procedure call
8 JAVA Topics
8.1 Java facilities supported by SQLJ
8.2 Deployment descriptor files
9 Status Codes
9.1 Class and subclass values for uncaught Java exceptions
9.2 SQLSTATE
Table
1 SQLSTATE class and subclass values