ISO/IEC INTERNATIONAL STANDARD 9075-13 Fifth edition 2023-06 Information technology Database languages SQL - Part 13: SQL Routines and types using the Java TM programming language (SQL/ JRT) Technologies de I'information - Langages de base de données SQL Partie 13: Routines et types de SQL utilisant le langage de programmation Java TM (SQL/JRT) Reference number IEC IS0/IEC 9075-13:2023(E) ISO @ IS0/IEC 2023 IS0/IEC 9075-13:2023(E) COPYRIGHT PROTECTED DOCUMENT @IS0/IEC2023 All rights reserved. Unless otherwise specified, or required in the context of its implementation, no part of this publication may be reproduced or utilized otherwise in any form or by any means, electronic or mechanical, including photocopying, or posting on or ISo's member body in the country of the requester. ISO copyright office CP 401 · Ch. de Blandonnet 8 CH-1214 Vernier, Geneva Phone: +41 22 749 01 11 Email: [email protected] Website: www.iso.org Published in Switzerland i @ IS0/IEC 2023 - All rights reserved IS0/IEC 9075-13:20@(E) Contents Page Foreword. .vii Introduction. ix 1 Scope. 2 Normative references.. 2 3 Terms and definitions. 4 Concepts. 6 4.1 Notations and conventions. . 4.1.1 Notations. 4.1.2 Specification of built-in procedures. 4.1.3 Specification of deployment descriptor files. 4.2 Java programming language. . 4.3 SQL-invoked routines. 4.3.1 Characteristics of SQL-invoked routines. 4.4 Javaclassnameresolution. 4.5 SQLresultsets 4.6 Parameter mapping. 10 4.7 Unhandled Java exceptions. 4.8 Data types. 4.8.1 Host language data types. 4.9 User-defined types. 12 4.9.1 Introduction to user-defined types. 12 4.9.2 User-defined type comparison and assignment. 13 4.9.3 User-defined type descriptor. 13 4.9.4 Accessing static fields. . 14 4.9.5 ConvertingobjectsbetweenSoLandIava 15 4.9.5.1 Introduction to conversion of objects between SQL and Java. 15 4.9.5.2 SERIALIZABLE. 15 4.9.5.3 SQLDATA. 15 4.9.5.4 Developing for portability. . 4.10 Built-in procedures. 4.11 Basic security model. . 4.11.1 Privileges. 4.12 JARs.. 4.12.1 Introduction to JARs. 4.12.2 Deployment descriptor files. .17 5 Lexical elements. .19 5.1 <token> and <separator> 19 5.2 Names and identifiers. .20 @ IS0/IEC 2023 - All rights reserved iii IS0/IEC 9075-13:2023(E) 6 Scalar expressions.. . 6.1 <method invocation>. 6.2 <new specification>. 7 Predicates.. ...24 7.1 <comparison predicate> 24 8 Additional common rules. . .26 8.1 Invoking an SQL-invoked routine. . 8.2 Execution of array-returning functions. . . .35 9 Additional common elements.... . 9.1 <language clause>. . .. . 9.2 <Java parameter declaration list>. . 9.3 <SQL Java path>.... 9.4 <routine invocation>. 9.5 Java routine signature determination. 10 Schema definition and manipulation. .. ...55 10.1 <drop schema statement>. .55 10.2 <table definition>. . .56 10.3 <view definition>.. 10.4 <user-defined type definition>. .. . 10.5 <attribute definition>. ..62 10.6 <alter type statement>. . 10.7 <drop data type statement>. .66 10.8 <SQL-invoked routine>. .67 10.9 <alter routine statement>. . 10.10 <drop routine statement>.. 10.11 <user-defined ordering definition>. 10.12 <drop user-defined ordering statement>. 11 Access control... 11.1 <grant privilege statement> 11.2 <privileges>. .75 11.3 <revoke statement> .76 12 Built-in procedures. 12.1 SQLJ.INSTALL_JAR procedure. 77 12.2 SQLJ.REPLACE_JAR procedure. 79 12.3 SQLJ.REMOVE_JAR procedure. .81 12.4 SQLJ.ALTER_JAVA_PATH procedure. .83 13 Java topics........ ...85 13.1 Java facilities supported by this document. . 13.1.1 Package java.sql. . . . 13.1.2 System properties. . 13.2 Deployment descriptor files. ..86 14 Information Schema. . 14.1 Information Schema digital artifact. ..89 14.2 JAR_JAR_USAGE view.. ..89 14.3 JARS view.... .90 iv @ IS0/IEC 2023 - All rights reserved IS0/IEC 9075-13:2023(E) 14.4 METHOD_SPECIFICATIONS view. .91 14.5 ROUTINE_JAR_USAGE view. .92 14.6 TYPE_JAR_USAGE view. 14.7 USER_DEFINED_TYPES view.. 14.8 Short name views. . 15 Definition Schema..