Oracle JDBC驱动开发者指南与参考

5星 · 超过95%的资源需积分: 50 120 浏览量更新于2024-07-29 收藏 7.89MB PDF 举报

"Oracle® Database JDBC Developer’s Guide and Reference 10g Release 2 (10.2) B14355-02" Oracle JDBC官方文档是开发者使用Oracle数据库构建强大Java数据库应用程序的权威指南。这份文档覆盖了10g Release 2 (10.2)版本的相关内容，由多个作者共同编写，旨在提供详细的JDBC驱动程序使用教程和技术参考。文档主要知识点包括： 1. **JDBC简介**：介绍Java Database Connectivity（JDBC）规范，它是Java编程语言与各种数据库之间的桥梁，让开发者能够用Java编写数据库应用。 2. **驱动程序类型**：解释了Oracle JDBC驱动的不同类型，如 Thin、OCI（Oracle Call Interface）和JDBC-ODBC桥，以及它们的适用场景和性能差异。 3. **连接数据库**：详述如何通过Java代码建立与Oracle数据库的连接，包括数据源（DataSource）的使用，JDBC URL的构造，以及认证信息的管理。 4. **SQL语句执行**：介绍如何使用Statement、PreparedStatement和CallableStatement对象来执行SQL查询、更新和存储过程。 5. **结果集处理**：讲解如何遍历和操作ResultSet对象，包括游标管理、结果集的滚动和定位，以及数据转换。 6. **事务管理**：讨论了在JDBC中如何控制事务的开始、提交、回滚和隔离级别。 7. **批处理操作**：展示如何使用批处理API来提高多条SQL语句的执行效率。 8. **性能优化**：提供了一些最佳实践和技巧，帮助开发者优化JDBC应用的性能，如预编译语句、结果集缓存和批量更新。 9. **连接池管理**：解释了如何集成和配置连接池，如C3P0、Apache DBCP或Oracle的Universal Connection Pool (UCP)，以提高资源利用效率。 10. **异常处理**：介绍了JDBC特有的异常类，以及如何捕获和处理数据库相关的错误。 11. **高级特性**：涵盖流处理、LOB（Large Object）操作、分布式事务、XML支持、透明网络重定向等复杂功能。 12. **安全性和权限**：讨论了JDBC应用的安全策略，包括SSL/TLS加密、身份验证和授权机制。 13. **监控和诊断**：提供了诊断工具和日志记录选项，帮助开发者调试和分析JDBC应用的性能问题。 14. **兼容性和版本信息**：列出了与不同Java和Oracle数据库版本的兼容性信息。这份文档是开发人员在使用Oracle数据库进行Java开发时的重要参考资料，通过深入阅读和实践，开发者可以掌握高效、稳定和安全的JDBC编程技术。

xvi

Client-Side Tracing ................................................................................................................... D-4

TRACE_LEVEL_CLIENT ................................................................................................. D-4

TRACE_DIRECTORY_CLIENT ....................................................................................... D-5

TRACE_FILE_CLIENT ...................................................................................................... D-5

TRACE_UNIQUE_CLIENT ............................................................................................. D-5

Server-Side Tracing ................................................................................................................... D-6

TRACE_LEVEL_SERVER ................................................................................................. D-6

TRACE_DIRECTORY_SERVER ...................................................................................... D-6

TRACE_FILE_SERVER...................................................................................................... D-6

Third Party Debugging Tools ......................................................................................................... D-6

Index

xviii

List of Tables

1–1 Feature Differences Between JDBC OCI and JDBC Thin Drivers....................................... 1-5

1–2 Feature List............................................................................................................................... 1-10

3–1 Import Statements for JDBC Driver ........................................................................................ 3-2

4–1 JDBC 3.0 Feature Support......................................................................................................... 4-3

4–2 Key Areas of JDBC 3.0 Functionality ...................................................................................... 4-3

4–3 BLOB Method Equivalents....................................................................................................... 4-8

4–4 CLOB Method Equivalents....................................................................................................... 4-8

5–1 Oracle Data Type Classes ......................................................................................................... 5-5

5–2 Key Interfaces and Classes of the oracle.jdbc Package...................................................... 5-17

5–3 PL/SQL Types and Corresponding JDBC Types............................................................... 5-29

5–4 Arguments of the setPlsqlIndexTable Method................................................................... 5-30

5–5 Arguments of the registerIndexTableOutParameter Method.......................................... 5-32

5–6 Argument of the getPlsqlIndexTable Method.................................................................... 5-33

5–7 Argument of the getOraclePlsqlIndexTable Method ........................................................ 5-34

5–8 Arguments of the getPlsqlIndexTable Method .................................................................. 5-34

7–1 OCI Instant Client Shared Libraries........................................................................................ 7-2

7–2 Data Shared Library for Instant Client and Instant Client Light (English)....................... 7-8

9–1 Standard Data Source Properties............................................................................................. 9-3

9–2 Oracle Extended Data Source Properties................................................................................ 9-4

