Oracle 11g Java Developer指南：开发与应用实战

需积分: 5 68 浏览量更新于2024-06-25 收藏 7.12MB PDF 举报

Oracle Database Java Developer's Guide 11g Release 2 (11.2) 是一本详尽的指南，专为开发人员设计，旨在帮助他们在 Oracle 数据库 11.2 版本中进行Java应用程序的开发、加载和运行。该指南由Tulika Das、Sheryl Maring、Rick Sapir、Michael Wiesenberg等为主要作者编写，同时还有 Venkatasubramaniam Iyer、Brian Wright 等贡献者共同参与，确保了内容的专业性和实用性。书中涵盖了广泛的主题，包括但不限于Java与Oracle数据库的集成、数据库连接（JDBC）的使用、存储过程和包装器的开发、数据访问对象（DAO）的设计，以及Oracle特定的Java API的运用，如Oracle JDBC驱动、Oracle SQL语言、Oracle Enterprise Manager集成等。此外，还讨论了最佳实践，如异常处理、性能优化、线程安全和内存管理，以确保在生产环境中Java应用的稳定性和效率。版权信息表明，该指南受到1999年和2013年Oracle及其关联公司的版权保护，用户在使用过程中必须遵守相关许可协议中的使用和披露限制，并受知识产权法律保护。除非在许可协议中有明确授权或法律规定，否则不得复制、修改、翻译或传播该软件和文档。本书特别强调了开发者的责任，即在遵守版权法规的同时，要遵循良好的编程习惯，确保代码质量。它还提到了多位专家的名字，这些专家可能在特定章节或示例中提供了他们的专业知识，增加了内容的深度和多样性。对于那些希望在Oracle 11g Release 2环境中进行Java开发的人员，这本指南是不可或缺的参考资料，它不仅提供了技术细节，还为开发者提供了解决实际问题和应对挑战的实用工具和策略。通过深入学习和实践，读者能够提升在Oracle数据库中构建高效、可靠Java应用程序的能力。

xvi

List of Examples

2–1 Retrieve Resolver from Current Class .................................................................................. 2-23

2–2 Retrieve Resolver from Calling Class ................................................................................... 2-23

2–3 Providing Schema and Class Names .................................................................................... 2-24

2–4 Closing Your Operating System Resources ......................................................................... 2-27

2–5 Compromising Your Operating System Resources............................................................ 2-54

2–6 Correctly Managing Your Operating System Resources ................................................... 2-55

3–1 Basic Configuration of listener.ora with the Default Service Defined ............................. 3-12

6–1 Publishing a Simple JDBC Stored Procedure.......................................................................... 6-7

6–2 Publishing the main() Method .................................................................................................. 6-8

6–3 Publishing a Method That Returns an Integer Value............................................................ 6-8

6–4 Publishing a Method That Switches the Values of Its Arguments ...................................... 6-9

6–5 Packaged Call Specification.................................................................................................... 6-10

7–1 A Simple JDBC Stored Procedure............................................................................................. 7-2

7–2 Fibonacci Sequence..................................................................................................................... 7-3

7–3 Calling Java Stored Procedure from Database Trigger - I..................................................... 7-4

7–4 Calling Java Stored Procedure from Database Trigger - II ................................................... 7-6

10–1 Granting Permissions.............................................................................................................. 10-7

10–2 Limiting Permissions............................................................................................................... 10-7

10–3 Granting PolicyTable Permission .......................................................................................... 10-9

xviii

List of Tables

1–1 Feature List of Oracle JVM .................................................................................................... 1-17

2–1 Description of Java Code and Classes..................................................................................... 2-4

2–2 Definitions for the Name and Option Parameters ................................................................ 2-7

2–3 Example JAVA$OPTIONS Table............................................................................................. 2-8

2–4 ORA Errors .............................................................................................................................. 2-11

2–5 Description of Java Files......................................................................................................... 2-12

2–6 loadjava Operations on Schema Objects.............................................................................. 2-13

2–7 Key USER_OBJECT Columns ............................................................................................... 2-18

2–8 Statement Auditing Options Related to Java Schema Objects ......................................... 2-20

2–9 Object Auditing Options Related to Java Schema Options .............................................. 2-20

2–10 Description of the Summary Tab Fields in JConsole Interface......................................... 2-34

3–1 Command Line Argument Summary.................................................................................. 3-10

3–2 set_output_to_sql Argument Summary .............................................................................. 3-14

3–3 set_output_to_java Argument Summary............................................................................ 3-17

6–1 Legal Data Type Mappings ...................................................................................................... 6-3

10–1 Predefined Permissions........................................................................................................ 10-14

10–2 JServerPermission Description............................................................................................ 10-15

10–3 SYS Initial Permissions......................................................................................................... 10-16

