ISO IEC 19075-4-2021 PDF

Full title and description

Information technology — Guidance for the use of database language SQL — Part 4: Routines and types using the Java™ programming language (ISO/IEC 19075-4:2021). This part of ISO/IEC 19075 provides tutorial-style guidance and examples for using Java language routines and user-defined types from within SQL, illustrating the SQL/Java integration model and common implementation and usage considerations.

Abstract

ISO/IEC 19075-4:2021 is a guidance document that explains how routines (methods) and structured types written in the Java programming language can be invoked and used from SQL statements and expressions. It describes the concepts, mappings, recommended practices and example usages for SQL/Java integration (SQL/JRT), including type mapping, invocation semantics, exception handling, and security/packaging considerations. The document is intended as a practical tutorial rather than a normative language specification.

General information

• Status: Published international standard (Part of the ISO/IEC 19075 guidance series).
• Publication date: 1 September 2021.
• Publisher: ISO and IEC (issued under ISO/IEC JTC 1/SC 32 Data management and interchange).
• ICS / categories: 35.060 — Languages used in information technology.
• Edition / version: Edition 1.0 (2021).
• Number of pages: 50 pages (official publication length).

Scope

The document provides a tutorial and explanatory guidance on using Java-written routines and user-defined types from SQL. It covers how SQL can invoke Java static methods as routines, how Java classes can be used as structured SQL types, the mapping between SQL and Java data types, expected runtime behavior, error and exception handling, and practical topics such as deployment/packaging, classpath and security considerations. The scope is explanatory guidance to support implementers and users of SQL/JRT features; it does not itself define normative language syntax beyond referring to the SQL and SQL/JRT specifications.

Key topics and requirements

• Overview of SQL/JRT concepts: invoking Java routines from SQL and using Java classes as SQL structured types.
• Type mapping and conversion rules between SQL types and Java types (primitive and object mappings).
• Invocation semantics: static method calls, parameter passing, return value handling and nullability considerations.
• Exception and error handling: mapping Java exceptions to SQL conditions and recommended handling patterns.
• Security and sandboxing guidance: access control, permission models, and safe deployment practices for Java routines.
• Packaging and deployment considerations: class loading, classpath management, and versioning of Java code used by the SQL engine.
• Examples and tutorial material: sample Java routines, user-defined types, and example SQL statements demonstrating usage patterns.
• Interoperability and implementation notes: guidance for DBMS vendors and application developers to ensure predictable behaviour across implementations.

Typical use and users

The standard is primarily used by database implementers (DBMS engine developers), middleware and connector developers, and architects designing systems that combine SQL and Java. It is also useful for application developers who need to embed or call Java-based logic from SQL, and for test and QA engineers validating SQL/Java integration. Typical scenarios include stored routines implemented in Java, user-defined structured types backed by Java classes, and environments where Java-based business logic must be executed close to data.

Related standards

ISO/IEC 19075-4:2021 is part of the ISO/IEC 19075 guidance series for SQL. Closely related and relevant documents include: the ISO/IEC 9075 (SQL) family—especially Part 13 (SQL Routines and Types Using the Java programming language, SQL/JRT), ISO/IEC 9075-2 (SQL/Foundation) and other parts of ISO/IEC 19075 (Parts 1–3 and later parts). ISO/IEC TR 19075-4:2015 was the earlier technical report on this topic and has been replaced by the 2021 International Standard edition.

Keywords

SQL, SQL/JRT, Java, routines, user-defined types, UDT, type mapping, database language, stored procedures, stored functions, packaging, security, ISO/IEC 19075.

FAQ

Q: What is this standard?

A: ISO/IEC 19075-4:2021 is a guidance standard titled "Information technology — Guidance for the use of database language SQL — Part 4: Routines and types using the Java™ programming language." It provides tutorial-style guidance on using Java routines and types from SQL.

Q: What does it cover?

A: It covers the concepts, examples and practical considerations for invoking Java methods from SQL and using Java classes as SQL structured types, including type mappings, invocation semantics, exception handling, security and deployment advice. It is explanatory and intended to supplement the normative SQL/SQL-JRT specifications.

Q: Who typically uses it?

A: DBMS implementers, integration/middleware developers, Java and SQL application developers, system architects, and QA/test teams working on SQL–Java integration.

Q: Is it current or superseded?

A: ISO/IEC 19075-4:2021 was published on 1 September 2021 and replaced the earlier technical report ISO/IEC TR 19075-4:2015. As of 2 March 2026, the 2021 publication is the published International Standard for this part; users should check the ISO catalogue or their national standards body for any amendments or newer revisions if they require absolute up-to-date confirmation.

Q: Is it part of a series?

A: Yes. It is Part 4 of the ISO/IEC 19075 series ("Guidance for the use of database language SQL") and is intended to be used in conjunction with other parts of ISO/IEC 19075 and the ISO/IEC 9075 (SQL) family, notably the SQL/JRT specification (SQL routines and types using Java).

Q: What are the key keywords?

A: SQL, Java, SQL/JRT, routines, user-defined types, type mapping, stored routines, security, deployment, ISO/IEC 19075.