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.

* 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.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 8 Ratings

For Java programmers looking to exploit Oracle, indeed! - 2007-01-07
Reviewer Rating:
I've been programming in C++, Corba and Java for years and was looking for a book to develop agaisnt the Oracle database. First of all this book is well written and at a glance, it covers all the API and utilities that a Java developer may use to exploit the Oracle database including Java in the database, JDBC, SQLJ, JPublisher and Database Web services ( Corba folks like myself will love the Web services part). You will be amazed reading through this book all the possibilities that Java in the database allows ; the Groovy and Jython stored procedures are just well presented. I am right now digging into Part-II dedicated to JDBC, the Rowset API, RAC support, etc. This book will provide great career advancement opportunities. I strongly recommend this book to my Java developers fellows.

Outstanding - 2007-06-08
Reviewer Rating:
I've been doing Oracle database-related application design and development since before Java even existed. As time progressed, Java became more and more prevalent in the Enterprise environment, web servers became application servers, and before you knew it, Java was being run right in the database.

It has always been difficult and confusing to figure out the various Java technologies and tools and implementations when it comes to a complete Enterprise system... until now.

Kuassi does a remarkable job of providing keen and detailed insight into all aspects of Java in the Oracle Database realm.

A nice, logical technical progression as well as very detailed code samples make this book useful for those wishing to introduce themselves to the basic concepts, or write a specific implementation.

The detailed case studies that show real code used in real world solutions are invaluable. (We've already implemented one of them for a new project we're starting on!)

All in all, it's an excellent book and should be on the shelf of any DBA/Developer that has anything to do with Java in their environment.

Rating the Reviewers - 2009-09-22
Reviewer Rating:
I have read all the Amazon reviews for this book, which I have purchased, but not yet completed reading. In brief, its content is excellent, but its English is weak and nonstandard.

It is noteworthy that all of the Amazon 5* reviews employ broken, marginal English, while those of less than 5* rating, save for this one, employ readable English.

This book is worth buying only if your tolerance of Third World English is high. Frankly, it reflects (not represents) the current state of the IT profession. Walk into most IT shops and written English capability is at 3rd, 4th grade level. Once upon a time, badly formulated English was verboten in professional ranks. Now, it is normal. Once upon a time, badly formulated English was absolutely verboten in publication ranks. Now, even publishers bastardize English, and think nothing of it. A sorry state of affairs.

Credit to the author for a book with valuable content. Zero credit to the publisher for complete negligence in failing to edit.

Needs complete revision - 2008-08-23
Reviewer Rating:
I have 2 bookcases filled with computer science and engineering texts. This is by far the worst of all of them... as far as the writing is concerned. The grammar is horrible. Obviously no spell check was used. Some books require reading sections a couple of times, just because the concepts are difficult to grasp. This book requires re-reading of sections just because the wording is so poor, despite the concepts being fairly straight-forward. On the positive side, the book presents lots of useful ideas and practical examples.

Nice but Incomplete - 2007-06-01
Reviewer Rating:
This book has a good deal of information that is accessible. However, several coding examples are incomplete and in some cases misleading. Given the strengths of the book, they are probably oversights or space limitations. The missing code segments are too frequently in the wrong places.

The code examples predominate the book. Hidden gems are nested where readers only find them searching out topics. On a bright note, the index is good at locating what is in the book.

Browse Similar Topics

Top Level Categories:
Databases
Programming

Sub-Categories:
Databases > Oracle
Oracle > Programming
Programming > Java
Java > Web Services