Oracle Database JDBC开发指南 11g R2 (11.2) E16548-03 - 使用Oracle JDBC驱动程序开发Java数据库应用程序。

需积分: 5 126 浏览量更新于2023-11-24 收藏 8.65MB PDF 举报

《Oracle数据库JDBC开发人员指南11g Release 2 (11.2)-506》是一本介绍如何使用Oracle JDBC驱动程序开发强大的Java数据库应用程序的书籍。该书由多位作者共同撰写，主要作者包括Tulika Das、Venkatasubramaniam Iyer、Elizabeth Hanes Perry、Brian Wright和Thomas Pfaeffle。其中还有其他贡献作者和参与者。该指南详细介绍了Oracle JDBC驱动程序的使用方法，旨在帮助开发人员了解如何使用该驱动程序连接、查询和操作Oracle数据库。该指南提供了丰富的示例代码和实践案例，以帮助读者深入理解和掌握使用Oracle JDBC驱动程序进行开发的技巧和实践。本书内容包括了如何安装和配置Oracle JDBC驱动程序、使用JDBC API与数据库进行交互、执行SQL语句和存储过程、处理事务、使用批量更新等。此外，该指南还介绍了如何处理数据库连接池、使用数据源和连接属性、优化数据库访问性能等高级主题。总结来说，《Oracle数据库JDBC开发人员指南11g Release 2 (11.2)-506》是一本全面而实用的指南书籍，适合那些希望使用Oracle JDBC驱动程序进行Java数据库开发的开发人员阅读和参考。通过阅读本书，读者可以获得对Oracle JDBC驱动程序的深入理解，并掌握开发强大的Java数据库应用程序所需的技巧和实践。

xvi

D JDBC Error Messages

General Structure of JDBC Error Messages ....................................................................................... D-1

General JDBC Messages ........................................................................................................................ D-1

JDBC Messages Sorted by ORA Number...................................................................................... D-2

JDBC Messages Sorted in Alphabetic Order................................................................................. D-7

Native XA Messages ............................................................................................................................. D-12

Native XA Messages Sorted by ORA Number ........................................................................... D-12

Native XA Messages Sorted in Alphabetic Order...................................................................... D-13

TTC Messages ........................................................................................................................................ D-13

TTC Messages Sorted by ORA Number...................................................................................... D-13

TTC Messages Sorted in Alphabetic Order................................................................................. D-15

E Troubleshooting

Common Problems.................................................................................................................................. E-1

Memory Consumption for CHAR Columns Defined as OUT or IN/OUT Variables ............ E-1

Memory Leaks and Running Out of Cursors................................................................................ E-2

Boolean Parameters in PL/SQL Stored Procedures..................................................................... E-2

Opening More Than 16 OCI Connections for a Process.............................................................. E-2

Using statement.cancel..................................................................................................................... E-3

Using JDBC with Firewalls.............................................................................................................. E-3

Frequent Abrupt Disconnection from Server................................................................................ E-4

Basic Debugging Procedures ................................................................................................................ E-4

Oracle Net Tracing to Trap Network Events ................................................................................ E-4

Client-Side Tracing ................................................................................................................... E-5

TRACE_LEVEL_CLIENT ................................................................................................. E-5

TRACE_DIRECTORY_CLIENT ....................................................................................... E-5

TRACE_FILE_CLIENT ...................................................................................................... E-5

TRACE_UNIQUE_CLIENT ............................................................................................. E-6

Server-Side Tracing ................................................................................................................... E-6

TRACE_LEVEL_SERVER ................................................................................................. E-6

TRACE_DIRECTORY_SERVER ...................................................................................... E-6

TRACE_FILE_SERVER...................................................................................................... E-7

Third Party Debugging Tools ......................................................................................................... E-7

Index

xvii

List of Examples

3–1 Accessing SQLXML Data........................................................................................................... 3-8

4–1 Accessing SYS.ANYTYPE Type............................................................................................. 4-17

4–2 Creating a Transient Object Type Through PL/SQL and Retrieving Through JDBC ... 4-17

4–3 Calling a PL/SQL Stored Procedure That Takes an ANYTPE as IN Parameter............ 4-17

4–4 Accessing an Instance of ANYDATA from the Database.................................................. 4-18

4–5 Inserting an Object as ANYDATA in a Database Table..................................................... 4-18

4–6 Selecting an ANYDATA Column from a Database Table ................................................. 4-19

8–1 Using SYS Login To Make a Remote Connection .................................................................. 8-8

9–1 Using SSL Authentication to Connect to the Database ......................................................... 9-2

9–2 Using a Data Source to Connect to the Database ................................................................... 9-3

9–3 Setting Data Encryption and Integrity Parameters............................................................. 9-10

9–4 Using Kerberos Authentication to Connect to the Database............................................. 9-15

9–5 Using RADIUS Authentication to Connect to the Database ............................................. 9-20

20–1 Using Implicit Statement Cache............................................................................................. 20-8

21–1 Using the Implicit Connection Cache ................................................................................... 21-4

21–2 Connection Cache Example................................................................................................... 21-6

