Oracle 10g JDBC开发指南与参考

需积分: 10 92 浏览量更新于2024-07-29 收藏 6.88MB PDF 举报

Oracle Database JDBC Developer's Guide and Reference, 10g Release 2 (10.2) 是一本详尽的指南，专为那些希望通过Java开发强大数据库应用程序的开发者设计。该书由Venkatasubramaniam Iyer、Elizabeth Hanes Perry、Brian Wright、Thomas Pfaeffle等主要作者以及Brian Martin等贡献者共同编写，版权归属Oracle及其关联公司，日期为2010年3月。本书的核心内容涵盖了如何有效地利用Oracle JDBC驱动程序，这是Oracle数据库与Java应用程序之间的关键接口，允许开发者在Java应用程序中连接、查询、管理和操作Oracle数据库。JDBC (Java Database Connectivity) 是一套标准API，它定义了编程接口，使得开发者可以在不同的数据库系统上实现一致的数据库操作。在书中，读者可以学习到以下关键知识点： 1. **JDBC概述**：介绍JDBC的基本概念，包括其在Java应用程序中的作用、连接池管理、事务处理和结果集处理等。 2. **环境配置**：详细说明如何设置开发环境，包括驱动程序的下载、配置及添加到项目中，确保兼容性和最佳性能。 3. **连接管理**：包括建立、关闭和管理数据库连接的方法，以及异常处理策略。 4. **SQL查询与执行**：讲解如何编写和执行各种类型的SQL语句，如SELECT、INSERT、UPDATE和DELETE等，并演示如何使用PreparedStatement以提高性能和安全性。 5. **预编译语句与存储过程**：介绍预编译语句的优势，以及如何调用存储过程进行更复杂的数据处理。 6. **数据类型映射与结果集处理**：讨论如何处理不同数据库的数据类型转换，以及如何遍历和操作ResultSet对象。 7. **事务与并发控制**：讲解事务的概念，以及如何在JDBC中实现ACID（原子性、一致性、隔离性和持久性）特性。 8. **连接池优化**：介绍如何使用连接池管理大量的数据库连接，以减少资源消耗和提高性能。 9. **错误处理与调试**：提供常见问题的解决方法和调试技巧，帮助开发者快速定位和解决问题。 10. **高级主题**：涵盖JDBC 4.0的新特性，如JDBC 4.0的增强功能、Java EE集成以及使用ORM工具（如Hibernate）的最佳实践。 Oracle Database JDBC Developer's Guide and Reference, 10g Release 2是一本实用的指南，无论是初学者还是经验丰富的Java开发者，都能从中获取宝贵的知识和技能，以构建高效、稳定和安全的Java数据库应用。通过遵循书中的指导，开发者将能够充分利用Oracle数据库的强大功能，实现自己的项目需求。

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

Deaf/Hard of Hearing Access to Oracle Support Services

To reach Oracle Support Services, use a telecommunications relay service (TRS) to call

Oracle Support at 1.800.223.1711. An Oracle Support Services engineer will handle

technical issues and provide customer support according to the Oracle service request

process. Information about TRS is available at

http://www.fcc.gov/cgb/consumerfacts/trs.html, and a list of phone

numbers is available at http://www.fcc.gov/cgb/dro/trsphonebk.html.

Oracle 10g JDBC开发指南与参考

JDBC Developer’s Guide and Reference

Oracle8i JDBC Developer’s Guide and Reference Release 3 (8.1.7)

https://neo4j.com/developer/java/#_neo4j_jdbc_driver下载

MySQL的jdbc和jdbc的相关参数在那查看

jdbc:mysql:

怎么安装jdbc和jdbc环境

shardingjdbc demo

No suitable driver found for jdbc:mysql//localhost:3306/,javaweb

JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@64a81dc9] will not be managed by Spring

jdbc 和 log4jdbc

最新资源