Overview
ISO/IEC 9075-13:2016/Cor 2:2022 is Technical Corrigendum 2 to Part 13 of the SQL standard - commonly known as SQL/JRT (SQL Routines and Types using the Java programming language). Published in June 2022 by ISO/IEC JTC 1/SC 32, this corrigendum issues targeted corrections and clarifications to the 2016 edition of the standard that governs how Java routines and Java-based SQL types are defined and invoked from SQL environments.
Key topics and technical changes
The corrigendum focuses on precise language and syntax corrections that affect implementation and conformance:
-
Java routine signature determination
- Corrects errors in the syntactic structure used to determine Java routine signatures.
- Clarifies how SQL-invoked routines that contain schema procedures are handled when constructing signature rules and invoking Java methods.
-
Parameter declaration and call linkage
- Updates terminology and rules about augmenting SQL parameter declaration lists (SPDLa and RPDL).
- Specifies how augmented parameter lists should incorporate result data item parameters as well as savearea and calltype data items for proper Java-SQL linkage.
-
Access control / privileges
- Replaces permissive wording (use of “may”) with a clear rule: when an ON clause specifies a , the access-control (AC) clause must explicitly specify USAGE privilege.
- This reduces ambiguity for implementers and administrators about required privileges for Java routine artifacts loaded from JARs.
-
Standards governance
- Prepared and ratified by the ISO/IEC Joint Technical Committee JTC 1, Subcommittee SC 32 (Data management and interchange).
Practical applications and users
This corrigendum is primarily targeted at:
- Database vendors and implementers building SQL engines or enhancing support for Java routines (SQL/JRT).
- API and driver developers who map SQL routine calls to Java methods and must follow precise signature and parameter conventions.
- Database architects, DBAs, and security teams responsible for deploying and controlling access to Java-based routines and packages (JARs) in database environments.
- Standards compliance auditors and technical writers who maintain conformity matrices and documentation for SQL implementations.
Adopting the corrigendum ensures consistent Java-to-SQL routine integration, correct parameter handling, and unambiguous privilege requirements (especially when using JAR artifacts).
Related standards
- ISO/IEC 9075 (SQL family) - see other Parts for SQL/Foundation, SQL/CLI, etc.
- ISO/IEC JTC 1/SC 32 publications on data management and interchange
Keywords: ISO/IEC 9075-13, SQL/JRT, Java routines, SQL routines, technical corrigendum, database standards, SQL and Java, access control, USAGE privilege.
Open preview (PDF)Information technology — Database languages — SQL — Part 13: SQL Routines and types using the Java TM programming language (SQL/JRT) — Technical Corrigendum 2