《ISO-9075-10-2003.pdf》由会员分享，可在线阅读，更多相关《ISO-9075-10-2003.pdf（409页珍藏版）》请在三一文库上搜索。
1、 ICS 35.060 Ref. No. ISO/IEC 9075-10:2003/Cor.1:2005(E) ISO/IEC 2005 All rights reserved Published in Switzerland INTERNATIONAL STANDARD ISO/IEC 9075-10:2003 TECHNICAL CORRIGENDUM 1 Published 2005-11-15 INTERNATIONAL ORGANIZATION FOR STANDARDIZATION ORGANISATION INTERNATIONALE DE NORMALISATION INTER
2、NATIONAL ELECTROTECHNICAL COMMISSION COMMISSION LECTROTECHNIQUE INTERNATIONALE Information technology Database languages SQL Part 10: Object Language Bindings (SQL/OLB) TECHNICAL CORRIGENDUM 1 Technologies de linformation Langages de base de donnes SQL Partie 10: Liaisons de langage objet (SQL/OLB)
3、RECTIFICATIF TECHNIQUE 1 Technical Corrigendum 1 to ISO/IEC 9075-10:2003 was prepared by Joint Technical Committee ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange. Statement of purpose for rationale A statement indicating the rationale for each change to IS
4、O/IEC 9075-10:2003 is included. This is to inform the users of ISO/IEC 9075-10:2003 why it was judged necessary to change the original wording. In many cases, the reason is editorial or to clarify the wording; in some cases, it is to correct an error or an omission in the original wording. Notes on
5、numbering Where this Technical Corrigendum introduces new Syntax, Access, General, and Conformance Rules, the new rules have been numbered as follows: Rules inserted between, for example, Rules 7) and 8) are numbered 7.1), 7.2), etc. or 7)a.1), 7)a.2), etc. Those inserted before Rule 1) are numbered
6、 0.1), 0.2, etc. Where this Technical Corrigendum introduces new subclauses, the new subclauses have been numbered as follows: Subclauses inserted between, for example, 4.3.2 and 4.3.3 are numbered 4.3.2a, 4.3.2b, etc. Those inserted before, for example, 4.3.1 are numbered 4.3.0, 4.3.0a, etc. Copyri
7、ght International Organization for Standardization Provided by IHS under license with ISO Licensee=IHS Employees/1111111001, User=Wing, Bernie Not for Resale, 04/02/2007 21:06:46 MDTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-10:2003/Cor.1:2005(E) ii ISO/IEC 2
8、005 All rights reserved Copyright International Organization for Standardization Provided by IHS under license with ISO Licensee=IHS Employees/1111111001, User=Wing, Bernie Not for Resale, 04/02/2007 21:06:46 MDTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-10:2
9、003/Cor.1:2005(E) ISO/IEC 2005 All rights reserved iii ContentsPage Foreword. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Copyright International Organization for Standardi
10、zation Provided by IHS under license with ISO Licensee=IHS Employees/1111111001, User=Wing, Bernie Not for Resale, 04/02/2007 21:06:46 MDTNo reproduction or networking permitted without license from IHS -,-,- Copyright International Organization for Standardization Provided by IHS under license with
11、 ISO Licensee=IHS Employees/1111111001, User=Wing, Bernie Not for Resale, 04/02/2007 21:06:46 MDTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-10:2003/Cor.1:2005(E) ISO/IEC 2005 All rights reserved 1 TECHNICAL CORRIGENDUM 1 Foreword 1.Rationale:Remove incorrect
12、reference to obsolete part. In the 7th paragraph, delete the 5th bullet. Information technology Database languages SQL Part 10: Object Language Bindings (SQL/OLB) Copyright International Organization for Standardization Provided by IHS under license with ISO Licensee=IHS Employees/1111111001, User=W
13、ing, Bernie Not for Resale, 04/02/2007 21:06:46 MDTNo reproduction or networking permitted without license from IHS -,-,- Reference number ISO/IEC 9075-10:2003(E) ISO/IEC 2003 INTERNATIONAL STANDARD ISO/IEC 9075-10 Second edition 2003-12-15 Information technology Database languages SQL Part 10: Obje
14、ct Language Bindings (SQL/OLB) Technologies de linformation Langages de base de donnes SQL Partie 10: Liaisons de langage objet (SQL/OLB) Copyright International Organization for Standardization Provided by IHS under license with ISO Licensee=IHS Employees/1111111001, User=Wing, Bernie Not for Resal
15、e, 04/02/2007 21:06:46 MDTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-10:2003(E) PDF disclaimer This PDF file may contain embedded typefaces. In accordance with Adobes licensing policy, this file may be printed or viewed but shall not be edited unless the type
16、faces which are embedded are licensed to and installed on the computer performing the editing. In downloading this file, parties accept therein the responsibility of not infringing Adobes licensing policy. The ISO Central Secretariat accepts no liability in this area. Adobe is a trademark of Adobe S
17、ystems Incorporated. Details of the software products used to create this PDF file can be found in the General Info relative to the file; the PDF-creation parameters were optimized for printing. Every care has been taken to ensure that the file is suitable for use by ISO member bodies. In the unlike
18、ly event that a problem relating to it is found, please inform the Central Secretariat at the address given below. ISO/IEC 2003 All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means, electronic or mechanical, including
19、photocopying and microfilm, without permission in writing from either ISO at the address below or ISOs member body in the country of the requester. ISO copyright office Case postale 56 CH-1211 Geneva 20 Tel. + 41 22 749 01 11 Fax + 41 22 749 09 47 E-mail copyrightiso.org Web www.iso.org Published in
20、 Switzerland ii ISO/IEC 2003 All rights reserved Copyright International Organization for Standardization Provided by IHS under license with ISO Licensee=IHS Employees/1111111001, User=Wing, Bernie Not for Resale, 04/02/2007 21:06:46 MDTNo reproduction or networking permitted without license from IH
21、S -,-,- ContentsPage Foreword. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
22、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xx 1Scope. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 2Normative references. . . . . . . . . .
23、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2.1JTC 1 standards. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2.2Other
24、international standards. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 3Definitions, notations, and conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
25、 3.1Definitions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 3.1.1Definitions provided in Part 10. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
26、 . . . . . . . . . . . . . . . 5 3.2Notation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 3.3Conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
27、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 3.3.1Use of terms. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 3.3.1.1Other terms. . . . . . . . . . . . . . . . . . . .
28、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 3.3.2Specification of translator-generated classes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 4Concepts. . . . . . . . . . .
29、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4.1Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
30、. . . . 11 4.2Embedded syntax. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4.3SQL constructs. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
31、 . . . . . . . . . . . . . . . . . . 12 4.4Character strings. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 4.4.1Unicode support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
32、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 4.4.2Character sets. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.5Host variables. . . . . . . . . . . . . . . . . . . .
33、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.6Host expressions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.7SQLJ clauses. . . .
34、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 4.8Database connection context. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
35、14 4.9Default connection context. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 4.10Schema checking using exemplar schemas. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
36、 . . . 15 4.11Using multiple SQLJ contexts and connections. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 4.12Dynamic SQL and JDBC/SQLJ Connection interoperability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 4.12.1Cre
37、ating an SQLJ ConnectionContext from a JDBC connection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 4.12.2Obtaining a JDBC connection from an SQLJ ConnectionContext. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 4.12.3Connection sharing. . . . . . .
38、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 4.12.4Connection resource management. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 4.13SQL executio
39、n control and status. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 4.14Iterators. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
40、. . . . . . 19 4.15Input and output assignability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 ISO/IEC 2003 All rights reservedContents iii ISO/IEC 9075-10:2003 (E) Copyright International Organization for Standardizati
41、on Provided by IHS under license with ISO Licensee=IHS Employees/1111111001, User=Wing, Bernie Not for Resale, 04/02/2007 21:06:46 MDTNo reproduction or networking permitted without license from IHS -,-,- 4.16Calls to stored procedures and functions. . . . . . . . . . . . . . . . . . . . . . . . . .
42、 . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 4.17Multiple JDBC ResultSet objects from stored procedure calls. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 4.17.1Resource management with multiple results. . . . . . . . . . . . . . . . . . . . . . . . . . . . .
43、 . . . . . . . . . . . . . . . . . . . . . 32 4.18JDBC/SQLJ ResultSet interoperability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 4.18.1Creating an SQLJ iterator from a JDBC ResultSet object. . . . . . . . . . . . . . . . . . . . . .
44、 . . . . . . . . . . . . . . . . . . 32 4.18.2Obtaining a JDBC ResultSet object from an SQLJ iterator object. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 4.18.3Obtaining a JDBC ResultSet object from an untyped iterator object. . . . . . . . . . . . . . . . . . . . . . . . .
45、. . . . . . . 33 4.18.4Iterator and JDBC ResultSet resource management. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 4.19Multi-threading considerations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
46、 . . . . . . . . . 34 4.20User-defined data types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 4.21Batch updates. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
47、 . . . . . . . . . . . . . . . . . . . . . . . . 35 4.21.1Batchable statements and batch compatibility. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 4.21.2Statement batching API. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
48、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 4.21.3Execution status and update counts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 4.21.4Program semantics and exceptions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .