Professional Oracle 8i Application Programming with Java, PL/SQL and XML
May 4, 2010 by BPELforum · 5 Comments
- ISBN13: 9781861004840
- Condition: USED – VERY GOOD
- Notes:
Product Description
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. Amazon.com 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)
Professional Oracle 8i Application Programming with Java, PL/SQL and XML















There has never been a Oracle book like this one that demostrates so much detail about Oracle 8i internet development feature with Java and XML. If you want to stay ahead of your peer, you can’t afford to miss this book.
Rating: 5 / 5
Good book, but goes more detail into
tools provided by Oracle. If you will be using
only oracle tools, this is a good book.
Rating: 3 / 5
This book is one of the more comprehensive I have read about Oracle programming. It has very good examples and you will find tips and information you won’t find in any other books/web sites/forums etc. This book has been written by genuine Oracle developers and you will get a depth of real-world knowledge and application. I recommend highly it for the serious Oracle, Java and XML developer.
Rating: 5 / 5
The best thing that can be said about this book is it’s a confused ramble though Oracle. The book tries to cover Java, PL/SQL and XML, and fails to cover any depth in any of these subjects.
Rating: 1 / 5
One of the best books around for database application developers working with Java/XML on the Oracle platform and who don’t nowadays! The book is up-to-date with Oracle 8.1.7 and covers new aspect such as JDBC2.0 and the Java to native compiler (NCOMP). I give it five stars because it covers all important Java/XML aspects in great detail and because it already proved its worth by providing me with solutions for really tricky problems. The only neagtive thing I can think of is its size. But I guess the American authors probably got paid per line.
Rating: 5 / 5