ISO/IEC 19075-4:2021 PDF

Name: ISO/IEC 19075-4:2021 — Information technology — Guidance for the use of database language SQL — Part 4: Routines and types using the Java™ programming language
SKU: ISO/IEC 19075-4:2021
Price: 25 EUR
Availability: InStock

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

Information technology — Guidance for the use of database language SQL — Part 4: Routines and types using the Java™ programming language

Статус документа:: Действующий
Формат:: Электронный (PDF)
Количество страниц:: 50
Дата публикации:: 1 сентября 2021 г.
Издание:: ISO/IEC IS 19075 edition 1 version 1
ICS:: 35.060

Тип поставки:

Full version750 €Read online 24h10 €Read online 72h15 €

Язык документа:

ruen

Срок поставки:9 раб. дн. (перевод)

Цена:750 €

Описание (английский):

This document provides a tutorial of SQL routines and types using the Java™ programming language. This document discusses the following features of the SQL Language: — The use of routines written in the Java programming language within SQL expressions and statements. — The use of user-defined types written in the Java programming language within SQL expressions and statements.

Abstract

Похожие стандарты

Упомянутые в описании и другие стандарты ISO

Overview

ISO/IEC 19075-4:2021 is part of the ISO/IEC 19075 series that provides a tutorial-style, standards-based guide for using SQL routines and user-defined types implemented in the Java™ programming language. It explains how Java methods and classes can be installed, referenced and invoked from SQL environments (the SQL/JRT facility), and shows practical examples for integrating Java logic with SQL statements and expressions.

Key topics and technical requirements

Scope: Tutorial guidance for using Java-written routines (functions/procedures) and user-defined types in SQL expressions and statements.

SQL/JRT components:

Built-in schema SQLJ and built-in procedures such as SQLJ.INSTALL_JAR, SQLJ.REPLACE_JAR, SQLJ.REMOVE_JAR, and SQLJ.ALTER_JAVA_PATH for loading and managing Java JARs in the SQL catalog.
Extensions to SQL DDL/DML: CREATE PROCEDURE/FUNCTION, DROP PROCEDURE/FUNCTION, CREATE TYPE, DROP TYPE, and extended GRANT/REVOKE semantics for Java JAR usage.
Conventions for returning OUT/INOUT parameters and SQL result sets created by Java routines.
Qualified referencing of Java class fields and methods from SQL and additional Information Schema views/columns to expose metadata.

Installation & deployment: Guidance on packaging Java class files into JARs, installing them into the SQL system with SQLJ.INSTALL_JAR (including a JAR name used within SQL), and handling deployment descriptors and path resolution.

Examples and behavior: Sample Java classes and methods (e.g., Routines1.region, Routines1.correctStates) illustrate mapping between Java methods and SQL functions/procedures, JDBC usage, null argument handling, overloading, static variables, and visibility/privilege considerations.

Applications and who should use this standard

Database implementers and DBMS vendors adding or supporting the SQL/JRT facility (Java-based routines and types).

Application developers and architects who need to implement stored procedures, UDFs or custom data types in Java and expose them to SQL clients.

DBAs responsible for deploying Java routines and managing JARs, privileges, and Information Schema metadata.

Teams integrating Java business logic with SQL queries for advanced processing, result-set generation, or custom type mapping.

Practical use cases include Java-based stored procedures that perform complex computation or JDBC access, Java-backed SQL user-defined types for rich data models, and migration patterns where Java logic replaces or complements server-side SQL logic.

ISO/IEC 19075-4:2021 PDF

Abstract

Похожие стандарты

Overview

Key topics and technical requirements

Applications and who should use this standard

Related standards

Технические детали

BS ISO/IEC 19075-2:2021

Information technology. Guidance for the use of database language SQL. Time-related information.

ISO/IEC 9075-15:2023/Cor 1:2026

Information technology — Database languages SQL — Part 15: Multidimensional arrays (SQL/MDA) — Technical Corr…

ISO 8689-1:2000

Water quality — Biological classification of rivers — Part 1: Guidance on the interpretation of biological qu…

ISO/ASTM51540-04(2012)

Standard Practice for Use of a Radiochromic Liquid Dosimetry System (Withdrawn 2020)

ISO/ASTM51204-04

Standard Practice for Dosimetry in Gamma Irradiation Facilities for Food Processing (Withdrawn 2013)

ISO/ASTM51431-05

Standard Practice for Dosimetry in Electron Beam and X-Ray (Bremsstrahlung) Irradiation Facilities for Food P…

ISO/ASTM52628-20e1

Standard Practice for Dosimetry in Radiation Processing

ISO/ASTM52921-13(2019)

Standard Terminology for Additive Manufacturing—Coordinate Systems and Test Methodologies