21–3 Using Connection Attributes.................................................................................................. 21-8

21–4 Using Connection Properties ............................................................................................... 21-12

21–5 Connection Cache Manager Example................................................................................. 21-13

23–1 Oracle Update Batching .......................................................................................................... 23-7

23–2 Standard Update Batching.................................................................................................... 23-12

23–3 Premature Batch Flushing .................................................................................................... 23-14

23–4 Defining Column Types........................................................................................................ 23-19

23–5 TABLE_REMARKS Reporting............................................................................................. 23-20

25–1 Creating a Message and Setting a Payload .......................................................................... 25-7

25–2 Enqueuing a Single Message................................................................................................ 25-10

25–3 Dequeuing a Single Message................................................................................................ 25-10

26–1 Database Change Notification ............................................................................................... 26-5

27–1 Enabling Fast Connection Failover........................................................................................ 27-4

30–1 Database Startup and Shutdown........................................................................................... 30-3

B–1 Example of a Sample ons.config File....................................................................................... B-5

B–2 Example of Sample Code Using Oracle RAC FAN API....................................................... B-6

List of Tables

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

1–2 Feature List.................................................................................................................................. 1-5

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

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

3–2 BLOB Method Equivalents....................................................................................................... 3-5

3–3 CLOB Method Equivalents....................................................................................................... 3-6

4–1 Key Interfaces and Classes of the oracle.jdbc Package...................................................... 4-19

4–2 PL/SQL Types and Corresponding JDBC Types............................................................... 4-28

4–3 Arguments of the setPlsqlIndexTable Method................................................................... 4-29

4–4 Arguments of the registerIndexTableOutParameter Method.......................................... 4-31

4–5 Argument of the getPlsqlIndexTable Method.................................................................... 4-32

4–6 Argument of the getOraclePlsqlIndexTable Method ........................................................ 4-32

4–7 Arguments of the getPlsqlIndexTable Method .................................................................. 4-33

6–1 OCI Instant Client Shared Libraries........................................................................................ 6-5

6–2 Data Shared Library for Instant Client and Instant Client Light (English).................... 6-11

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

8–2 Oracle Extended Data Source Properties................................................................................ 8-3

8–3 Supported Database Specifiers ............................................................................................. 8-11

9–1 Client/Server Negotiations for Encryption or Integrity ...................................................... 9-7

9–2 OCI Driver Client Parameters for Encryption and Integrity............................................... 9-8

9–3 Thin Driver Client Parameters for Encryption and Integrity.............................................. 9-8

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

11–2 getObject and getOracleObject Return Types..................................................................... 11-8

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

13–1 JPublisher SQL Type Categories, Supported Settings, and Defaults ............................ 13-29

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

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

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

20–2 Methods Used in Statement Allocation and Implicit Statement Caching...................... 20-7

20–3 Methods Used to Retrieve Explicitly Cached Statements............................................... 20-10

23–1 Valid Column Type Specifications..................................................................................... 23-20

26–1 Database Change Notification Registration Options......................................................... 26-3

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

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

30–1 Supported Database Startup Options.................................................................................. 30-2

30–2 Supported Database Shutdown Options............................................................................. 30-3

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 Required ONS Configuration Parameters............................................................................. B-4

B–2 Optional ONS Configuration Parameters ............................................................................. B-4

B–3 onsctl Commands ..................................................................................................................... B-5

D–1 JDBC Messages Sorted by ORA Number.............................................................................. D-2

D–2 JDBC Messages Sorted in Alphabetic Order......................................................................... D-7

D–3 Native XA Messages Sorted by ORA Number................................................................... D-12

D–4 Native XA Messages Sorted in Alphabetic Order.............................................................. D-13

D–5 TTC Messages Sorted by ORA Number.............................................................................. D-13

D–6 TTC Messages Sorted in Alphabetic Order......................................................................... D-15

剩余505页未读，继续阅读

weixin_40191861_zj

粉丝: 85
资源: 1万+

Oracle Database JDBC开发指南 11g R2 (11.2) E16548-03 - 使用Oracle JDBC...

最新资源

Oracle Database JDBC开发指南 11g R2 (11.2) E16548-03 - 使用Oracle JDBC...

Oracle Database Workspace Manager Developer's Guide 11g Release 2 (11.2) - 340: 了解Oracle Workspace...

11g Release 2 Oracle Database Error Message 11.2 - E17766-03 解析与指南

Oracle Database JDBC开发指南：10g Release 1 (10.1) - B10979-02

Oracle Database SQLJ Developer’s Guide 11g Release 2 (11.2)-482

Oracle Database Java Developer’s Guide 11g Release 2 (11.2)-268

Oracle Database 2 Day Developer's Guide 11g Release 2 (11.2

Oracle Database JPublisher User's Guide 11g Release 2 (11.2)-212

Oracle DatabaseWorkspace Manager Developer's Guide 11g Release 2

Oracle Universal Connection Pool for JDBC Developer’s Guide 11g

Oracle® Database 11g Release 2开发者指南

最新资源