9–3 Connection Properties Recognized by Oracle JDBC Drivers .............................................. 9-8

9–4 Supported Database Specifiers ............................................................................................. 9-14

10–1 Client/Server Negotiations for Encryption or Integrity ................................................... 10-3

10–2 OCI Driver Client Parameters for Encryption and Integrity............................................ 10-4

10–3 Thin Driver Client Parameters for Encryption and Integrity........................................... 10-4

13–1 Default Mappings Between SQL Types and Java Types................................................... 13-2

13–2 getObject and getOracleObject Return Types..................................................................... 13-7

13–3 Summary of getXXX Return Types .................................................................................... 13-10

13–4 Summary of setXXX Input Parameter Types.................................................................... 13-13

13–5 Size Limitations for setBytes and setString Methods ...................................................... 13-15

14–1 LONG and LONG RAW Data Conversions ....................................................................... 14-3

15–1 JPublisher SQL Type Categories, Supported Settings, and Defaults ............................ 15-35

19–1 Visibility of Internal and External Changes for Oracle JDBC......................................... 19-19

20–1 The JDBC and Cached Row Sets Compared....................................................................... 20-9

22–1 Comparing Methods Used in Statement Caching.............................................................. 22-3

22–2 Methods Used in Statement Allocation and Implicit Statement Caching...................... 22-6

22–3 Methods Used to Retrieve Explicitly Cached Statements................................................. 22-8

25–1 Valid Column Type Specifications..................................................................................... 25-19

27–1 onsctl commands..................................................................................................................... 27-4

29–1 Connection Mode Transitions............................................................................................... 29-4

29–2 Oracle-XA Error Mapping................................................................................................... 29-14

30–1 Maximum Lengths for End-to-End Metrics........................................................................ 30-1

A–1 Valid SQL Data Type-Java Class Mappings ......................................................................... A-1

A–2 Support for SQL Data Types ................................................................................................... A-3

A–3 Support for ANSI-92 SQL Data Types................................................................................... A-4

A–4 Support for SQL User-Defined Types.................................................................................... A-4

A–5 Support for PL/SQL Data Types............................................................................................ A-5

B–1 Mapping of SQL Data Types to Java Classes that Represent SQL Data Types ............... B-3

TTY Access to Oracle Support Services

Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services

within the United States of America 24 hours a day, seven days a week. For TTY

support, call 800.446.2398.

Related Documents

The following books are also available from the Oracle Java Platform group:

■ Oracle Database Java Developer's Guide

This book introduces the basic concepts of Java and provides general information

about server-side configuration and functionality. Information that pertains to the

Oracle Java platform as a whole, rather than to a particular product (such as JDBC)

is in this book. This book also discusses Java stored procedures, which were

formerly discussed in a standalone book.

■ Oracle Database JPublisher User's Guide

This book describes how to use the Oracle JPublisher utility to translate object

types and other user-defined types to Java classes. If you are developing JDBC

applications that use object types, VARRAY types, nested table types, or object

reference types, then JPublisher can generate custom Java classes to map to them.

The following OC4J documents, for Oracle Application Server releases, are also

available from the Oracle Java Platform group:

■ Oracle Application Server Containers for J2EE User’s Guide

This book provides some overview and general information for OC4J; primer

chapters for servlets, JSP pages, and EJBs; and general configuration and

deployment instructions.

■ Oracle Application Server Containers for J2EE Support for JavaServer Pages Developer’s

Guide

This book provides information for JSP developers who want to run their pages in

OC4J. It includes a general overview of JSP standards and programming

considerations, as well as discussion of Oracle value-added features and steps for

getting started in the OC4J environment.

■ Oracle Application Server Containers for J2EE JSP Tag Libraries and Utilities Reference

This book provides conceptual information and detailed syntax and usage

information for tag libraries, JavaBeans, and other Java utilities provided with

OC4J.

■ Oracle Application Server Containers for J2EE Servlet Developer’s Guide

This book provides information for servlet developers regarding use of servlets

and the servlet container in OC4J. It also documents relevant OC4J configuration

files.

■ Oracle Application Server Containers for J2EE Services Guide

This book provides information about basic Java services supplied with OC4J,

such as JTA, JNDI, and the Oracle Application Server Java Object Cache.

■ Oracle Application Server Containers for J2EE Enterprise JavaBeans Developer’s Guide

This book provides information about the EJB implementation and EJB container

in OC4J.

The following documents are from the Oracle Server Technologies group:

剩余483页未读，继续阅读

wjc495182948

粉丝: 0
资源: 4

Oracle JDBC驱动开发者指南与参考

jdbc 文档

非常好的JDBC学习文档

JDBC学习手册完整版

oracle_jdbc_pdf

Oracle_JDBC.doc

Oracle_API.zip_javaapi文档包名_oracle_oracle API文档_oracle chm api_ww

PL_SQL_Oracle_Or_Jdbc.pdf

oracle-jdbc官方文档

jdbcdao.zip_jdbc ttemplate_loose9l6_oracle_python_rockfps

oracle_sql帮助文档

最新资源