Oracle Database Programming using Java and Web Services [Abridged] [Paperback]

Kuassi Mensah (Author)

Book Description

ISBN-10: 1555583296 | ISBN-13: 978-1555583293 | Publication Date: August 19, 2005 | Edition: 1

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.

Editorial Reviews

Review

"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

Book Description

All you need to know to use Java and Webservice to manage the Oracle Database 10g R2

See all Editorial Reviews

Product Details

• Paperback: 1120 pages
• Publisher: Digital Press; 1 edition (August 19, 2005)
• Language: English
• ISBN-10: 1555583296
• ISBN-13: 978-1555583293
• Product Dimensions: 9.2 x 7.5 x 1.6 inches
• Shipping Weight: 4.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.1 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #177,748 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

8 of 9 people found the following review helpful:

5.0 out of 5 stars A complete book for today's developer, July 31, 2006

By 

Kevin Katz (Seattle, Wa) - See all my reviews

This review is from: Oracle Database Programming using Java and Web Services (Paperback)

I have been working on different projects building enterprise level software involving many J2EE and Database technologies. One of the major frustration facing developers is how "practical information" related to these two worlds are completely isolated from one another, in fact, it is very common to see the majority of today's developers specializing in one of them and completely ignoring the other. The few who actually can keep following up with both can understand and achieve a lot more.
I found the information in this book to be complete; it describes the notions, the architectures (even those details that are hard to find anywhere) and it gives detailed examples on how it will look like in the code which cuts learning time for engineers a lot.

5 of 5 people found the following review helpful:

3.0 out of 5 stars Rating the Reviewers, September 22, 2009

By 

Thomas B. Adam "Bibliophile" (Cooper City, Florida USA) - See all my reviews
(REAL NAME)   

This review is from: Oracle Database Programming using Java and Web Services (Paperback)

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.

4 of 4 people found the following review helpful:

5.0 out of 5 stars For Java programmers looking to exploit Oracle, indeed!, January 7, 2007

By 

Theodule Desouza "Theodule Desouza" (San ramon, CA) - See all my reviews
(REAL NAME)   

This review is from: Oracle Database Programming using Java and Web Services (Paperback)

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.