Java Oracle Database Development
Java Database Development with Oracle is a hands-on book for Java developers who want to learn how use Oracle and integrate it with their Java applications. It assumes an intermediate knowledge of Java and no knowledge of Oracle. This book is segmented into three parts. Part One begins by investigating how and why databases relate to object-oriented programming with Java. Introductory chapters on the Oracle database, SQL and other Oracle features, including its object-relational support, lay the groundwork for the chapters that follow. Part Two presents thorough coverage of the essential Java technologies for database programming, with chapters on SQLJ, JDBC and JDO (Java Data Objects). Part Three takes a higher-level view of application architecture and considers the role of Oracle in enterprise applications, particularly with regard to EJB (Enterprise Java Beans) and the J2EE framework.
- Paperback | 420 pages
- 191 x 277.9 x 30.7mm | 834.62g
- 30 Dec 2002
- Pearson Education (US)
- Prentice Hall
- Upper Saddle River, United States
Table of contents
Preface. 1. Java, Databases, and Oracle. The Right Tool at the Right Time. Types of Databases. Oracle and Java.2. Database Design Essentials. Tables, Columns, and Rows. Oracle Datatypes. Designing a Database.3. SQL Essentials. Data Definition Language. Data Manipulation Language. SQL Functions. Transactions.4. More SQL: Queries, Subqueries, and Views. Aggregate Functions, GROUP BY and HAVING. Putting Data in Order. Combining Data from Different Tables. Subqueries. Views.5. PL/SQL. Getting Started with PL/SQL. Basic PL/SQL Language Elements. Program Elements. Java Stored Procedures.6. Oracle Object-Relational Features. Object Types. Inheritance and Object Evolution in Oracle 9i.7. SQLJ. SQLJ Statements and the SQLJ Translator.8. Introduction to JDBC. Connecting to the Database. Executing SQL Statements. Executing SQL Queries. Large Objects-BLOBs and CLOBs.9. Advanced JDBC Features. Connection Options. JDBC Driver Types. Using DataSource Instead of DriverManager. Scrollable, Sensitive, Updateable ResultSets. RowSets. Using Oracle Object-Relational Features with JDBC.10. Introduction to J2EE and Persistence. A J2EE Overview. Designing a J2EE Application. The Oracle Containers for J2EE, OC4J. Deploying the Web Application. EJBs and Web Applications.11. A Quick Tour of EJB. The EJB Distributed Object Model. Introduction to Bean Building: A Stateless Session Bean. Debugging with Jdeveloper. Packaging and Deploying the EJB-Overview. Session Beans, Value Objects, and Data Access Objects. A Bean-Managed Persistent Entity Bean. The Sample Client Application.12. Object-Relational Mapping and Java Data Objects. Java Data Objects. Class Relationships and Persistence.Index.
About David Gallardo
David Gallardo is an independent software consultant and author with extensive experience in database development, software internationalization, and Java web application development. He has been a professional software engineer for over fifteen years and has experience with many operating systems, programming languages and network protocols. His recent experience includes leading database and internationalization development at a business-to-business e-commerce company where he designed and led the implementation of an object-relational mapping interface for Java and Oracle, using JDBC, SQL and Java stored procedures, for a large Web-based application.