ISO/IEC 9075-13:2016/Cor 2:2022

Information technology - Database languages - SQL - Part 13: SQL Routines and types using the Java TM programming language (SQL/JRT) - Technical Corrigendum 2

Technologies de l'information — Langages de base de données — SQL — Partie 13: Routines et types de SQL utilisant le langage de programmation Java TM (SQL/JRT) — Rectificatif technique 2

General Information

• Status: Published
• Publication Date: 23-Jun-2022
• ICS: 35.060 - Languages used in information technology
• Technical Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Drafting Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Current Stage: 9599 - Withdrawal of International Standard
• Start Date: 01-Jun-2023
• Completion Date: 30-Oct-2025

Relations

• Revised: ISO/IEC 9075-13:2023 - Information technology - Database languages SQL - Part 13: SQL Routines and types using the Java TM programming language (SQL/JRT)
• Effective Date: 06-Jun-2022

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.

Standards Content (Sample)

INTERNATIONAL STANDARD ISO/IEC 9075-13:2016
TECHNICAL CORRIGENDUM 2
Published 2022-06
INTERNATIONAL ORGANIZATION FOR STANDARDIZATION • МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ПО СТАНДАРТИЗАЦИИ • ORGANISATION INTERNATIONALE DE NORMALISATION
INTERNATIONAL ELECTROTECHNICAL COMMISSION • МЕЖДУНАРОДНАЯ ЭЛЕКТРОТЕХНИЧЕСКАЯ КОМИССИЯ • COMMISSION ÉLECTROTECHNIQUE INTERNATIONALE
Information technology — Database languages — SQL — Part 13:
TM
SQL Routines and Types using the JAVA programming language
(SQL/JRT)
TECHNICAL CORRIGENDUM 2
Technologies de l'information — Langages de base de données — SQL — Partie 13: Routines et
TM
types de SQL utilisant le langage de programmation Java (SQL/JRT)
RECTIFICATIF TECHNIQUE 2
Technical Corrigendum 2 to ISO/IEC 9075-13:2016 was prepared by Joint Technical Committee
ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange.
ICS 35.060 Ref. No. ISO/IEC 9075-13:2016/Cor.2:2022(E)
©  ISO/IEC 2022 – All rights reserved
...