Oracle JDBC Developer's Guide: Building Java Database Apps

需积分: 9 54 浏览量更新于2024-08-02 收藏 7.89MB PDF 举报

"Oracle® Database JDBC Developer’s Guide and Reference 10g Release 2 (10.2) B14355-02" Oracle JDBC Developer's Guide and Reference是Oracle公司发布的一份详细的文档，旨在帮助Java开发者利用Oracle JDBC驱动程序构建高效、强大的数据库应用。这份指南涵盖了10g Release 2版本的JDBC特性，出版于2007年1月。 JDBC（Java Database Connectivity）是Java平台中用于与各种数据库交互的标准API。它允许Java程序通过SQL语句执行数据库操作，如查询、插入、更新和删除数据。Oracle JDBC驱动程序提供了与Oracle数据库的连接能力，支持不同的连接方式，包括标准的Type 1、Type 2、Type 3和Type 4驱动。在本书中，开发者可以了解到以下关键知识点： 1. **JDBC基础知识**：介绍JDBC的基本概念，包括JDBC API、驱动程序类型、连接数据库的方法、以及如何创建Statement和PreparedStatement对象来执行SQL语句。 2. **连接管理**：详细讲解如何建立和管理数据库连接，包括使用DataSource、Connection Pooling（连接池）以及JNDI（Java Naming and Directory Interface）进行连接管理。 3. **事务处理**：介绍事务的概念，如何开始、提交、回滚事务，以及设置事务隔离级别。 4. **结果集处理**：涵盖ResultSet接口的使用，如何遍历查询结果，以及处理批处理和游标。 5. **高级特性**：如批处理操作、存储过程调用、CallableStatement的使用，以及处理BLOB、CLOB等大型对象。 6. **性能优化**：提供关于提高JDBC应用程序性能的策略，如预编译SQL语句、使用批处理、缓存结果和正确关闭资源等。 7. **错误处理和诊断**：描述如何捕获和处理JDBC异常，以及如何利用Oracle的JDBC日志和诊断工具。 8. **安全性**：包括认证、授权、SSL/TLS加密连接和数据源安全配置等内容。 9. **分布式数据库操作**：讲解如何在分布式环境中使用JDBC，如分布式事务和分布式数据库连接。 10. **Oracle特定特性**：介绍了Oracle特有的JDBC功能，如ocijdbc14.jar驱动中的Oracle扩展API，以及Oracle的高级特性如物化视图、分区表等。这本书的作者团队由多位专家组成，包括Venkatasubramaniam Iyer、Elizabeth Hanes Perry、Brian Wright、Thomas Pfaeffle等，他们共同贡献了丰富的开发经验和专业知识。该书版权属于Oracle公司，并受到特定的使用和披露限制。同时，程序（包括软件和文档）含有保密信息，受许可协议保护，且受到版权法的保护。 Oracle JDBC Developer's Guide and Reference是开发人员使用Oracle数据库和Java进行数据库开发的重要参考资料，包含了所有需要了解和掌握的Oracle 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页未读，继续阅读

babytiger2009

粉丝: 0
资源: 4

Oracle JDBC Developer's Guide: Building Java Database Apps

oracle_jdbc_pdf

JDBC Oracle.pdf

Oracle JDBC事务的优化.pdf

Oracle的JDBC.pdf

关于Oracle JDBC Thin Drivers的解析.pdf

利用Oracle JDBC连接池提高Web访问数据库的效率.pdf

Oracle JDBC连接缓存对JSP数据库处理性能的优化.pdf

JDBC连接oracle数据库.pdf

jdbc pdf入门讲解

达内笔记（CoreJava.pdf、EJBNote.pdf、Hibernate.pdf、HTML.pdf、JDBC.pdf、JSP.pdf、Oracle SQL.pdf、Servlet.pdf、Struts.pdf、XML.pdf、分页.pdf、购物车.pdf）

最新资源