ISO/IEC 19075-3:2021 PDF

Name: ISO/IEC 19075-3:2021 — Information technology — Guidance for the use of database language SQL — Part 3: SQL embedded in programs using the JavaTM programming language
SKU: ISO/IEC 19075-3:2021
Price: 25 EUR
Availability: InStock

Information technology — Guidance for the use of database language SQL — Part 3: SQL embedded in programs using the JavaTM programming language

Название (английский):

ISO/IEC 19075-3:2021

Information technology — Guidance for the use of database language SQL — Part 3: SQL embedded in programs using the JavaTM programming language

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

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

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

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

ruen

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

Цена:315 €

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

This document describes the support for the use of SQL within programs written in Java. This document discusses the following features of the SQL language: — The embedding of SQL expressions and statements in programs written in the Java programming language.

Abstract

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

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

Overview

ISO/IEC 19075-3:2021 provides guidance for embedding the SQL database language inside programs written in the Java programming language. The standard explains how to integrate SQL expressions and statements into Java source, describes design goals (such as binary portability and compile-time checking), and documents runtime profile customization and utilities that enable database-specific behavior. This is commonly referred to when implementing or using SQL embedded in Java (SQL/OLB / SQLJ) solutions and when deciding between embedded SQL and lower-level APIs like JDBC.

Key topics and technical requirements

Embedding SQL in Java: Rules and recommendations for placing SQL expressions and statements directly in Java code, including host expressions and host variables.

Design goals: Support for compile-time SQL syntactic/semantic checking, location-independent SQL semantics, binary portability, and shared SQL connection usage between SQL/OLB and JDBC environments.

Advantages over JDBC: Smaller, higher-level source programs; potential for translator compile-time type checking; direct embedding of Java host expressions; stronger typing and simplified SQL-invoked routine invocation.

Profile customization: Mechanisms to add implementation-specific SQL execution control via serializable profile customizers and runtime interfaces (for example, SQLJ.runtime.profile.RTStatement, RTResultSet, ConnectedProfile).

Profile customization process: Steps for discovering, deserializing, customizing, and reserializing profiles (JAR-based profiles), enabling SQL implementations to register hooks for particular DBMS behavior.

Runtime and utilities: Recommendations for tools (CLI, GUI/IDE integrations, installers) to automate profile customization and precompile/optimize embedded SQL.

Examples and features: Iterators, binding strategies (positional and named), connection contexts, batching, result mapping, user-defined types, and techniques to obtain java.sql.ResultSet objects from SQL/OLB iterators.

Applications and users

Java application developers who want to embed SQL directly in their code for stronger typing and simpler source.

Database vendors and middleware vendors implementing SQL/OLB translators or runtime customizations.

Tool and IDE developers building precompilers, profile customization utilities, and migration tools.

System integrators targeting binary-portable Java database applications across multiple SQL implementations.

Practical benefits:

Cleaner Java source with less boilerplate than JDBC.

Compile-time SQL checks and safer runtime behavior.

Easier portability and DB-specific optimization through profile customization.

Related standards

ISO/IEC 9075 series (SQL/Framework and Object Language Bindings): parts 1, 2, 3, 4, 9–16 as listed in the standard

Java Language Specification (Java SE editions)

JDBC Specification (e.g., JDBC 4.3)

Keywords: SQL embedded in Java, SQL/OLB, SQLJ, embedded SQL, JDBC alternative, profile customization, binary portability, Java database integration.

ISO/IEC 19075-3:2021 PDF

Abstract

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

Overview

Key topics and technical requirements

Applications and users

Related standards

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

BS ISO/IEC 19075-3:2021

Information technology. Guidance for the use of database language SQL. SQL embedded in programs using the Jav…

BS ISO/IEC 9075-9:2023

Information technology. Database languages SQL - Management of External Data (SQL/ MED)

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