Professional Oracle 8i Application Programming with Java, PL/SQL and XML - Softcover

Michael Awai; Matthew Bortniker; John Carnell; Kelly Cox; Daniel O'Connor; Mario Zucca; Sean Dillon; Thomas Kyte; Ann Horton; Frank Hubeny; Glenn E. Mitchell II; Kevin Mukhar; Gary Nicol; Guy Ruth Hammond

Softcover

ISBN 10: 1861004842 ISBN 13: 9781861004840

Publisher: Apress, 2000

Synopsis

Oracle Corporation has broadened its development platform, integrating open standards such as Java and XML into the heart of the Oracle 8i database. This extended programming environment continues to exploit the qualities of scalability, reliability and efficiency of the world's most successful data management software, but at the same time it provides new challenges and opportunities to programmers.

This book shows you how to develop enterprise PL/SQL applications exploiting Java and XML, and how technologies such as EJBs can be moved to the 8i database. You'll work through case studies using a mix of both familiar and unfamiliar tools and languages, showing you how the various programming approaches can enhance each other.

About this title

Review

Suitable for any developer or manager who works on the Oracle platform, Professional Oracle 8i Application Programming with Java, PL/SQL, and XML is an excellent guide to the tools and programming techniques you'll need for successful enterprise development using today's Oracle.

Unless you buy an armful of books on current Oracle tools and technologies, you won't likely find as comprehensive a tour as this. First off, the authors are masters at using Oracle tools for high-end enterprise development, including PL/SQL (its proprietary SQL language) and Java. Developers and IT managers will appreciate the clear descriptions of relevant tools in the Oracle arsenal (including Developer and JDeveloper). Business Components for Java (BC4J), which simplify the use of Enterprise JavaBeans with Oracle databases and JSP, are also explained succinctly.

The emphasis is on server-side programming, with all features supported in Oracle, like stored procedures (and objects), written in both PL/SQL and Java. This book excels at showing the nitty-gritty details, with screen shots revealing the actual Oracle tools in action. As for using Enterprise JavaBeans, readers learn two possible methods: with standard EJB, and with BC4J components created with JDeveloper. A sample for a restaurant finder application will help you try your hand at using both approaches.

The discussion of Oracle's extensive XML support, which will be useful for taking advantage of this popular standard for real-world projects, is very strong. (Material on the emerging Simple Object Access Protocol (SOAP) and WML built with XML/XLST brings the book absolutely up to date.) A longer case study provides an ambitious example of enterprise Oracle at work. This Customer Relationship Management (CRM) system (with support for call centers) demonstrates a true n-tiered architecture built around Oracle.

For developers and IT managers alike, this authoritative tour on the best of the Oracle platform is really a must-have for anyone serious about development. It proves not only that Oracle is a great database platform, but also that it's ready to run the entire enterprise through powerful Internet and component-based tools. --Richard Dragan

Topics covered:

• History of Oracle
• Introduction to PL/SQL
• Overview of Oracle tools (including Forms, Reports, Portal, Designer, Oracle 8i, and JDeveloper)
• SQLJ and JavaServer Pages (JSP)
• Enterprise JavaBeans on the Oracle platform
• XML support in Oracle
• Enterprise Application Design (EAD) and n-tiered architectures on the Oracle platform
• Oracle database fundamentals (including data dictionaries, indices, and object/relational design)
• Oracle Net8 for scalability
• Designer 6i (case study for an online course-registration database)
• PL/SQL tutorial (including PL/SQL Server Pages and the Web Toolkit for Web programming)
• Case study for an online stock-tracker application
• Java stored procedures
• JDBC tutorial (including APIs, binary fields, connection pooling, and caching)
• SQLJ tutorial
• Introduction to EJB
• Oracle performance tuning
• Oracle Business Components for Java (BC4J)
• Case study for a discussion database using PL/SQL and Java
• Search engines with Oracle interMedia
• XML fundamentals and Oracle
• Case study for a Customer Relationship Management (CRM) enterprise system
• The Simple Object Access Protocol (SOAP)

From the Publisher

This book is for professional Oracle database programmers who need a comprehensive roadmap of the new programming possibilities with Oracle 8i. On the other hand, if you are already developing with Java and XML this book will show you how to exploit PL/SQL and the enterprise features of Oracle 8i in optimally distributing your n-tier applications. Knowledge of the essentials of PL/SQL programming is required, and familiarity with Java would be useful.

About this edition

• Publisher: Apress
• Publication date: 2000
• ISBN 10: 1861004842
• ISBN 13: 9781861004840
• Binding: Paperback
• Edition number: 1
• Number of pages: 1275