The traditional division of labor between the database (which only stores and manages SQL and XML data for fast, easy data search and retrieval) and the application server (which runs application or business logic, and presentation logic) is obsolete. Although the books primary focus is on programming the Oracle Database, the concepts and techniques provided apply to most RDBMS that support Java including Oracle, DB2, Sybase, MySQL, and PostgreSQL. This is the first book to cover new Java, JDBC, SQLJ, JPublisher and Web Services features in Oracle Database 10g Release 2 (the coverage starts with Oracle 9i Release 2). This book is a must-read for database developers audience (DBAs, database applications developers, data architects), Java developers (JDBC, SQLJ, J2EE, and OR Mapping frameworks), and to the emerging Web Services assemblers.

Key Features

* Describes pragmatic solutions, advanced database applications, as well as provision of a wealth of code samples * Addresses programming models which run within the database as well as programming models which run in middle-tier or client-tier against the database. * Discusses languages for stored procedures: when to use proprietary languages such as PL/SQL and when to use standard languages such as Java; also running non-Java scripting languages in the database * Describes the Java runtime in the Oracle database 10g (i.e., OracleJVM), its architecture, memory management, security management, threading, Java execution, the Native Compiler (i.e., NCOMP), how to make Java known to SQL and PL/SQL, data types mapping, how to call-out to external Web components, EJB components, ERP frameworks, and external databases. * Describes JDBC programming and the new Oracle JDBC 10g features, its advanced connection services (pooling, failover, load-balancing, and the fast database event notification mechanism) for clustered databases (RAC) in Grid environments. * Describes SQLJ programming and the latest Oracle SQLJ 10g features , contrasting it with JDBC * Describes the latest Database Web services features, Web services concepts and Services Oriented Architecture (SOA) for DBA, the database as Web services provider and the database as Web services consumer. * Abridged coverage of JPublisher 10g, a versatile complement to JDBC, SQLJ and Database Web Services.


DBAs and Developers

Table of Contents

Preface Introduction Part I: Java in the Database 1 Stored Procedures as Database Programming Model 1.1 Rationale for Stored Procedures 1.1.1 Simplifying Database Programming 1.1.2 Centrally Managed Data Logic 1.1.3 Performance: Run JDBC Applications Faster in the Database 1.1.4 Encapsulation 1.1.5 Security: Advanced Data Access Control 1.1.6 Resource Optimization 1.1.7 Low-Cost Deployment 1.1.8 Fully Utilize Database Capabilities 1.2 Obstacles to the Adoption of Stored Procedures 1.2.1 Lack of Portability across RDBMS Vendors 1.2.2 Scalability 1.2.3 Maintenance and Resilience to Schema Change 1.2.4 Hard to Debug 1.2.5 Weak Support for Complex Types 1.3 Languages for Stored Procedures 1.3.1 Proprietary Languages 1.3.2 Java for Stored Procedures 1.3.3 .NET Languages 1.4 PL/SQL or Java 1.4.1 PL/SQL and Java! 2 OracleJVM: Under the Hood 2.1 Design Goals and Architecture 2.1.1 Tight Integration with the RDBMS 2.1.2 J2SE Compatibility 2.1.3 How Is Java Stored in the Database? 2.1.4 Class Sharing 2.1.5 Interapplication Isolation (JSR 121) 2.1.6 Contrasting OracleJVM with the JDK VM 2.1.7 Resource Control 2.1.8 SQL Data Access from Java in the Database 2.1.9 DBMS_JAVA: The All-Purpose Tool for Administering OracleJVM 2.2 Java Memory Management 2.2.1 Key Memory Structures of the Oracle Database 2.2.2 Java Memory Allocation Techniques 2.2.3 Garbage Collection Techniques 2.2.4 Java Memory Areas


No. of pages:
© 2006
Digital Press
Print ISBN:
Electronic ISBN:

About the author

Kuassi Mensah

Group Product Manager, Java Products Group -- Oracle Corporation (U.S.A.). The author handles product management for Java, JDBC, and Database Web Services for the Oracle Database; as a result this book offers insider details and tips.

Affiliations and Expertise

Group Product Manager, Java Products Group - Oracle Corporation, U.S.A.


“If you are a Java programmer looking to exploit Oracle, or a database developer looking to exploit Java – this is the book for you.” — Thomas Kyte, VP Oracle “Oracle’s support for Java in the database has continued to break new ground since it was first introduced in Oracle8i. More importantly, however, it has continued to find a larger audience over time, as people discover just how useful it is in solving their real world problems both efficiently and easily. This book is an important and welcome step forward to helping Java developers make even better use of the Oracle database.” — Steven G. Harris, VP Java Platform Group “The book impressed me with its in-depth coverage on practical techniques essential to Java and Web services development across database boundary.” — Quan Wang “This book provides a wealth of information regarding the Oracle embedded JVM and how to use it, that is simply not available anywhere else.” — Avi Abrami, Senior Software Engineer, InterSystems “The first book to cover both Java and Oracle Database and the emerging concept of database Web services. This book provides a practical description of advanced database applications as well as code samples for data conversions, calling out to external Web components, EJB components, ERP frameworks, external databases, and Web services. The author also addresses server-side and client-side database programming.” — Oracle Magazine, April 2006