10–4 PUBLIC Default Permissions .............................................................................................. 10-16

10–5 JAVAUSERPRIV Permissions............................................................................................. 10-17

10–6 JAVASYSPRIV Permissions ................................................................................................ 10-17

10–7 JAVADEBUGPRIV Permissions ......................................................................................... 10-17

11–1 ojvmtc Argument Summary.................................................................................................. 11-5

11–2 loadjava Argument Summary............................................................................................... 11-7

11–3 dropjava Argument Summary............................................................................................ 11-18

11–4 ojvmjava Argument Summary............................................................................................ 11-22

11–5 ojvmjava Command Common Options............................................................................. 11-24

11–6 java Argument Summary .................................................................................................... 11-25

11–7 connect Argument Summary.............................................................................................. 11-27

11–8 runjava Argument Summary.............................................................................................. 11-27

11–9 jdwp Argument Summary................................................................................................... 11-27

xix

List of Figures

1–1 Classes and Instances ................................................................................................................. 1-3

1–2 Java Component Structure ........................................................................................................ 1-6

1–3 Oracle Database Java Component Structure........................................................................... 1-7

1–4 Class Hierarchy ........................................................................................................................... 1-8

1–5 Two-Tier Client/Server Configuration.................................................................................... 1-9

1–6 Garbage Collection .................................................................................................................. 1-11

1–7 Interpreter versus Accelerator ............................................................................................... 1-13

1–8 Main Components of an Oracle JVM.................................................................................... 1-17

2–1 Java Environment Within Each Database Session ................................................................. 2-2

2–2 Loading Java into Oracle Database .......................................................................................... 2-4

2–3 Rights to Run Classes .............................................................................................................. 2-16

2–4 Invoker’s rights Solution......................................................................................................... 2-17

2–5 Indirect Access.......................................................................................................................... 2-17

2–6 The Summary Tab of the JConsole Interface........................................................................ 2-34

2–7 The Memory Tab of the JConsole Interface.......................................................................... 2-35

2–8 The Threads Tab of the JConsole Interface .......................................................................... 2-37

2–9 The Classes tab of the JConsole interface ............................................................................. 2-38

2–10 Displaying the Attributes of an MBean ................................................................................ 2-39

2–11 Displaying a Chart of the Values of an Attribute................................................................ 2-39

2–12 Displaying Details of a Complex Attribute in the MBeans Tab........................................ 2-40

2–13 Operations Tab of the MBeans Tab of the JConsole Interface........................................... 2-41

2–14 The VM Tab of the JConsole Interface .................................................................................. 2-41

2–15 Attributes Tab of the OracleRuntime MBean ...................................................................... 2-42

2–16 OracleRuntime MBean............................................................................................................ 2-43

2–17 Operation sessionsRunningJava............................................................................................ 2-43

2–18 Operation sessionDetailsBySID ............................................................................................. 2-44

2–19 Setting the Usage Threshold and Collection Usage Threshold in the MBeans Tab....... 2-45

2–20 Memory Tab of the JConsole Interface When Used Memory Exceeds the Usage Threshold..

2-46

3–1 Client-Side Stub Interface ....................................................................................................... 3-11

5–1 Calling a Stored Procedure........................................................................................................ 5-1

6–1 Calling a Java Method................................................................................................................ 6-2

8–1 Rule for Drawing an E-R Diagram........................................................................................... 8-2

8–2 E-R Diagram for Purchase Order Application........................................................................ 8-3

8–3 Schema Plan for Purchase Order Application........................................................................ 8-4

9–1 Configuring Oracle JVM Memory Parameters....................................................................... 9-5

12–1 Web Services Call-In to the Database ................................................................................... 12-2

12–2 Calling Web Services From Within the Database ............................................................... 12-4

12–3 Storing Results from Request in a Virtual Table ................................................................. 12-5

12–4 Creating Web Services Call-Out Stubs ................................................................................. 12-6

剩余267页未读，继续阅读

weixin_40191861_zj

粉丝: 86
资源: 1万+

Oracle 11g Java Developer指南：开发与应用实战

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

Oracle Database JDBC Developer’s Guide 11g Release 2 (11.2)-506

Oracle® Database .NET Developer's Guide 11g Release 2

oracle oracle-instantclient11.2-basic-11.2.0.4

oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

下载oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip资源

在使用Oracle Objects for OLE技术连接Oracle 11g数据库时，可能会遇到哪些连接问题，以及如何利用《Oracle Objects for OLE Developer's Guide 11g Release 2 Windows版》中的知识解决这些问题？

path /usr in package oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64 is n

oracle database instant client 11g 11.2.0.3.0 x64

如何在Oracle 11g Release 2中配置和使用Oracle Database Gateway for ODBC进行异构数据库连接？

最新资源