BSI 22/30453904 DC 2022
$45.21
BS EN ISO IEC 9075-10. Information technology. Database language SQL – Part 10. Object language bindings (SQL/OLB)
Published By | Publication Date | Number of Pages |
BSI | 2022 | 340 |
PDF Catalog
PDF Pages | PDF Title |
---|---|
5 | Contents |
19 | Tables |
20 | Foreword |
22 | Introduction |
25 | 1 Scope |
26 | 2 Normative references |
27 | 3 Terms and definitions |
30 | 4 Concepts 4.1 Notations and conventions 4.1.1 Notations 4.1.2 First term usage 4.1.3 Java-related conventions |
31 | 4.1.4 Specification of translator-generated classes |
32 | 4.2 Character strings 4.2.1 Unicode support 4.3 Embedded syntax 4.4 Introduction to SQLJ 4.4.1 Overview |
33 | 4.4.2 SQL constructs 4.4.3 SQLJ clauses 4.4.4 Binary portability 4.4.4.1 Binary portability requirements |
35 | 4.4.4.2 Components of binary portable applications 4.4.5 Profile overview 4.4.5.1 Introduction to profiles |
36 | 4.4.5.2 EntryInfo overview |
38 | 4.4.5.3 TypeInfo overview |
39 | 4.4.5.4 SQLJ datatype properties |
41 | 4.4.6 Host variables |
42 | 4.4.7 Host expressions 4.4.8 Connection contexts 4.4.9 Default connection context |
43 | 4.4.10 Schema checking using exemplar schemas 4.4.11 Using multiple SQLJ contexts and connections |
44 | 4.4.12 Dynamic SQL and JDBC/SQLJ Connection interoperability 4.4.12.1 Introduction to connection interoperability 4.4.12.2 Creating an SQLJ ConnectionContext from a java.sql.Connection object 4.4.12.3 Obtaining a java.sql.Connection object from an SQLJ ConnectionContext 4.4.12.4 Connection sharing 4.4.12.5 Connection resource management |
45 | 4.4.13 SQL execution control and status 4.4.14 Iterators |
46 | 4.4.15 Input and output assignability |
60 | 4.4.16 Multiple java.sql.ResultSet objects from SQL-invoked procedure calls 4.4.16.1 Introduction to multiple result sets 4.4.16.2 Resource management with multiple results 4.4.17 JDBC/SQLJ ResultSet interoperability 4.4.17.1 Introduction to interoperability 4.4.17.2 Creating an SQLJ iterator from a java.sql.ResultSet object |
61 | 4.4.17.3 Obtaining a java.sql.ResultSet object from an SQLJ iterator object 4.4.17.4 Obtaining a java.sql.ResultSet object from an untyped iterator object 4.4.17.5 Iterator and java.sql.ResultSet object resource management |
62 | 4.4.18 Multi-threading considerations 4.4.19 User-defined data types |
63 | 4.4.20 Batch updates 4.4.20.1 Introduction to batch updates 4.4.20.2 Batchable statements and batch compatibility 4.4.20.3 Statement batching API |
64 | 4.4.20.4 Execution status and update counts 4.4.20.5 Program semantics and exceptions |
65 | 4.4.20.6 Batch cancellation and disabling 4.4.20.7 Specification of a batching limit |
66 | 4.4.21 SQLJ language elements 4.4.21.1 Introduction to SQLJ language elements 4.4.21.2 4.4.21.3 SQL-schema, SQL-data, and SQL-transaction statements |
67 | 4.4.21.4 4.4.21.5 4.4.21.6 4.4.21.7 4.4.21.8 |
68 | 4.4.21.9 Cursor declaration 4.4.21.10 Input parameters to SQL-statements 4.4.21.11 Extracting column values from SQLJ iterators 4.4.21.12 and cursors |
69 | 4.4.22 SQLJ, JDBC, and SQLExceptions and SQLWarnings 4.4.23 Profile generation and naming |
70 | 4.4.24 SQLJ application packaging 4.4.25 Profile customizer interface |
71 | 4.4.26 Customization interface 4.4.26.1 Introduction to customization interfaces 4.4.26.2 Customization usage |
72 | 4.4.26.3 Customization registration |
74 | 5 Lexical elements 5.1 |
75 | 5.2 and |
76 | 6 Scalar expressions 6.1 and |
77 | 7 Additional common rules 7.1 Invoking an SQL-invoked routine |
78 | 8 Data manipulation 8.1 |
81 | 8.2 |
85 | 8.3 |
87 | 8.4 |
89 | 9 Control statements 9.1 |
91 | 9.2 |
93 | 9.3 |
95 | 10 Transaction management 10.1 |
96 | 10.2 |
97 | 10.3 |
98 | 10.4 |
99 | 10.5 |
100 | 11 Embedded SQL 11.1 |
102 | 11.2 |
103 | 12 SQLJ reserved names 12.1 Introduction to reserved names 12.2 Naming runtime library components 12.3 Temporary variable names 12.4 Class and resource file names 12.4.1 Introduction 12.4.2 Generated classes |
104 | 12.4.3 Resource files and profiles |
105 | 13 Common subelements 13.1 |
106 | 13.2 |
107 | 13.3 |
108 | 13.4 |
109 | 13.5 |
110 | 13.6 |
113 | 13.7 |
114 | 13.8 |
117 | 14 and contents 14.1 |
118 | 14.2 |
119 | 14.3 Generated connection class |
124 | 14.4 |
126 | 14.5 |
127 | 14.6 Generated positioned iterator class |
129 | 14.7 |
130 | 14.8 Generated named iterator class |
132 | 14.9 |
138 | 14.10 |
139 | 14.11 |
140 | 14.12 |
142 | 14.13 |
146 | 14.14 |
148 | 14.15 |
151 | 15 Package sqlj.runtime 15.1 Overview 15.2 SQLJ runtime interfaces 15.2.1 sqlj.runtime.ConnectionContext 15.2.1.1 Interface Overview |
152 | 15.2.1.2 Variables 15.2.1.3 Methods |
155 | 15.2.2 sqlj.runtime.ForUpdate 15.2.2.1 Interface Overview 15.2.2.2 Methods 15.2.3 sqlj.runtime.NamedIterator |
156 | 15.2.4 sqlj.runtime.PositionedIterator 15.2.4.1 Interface Overview 15.2.4.2 Methods |
157 | 15.2.5 sqlj.runtime.ResultSetIterator 15.2.5.1 Interface Overview 15.2.5.2 Variables |
158 | 15.2.5.3 Methods |
162 | 15.2.6 sqlj.runtime.Scrollable 15.2.6.1 Interface Overview 15.2.6.2 Variables 15.2.6.3 Methods |
167 | 15.3 SQLJ Runtime Classes 15.3.1 sqlj.runtime.AsciiStream 15.3.1.1 Class Overview 15.3.1.2 Constructors |
168 | 15.3.2 sqlj.runtime.BinaryStream 15.3.2.1 Class Overview 15.3.2.2 Constructors |
169 | 15.3.3 sqlj.runtime.DefaultRuntime 15.3.3.1 Class Overview 15.3.3.2 Constructors 15.3.3.3 Methods |
170 | 15.3.4 sqlj.runtime.ExecutionContext 15.3.4.1 Class Overview |
171 | 15.3.4.2 Variables |
172 | 15.3.4.3 Constructors 15.3.4.4 Methods |
185 | 15.3.5 sqlj.runtime.RuntimeContext 15.3.5.1 Class Overview 15.3.5.2 Variables |
186 | 15.3.5.3 Constructors 15.3.5.4 Methods |
187 | 15.3.6 sqlj.runtime.StreamWrapper 15.3.6.1 Class Overview |
188 | 15.3.6.2 Constructors 15.3.6.3 Methods |
189 | 15.3.7 sqlj.runtime.UnicodeStream 15.3.7.1 Class Overview 15.3.7.2 Constructors |
190 | 15.3.8 sqlj.runtime.CharacterStream 15.3.8.1 Class Overview 15.3.8.2 Constructors |
191 | 15.3.8.3 Methods 15.3.9 sqlj.runtime.SQLNullException 15.3.9.1 Class Overview |
192 | 15.3.9.2 Constructors |
193 | 16 Package sqlj.runtime.profile 16.1 Overview 16.2 SQLJ sqlj.runtime.profile Interfaces 16.2.1 sqlj.runtime.profile.BatchContext 16.2.1.1 Interface Overview 16.2.1.2 Methods |
194 | 16.2.2 sqlj.runtime.profile.ConnectedProfile 16.2.2.1 Interface Overview |
195 | 16.2.2.2 Methods |
197 | 16.2.3 sqlj.runtime.profile.Customization 16.2.3.1 Interface Overview |
198 | 16.2.3.2 Methods |
199 | 16.2.4 sqlj.runtime.profile.Loader 16.2.4.1 Interface Overview 16.2.4.2 Methods |
200 | 16.2.5 sqlj.runtime.profile.RTResultSet 16.2.5.1 Interface Overview |
203 | 16.2.5.2 Methods |
228 | 16.2.6 sqlj.runtime.profile.RTStatement 16.2.6.1 Interface Overview |
233 | 16.2.6.2 Methods |
280 | 16.2.7 sqlj.runtime.profile.SerializedProfile 16.2.7.1 Interface Overview 16.2.7.2 Methods |
281 | 16.3 SQLJ sqlj.runtime.profile Classes 16.3.1 sqlj.runtime.profile.DefaultLoader 16.3.1.1 Class Overview 16.3.1.2 Constructors 16.3.1.3 Methods |
282 | 16.3.2 sqlj.runtime.profile.EntryInfo 16.3.2.1 Class Overview 16.3.2.2 Variables |
288 | 16.3.2.3 Constructors 16.3.2.4 Methods |
298 | 16.3.3 sqlj.runtime.profile.Profile 16.3.3.1 Class Overview 16.3.3.2 Constructors |
299 | 16.3.3.3 Methods |
305 | 16.3.4 sqlj.runtime.profile.ProfileData 16.3.4.1 Class Overview 16.3.4.2 Constructors |
306 | 16.3.4.3 Methods |
307 | 16.3.5 sqlj.runtime.profile.SetTransactionDescriptor 16.3.5.1 Class Overview 16.3.5.2 Variables |
308 | 16.3.5.3 Constructors 16.3.5.4 Methods |
309 | 16.3.6 sqlj.runtime.profile.TypeInfo 16.3.6.1 Class Overview 16.3.6.2 Variables |
310 | 16.3.6.3 Constructors 16.3.6.4 Methods |
315 | 17 sqlj.runtime.profile.util.ProfileCustomizer 17.1 Interface Overview |
317 | 17.2 Methods 17.2.1 acceptsConnection (Connection) 17.2.2 customize (Profile, Connection, ErrorLog) |
319 | 18 Status codes 18.1 SQLSTATE |
320 | 19 Conformance 19.1 Claims of conformance to SQL/OLB 19.2 Additional conformance requirements for SQL/OLB 19.3 Implied feature relationships of SQL/OLB |
321 | A SQL Conformance Summary |
324 | B Implementation-defined elements |
327 | C Implementation-dependent elements |
331 | D SQL optional feature taxonomy |
333 | E Deprecated features |
334 | F Incompatibilities with ISO/IEC 9075:2016 |
335 | G Defect reports not addressed in this edition of this document |
336 | Bibliography |
337 | Index |