Database Programming with JDBC and Java
Average customer rating: 3 out of 5 stars
  • More sales pitch than substance
  • Excellent book on JDBC and multitier development
  • A Book without a Country
  • Hard to read, little pay-off
  • Not enough meat
Database Programming with JDBC and Java
George Reese
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback

GeneralGeneral | Java | Programming | Computers & Internet | Subjects | Books
GeneralGeneral | Programming | Computers & Internet | Subjects | Books
Database DesignDatabase Design | Databases | Computers & Internet | Subjects | Books
GeneralGeneral | Databases | Computers & Internet | Subjects | Books
Java & DatabasesJava & Databases | Databases | Computers & Internet | Subjects | Books
GeneralGeneral | Computers & Internet | Subjects | Books
GeneralGeneral | Software | Computers & Internet | Subjects | Books
JavaJava | Programming | O'Reilly | By Publisher | Books
GeneralGeneral | Programming | O'Reilly | By Publisher | Books
Look Inside Computer BooksLook Inside Computer Books | Trip | Specialty Stores | Books
All TitlesAll Titles | Qualifying Textbooks - Fall 2007 | Stores | Books
Computers & InternetComputers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:
  1. Java Database Best Practices Java Database Best Practices
  2. Java Servlet Programming, 2nd Edition Java Servlet Programming, 2nd Edition
  3. JavaServer Pages, 3rd Edition JavaServer Pages, 3rd Edition
  4. Enterprise JavaBeans Enterprise JavaBeans
  5. Hardcore Java Hardcore Java

ASIN: 1565926161

Amazon.com

The Java Database Connectivity classes (JDBC) sensibly provide an interface between a platform-independent programming language (Java) and a standardized database language (Structured Query Language, or SQL). Pretty much every Java program that's involved in transactions or other business operations connects to a database through JDBC; so, familiarity with the JDBC classes can magnify your other Java skills. Database Programming with JDBC and Java explains how JDBC fits into unitized software applications in which various functional parts communicate over a network. Author George Reese also shows how to write programs that take advantage of the JDBC classes, emphasizing the most commonly used ones (such as those that perform INSERT and SELECT operations), but giving also the more obscure classes their due.

This book is essentially an ongoing lecture of increasing complexity. To cite one thread, it begins with clear but academic examples that involve discrete transactions (opening a connection, performing a query, and closing the connection). It then moves on to connection pooling and other JDBC-supported optimizations for the real world. A menagerie of specialized sections on such topics as security and persistence rely heavily on long code examples. A section on Swing programming seems kind of out of place, but it's short. In sum, this slim volume is a great introduction to JDBC for those who are looking to approach Java distributed applications by way of database work.

Punk music fans, however, will object to the misidentification of the Sex Pistols' classic album Never Mind the Bollocks, Here's the Sex Pistols. It's actually Never Mind the Bullocks, Here Come the Sex Pistols. Rotten fact-checking, obviously. --David Wall

Topics covered: The Java Database Connectivity (JDBC) classes, with emphasis on how JDBC code fits into distributed applications (so-called enterprise applications) that use Enterprise JavaBeans (EJBs) and Remote Method Invocation (RMI). Java Naming and Directory Interface (JNDI), serialization, persistence, security, and (especially) application design receive plenty of attention. Fully a quarter of this book is a reference (including statements of syntax and brief descriptions) to the JDBC Core API and the JDBC Optional Package classes.

Book Description

Java and databases make a powerful combination. Getting the two sides to work together, however, takes some effort--largely because Java deals in objects while most databases do not.

This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to maintain. It introduces the JDBC and RMI packages and uses them to develop three-tier applications (applications divided into a user interface, an object-oriented logic component, and an information store).

The book begins with a quick overview of SQL for developers who may be asked to handle a database for the first time. It then explains how to issue database queries and updates through SQL and JDBC. It also covers the use of stored procedures and other measures to improve efficiency, where these are available.

But the book's key contribution is a set of patterns that let developers isolate critical tasks like object creation, information storage and retrieval, and the committing or aborting of transactions.

The second edition includes more basics of JDBC and SQL, with more examples, and a deeper discussion about the architecture of a robust, maintainable database application. The second edition also explains the relationship between JDBC and Enterprise JavaBeans.

Customer Reviews:

2 out of 5 stars More sales pitch than substance.......2005-08-06


Database Programming with JDBC and Java
By George Reese
Published by O'Reilly
ISBN 1565926161
Reviewed by Larry Hess-HuNTUG member

This book is more of a sales pitch for Java Database Connectivity (JDBC) than anything else. The first 3 chapter keep trying to sell the reader on why you should use JDBC not how to use it as the title indicates. Maybe if I was a Java program I would have gotten more out of the book also I like to get to the meat of a function I don't need to be sold. I believe the function should sell itself if it works. Another problem with the book is, it is limited to only examples in C#, and I think examples should be in both C and VB.Net to ensure helping more programmers.

After the slow start and the limited examples the book did a good job explaining how JDBC would work. I found the chapter 10 The User Interface was the best read and most important to me. Overall the book went into detail on how to use JDBC and I think if I was a C programmer I would have gotten more out of the book.

For a non-java programmer the book is hard to read and understand and limiting the samples to C# also limits the readers understanding. To the authors credit he does state: "If .... have studied JAVA, this book will help you become a more effective application developer for JAVA database programs."

I would give this book a rating of 2 out of 5.



5 out of 5 stars Excellent book on JDBC and multitier development.......2004-07-11

The text covers JDBC with enough depth, without burdening the reader with useless details available in any reference (in fact the reference is attached in an appendix, so there is no need to go looking online). Unlike other books it doesn't bore the reader with introduction to obvious concepts and examples. I highly recommend this for experienced professionals who need to understand and start using JDBC.
The book also gives a great in-depth explanation of multitier applications and some aspects of EJB. The author develops a framework which can be used both as EJB replacement for simple projects or as a explanation for how EJB operates.
In a word, great read, even four years after it was published.

2 out of 5 stars A Book without a Country.......2003-08-23

This book starts strong, clearly elucidating the simple mechanics behind opening database connections and controling content updates through sql statements. It quickly drifts into something of a rambling however as the author attempts to cover too much ground in too short a span. Reese jumps from a slow introduction to JDBC and a gentle explanation of how to integrate database calls into simple applications to a mess of complex design patterns and ugly (I mean UGLY... where are his editors) code almost completely bereft of any helpful comments.

It almost seems as if the author started with the noble idea of advancing both the basic and more extensible uses of the API and then gets bored (or drunk) half-way through. The book just drops off a cliff when it gets to the 7th chapter.

The biggest crime however is that the text only devots a cursory page and a half to the high subject of Connection Pooling despite declaring (correctly) that it is absolutely essential to any successful JDBC deployment. Where does the author suggest we find information related to this topic, in a book dedicated to the discussion of Swing??

Look elsewhere... this text is under-edited, under-written and over-priced for the amount of useful information it contains; terribly dissapointing!

2 out of 5 stars Hard to read, little pay-off.......2002-10-17

I'm a Java Certified Programmer for the Java 2 Platform. I bought this book to begin learning additional APIs. The preface claimed that only a basic knowledge of Java and some understanding of SQL was required. The book was not as advertised. Yes, the book did cover basic and advanced JDBC in two very short chapters, and provided a summary of the features of JDBC Optional Package without giving any details in a third. After reading these chapters I feel I have had an introduction to the subject, but no real depth.

The rest of the book takes off into very difficult Java topics (RMI, JNDI, EJB, Java Patterns, Distributed Architectures, Persistence, Swing...)proportedly to demonstrate how JDBC is used in the "real world." From time to time I was actually able to understand some of it, most of the time not. The author did not provide a high level introduction to these topics, which I would have found useful. Rather, the author jumped into the bowels of these subjects in a page or two. The language the author uses is often very exacting such as one might expect to find in a specification. The exacting language and limited number of illustrations caused me to have to re-read many sections several times often to remain confused.

The majority of this book was way too ambitious for someone with the background the Prefaces the reader should have. This book may be very useful for a reader with a more advanced background. After I have read several other books covering the "unadvertised-bonus" topics which comprise most of this book more slowly, I will try to read it again.

1 out of 5 stars Not enough meat.......2002-09-15

The first section of the book provided a rapid overview of using JDBC. Many topics, such as establishing the actual database connection (a relatively obscure process as every database vendor writes their JDBC connection class differently) were skimmed over without nearly enough detail. It was useful enough to get a start using JDBC, but little else.

The second part of the book was called "Applied JDBC". I don't think so. The examples were weak and poorly explained. Part of the reason I bought the book was it claimed it detailed "Developing Multi-Tier Applications". There were 5 pages on a writing a 3 tier application. The text only covered enough of each topic to leave you scratching your head wondering about the actual details.

The last section was a reference to JDBC APIs, which you could find online. Most likely already out of date and obviously a filler to turn what should have been a 100 page book into a 300 page book.

Usually I swear by O'Reilly books, but it was hard to justify the expenditure for this one.
Java Programming with Oracle JDBC
Average customer rating: 3.5 out of 5 stars
  • Well written, but out of date
  • A workmanlike book which achieves its aims
  • Not bad, but....
  • average book
  • Only covers Oracle8i, not 9i
Java Programming with Oracle JDBC
Donald Bales
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback

GeneralGeneral | Java | Programming | Computers & Internet | Subjects | Books
GeneralGeneral | Programming | Computers & Internet | Subjects | Books
GeneralGeneral | SQL | Databases | Computers & Internet | Subjects | Books
Database DesignDatabase Design | Databases | Computers & Internet | Subjects | Books
Database Management SystemsDatabase Management Systems | Databases | Computers & Internet | Subjects | Books
GeneralGeneral | Oracle | Databases | Computers & Internet | Subjects | Books
GeneralGeneral | Databases | Computers & Internet | Subjects | Books
Java & DatabasesJava & Databases | Databases | Computers & Internet | Subjects | Books
GeneralGeneral | Programming | Web Development | Computers & Internet | Subjects | Books
GeneralGeneral | Computers & Internet | Subjects | Books
GeneralGeneral | Software | Computers & Internet | Subjects | Books
MathematicsMathematics | Professional Science | Professional & Technical | Subjects | Books | Applied | Chaos & Systems | Geometry & Topology | Mathematical Analysis | Mathematical Physics | Number Systems | Pure Mathematics | Transformations | Trigonometry
JavaJava | Programming | O'Reilly | By Publisher | Books
Web ProgrammingWeb Programming | Programming | O'Reilly | By Publisher | Books
GeneralGeneral | Programming | O'Reilly | By Publisher | Books
Oracle & Database ProgrammingOracle & Database Programming | Programming | O'Reilly | By Publisher | Books
Look Inside Computer BooksLook Inside Computer Books | Trip | Specialty Stores | Books
All TitlesAll Titles | Qualifying Textbooks - Fall 2007 | Stores | Books
Computers & InternetComputers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books
ProfessionalProfessional | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:
  1. Inside Servlets: Server-Side Programming for the Java(TM) Platform (2nd Edition) Inside Servlets: Server-Side Programming for the Java(TM) Platform (2nd Edition)
  2. Database Programming With Jdbc and Java Database Programming With Jdbc and Java
  3. JavaTM Programming with CORBATM : Advanced Techniques for Building Distributed Applications JavaTM Programming with CORBATM : Advanced Techniques for Building Distributed Applications
  4. Oracle PL/SQL Programming, 4th Edition Oracle PL/SQL Programming, 4th Edition
  5. Java Database Best Practices Java Database Best Practices

ASIN: 059600088X

Book Description

JDBC is the key Java technology for relational database access. Oracle is arguably the most widely used relational database platform in the world. In this book, Donald Bales brings these two technologies together, and shows you how to leverage the full power of Oracle's implementation of JDBC.

You begin by learning the all-important mysteries of establishing database connections. This can be one of the most frustrating areas for programmers new to JDBC, and Donald covers it well with detailed information and examples showing how to make database connections from applications, applets, Servlets, and even from Java programs running within the database itself.

Next comes thorough coverage of JDBC's relational SQL features. You'll learn how to issue SQL statements and get results back from the database, how to read and write data from large, streaming data types such as BLOBs, CLOBs, and BFILEs, and you'll learn how to interface with Oracle's other built-in programming language, PL/SQL.

If you're taking advantage of the Oracle's relatively new ability to create object tables and column objects based on user-defined datatypes, you'll be pleased with Don's thorough treatment of this subject. Don shows you how to use JPublisher and JDBC to work seamlessly with Oracle database objects from within Java programs. You'll also learn how to access nested tables and arrays using JDBC.

Donald concludes the book with a discussion of transaction management, locking, concurrency, and performance--topics that every professional JDBC programmer must be familiar with. If you write Java programs to run against an Oracle database, this book is a must-have.

Customer Reviews:

2 out of 5 stars Well written, but out of date.......2004-01-31

Let me start by saying that had I purchased this book 2 years ago when it was first released, I would have given it 5 stars.

This is a very well-written book, with good explanations and sample code. However, the book is fairly out of date, and much of the performance tuning suggestions he makes don't really apply as much when using the latest Oracle JDBC drivers and Oracle9 database. This book covers Oracle 8.1.6, and a lot of changes have been made between that release and 8.1.7 and Oracle9.

I recommend the newer "Oracle 9i JDBC Programming" book by Jason Price for much more current coverage of this topic.

5 out of 5 stars A workmanlike book which achieves its aims.......2003-09-12

This book is for Java developers who need to get the most out of using JDBC and Oracle (version 8.1.6). Choosing a specific database allows a lot more detail. Other JDBC books may skip database-dependent parts of the API; this book even gives code examples for the hard stuff. It is slow to read end-to-end, but "dipping" works well - there's almost always a helpful code example nearby.

There are problems, though. The author is obviously very familiar with Oracle, but lacks the experience to make comparisons with other products, this book won't help you choose when to use Oracle or whan another system might be more appropriate. Also I noticed other signs of lack of research - he sometimes gets abbreviations wrong, and the Java code is not particularly well-written.

The big problem for me is that the book assumes you only ever use Oracle. There is no consideration of code portability, it offers no wisdom about avoiding or encapsulating proprietary Oracle-specific extensions. The techniques in this book could easily lock your product into Oracle, worse, they might even lock your product into a specific version of Oracle.

The book has minor discussion of extra features in Oracle8i and Oracle9i, but nothing about JDBC 3. It's less helpful if you are using a version older than 8.1.6, too.

If you (or your management) have already sold your soul to Oracle, get this book. If you might need to use other databases, get a more generic book, but keep this one for those times when only a specific Oracle feature will do the trick.

2 out of 5 stars Not bad, but...........2003-08-25

This book gives good coverage of Oracle's JDBC implementation. That is about as far as it goes. This is just too close to being documentation. When purchasing books on a specific technology, I am looking for the author's insight. Specific things the author learned while working with it. Give me best practices, suggestions, things to avoid, etc. Tell me what I won't learn from Oracle's docs, don't just rewrite them.

1 out of 5 stars average book.......2003-04-25

Looks like most of the material came from oracle documentation. Examples are very basic

1 out of 5 stars Only covers Oracle8i, not 9i.......2003-01-24

I felt a bit cheated buying this book as it doesn't cover Oracle9i. It only covers 8i programming.
Jdbc Database Access With Java: A Tutorial and Annotated Reference (Java Series)
Average customer rating: 4 out of 5 stars
  • Time Tested
  • sasa
  • good coverage, not much depth.
  • Excellent book for anyone who wants to learn JDBC and more
  • Very good book for Database Programming using Java
Jdbc Database Access With Java: A Tutorial and Annotated Reference (Java Series)
Graham Hamilton , Rick Cattell , and Maydene Fisher
Manufacturer: Addison Wesley Publishing Company
ProductGroup: Book
Binding: Paperback

GeneralGeneral | Java | Programming | Computers & Internet | Subjects | Books
ReferenceReference | Java | Programming | Computers & Internet | Subjects | Books
GeneralGeneral | Programming | Computers & Internet | Subjects | Books
GeneralGeneral | Languages & Tools | Programming | Computers & Internet | Subjects | Books
DatabasesDatabases | Software | Computers & Internet | Subjects | Books
GeneralGeneral | Software | Computers & Internet | Subjects | Books
GeneralGeneral | Computers & Internet | Subjects | Books
GeneralGeneral | Databases | Computers & Internet | Subjects | Books
Java & DatabasesJava & Databases | Databases | Computers & Internet | Subjects | Books
MathematicsMathematics | Professional Science | Professional & Technical | Subjects | Books | Applied | Chaos & Systems | Geometry & Topology | Mathematical Analysis | Mathematical Physics | Number Systems | Pure Mathematics | Transformations | Trigonometry
Look Inside Computer BooksLook Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:
  1. Java Database Best Practices Java Database Best Practices
  2. Database Programming With Jdbc and Java Database Programming With Jdbc and Java
  3. CSS Mastery: Advanced Web Standards Solutions CSS Mastery: Advanced Web Standards Solutions
  4. SCJP Sun Certified Programmer for Java 5 Study Guide (Exam 310-055) (Certification Press Study Guides) SCJP Sun Certified Programmer for Java 5 Study Guide (Exam 310-055) (Certification Press Study Guides)
  5. Head First Java, 2nd Edition Head First Java, 2nd Edition

ASIN: 0201309955

Amazon.com

Although Java is touted for its simplicity, it also has its thornier sides, and Java Database Connectivity (JDBC)--Java's database class library--is certainly one of them. Thankfully, the creators of the JDBC specification at Sun Microsystems have brought out JDBC Database Access with Java, an authoritative guide to basic and advanced topics in JDBC. Though the book suffers from a bland writing style, it does include some indispensable information. The guide begins with a basic tutorial on Structured Query Language (SQL) and teaches the rudiments of using Java as a programming language. It then provides instructions for performing basic database operations in JDBC, from simple topics such as joins, updates, and queries with result sets to more advanced topics such as transactions and stored procedures. The section on how to use MetaData classes, which allow programmers to read and manipulate table structures, is quite valuable. In addition, all basic database problems include short sample code.

The second half of JDBC Database Access with Java contains a useful reference to the dozen-and-a-half classes in the JDBC library. Each section provides a general overview of the class and a guide to all APIs. This portion of the book also includes a guide to data types in JDBC and all of today's major SQL server platforms. The final chapter recounts how the JDBC specification was created. Appendices offer short tips for developers who are writing JDBC drivers (who will absolutely want this book on their shelves). Although most Java developers will want to write to a higher level of classes, those new solutions will rely on JDBC, an effective tool for writing database-independent code in Java.

Customer Reviews:

5 out of 5 stars Time Tested .......2006-07-25

I bought my copy of "JDBC Database Access with Java" in the fall of 1999. It's sitting next to me on my desk here at work as I write these words. The right side is choked with Postit page markers that get me back to my most frequently referenced pages quickly. The binding has finally worn out within a part of the DatabaseMetaData section - and some of the pages are loose there. I have relied on this book for the past seven years of Java SQL database programming like no other. That's not to say that I don't have others. I just don't use them. The organization and writing style of this book fits my needs perfectly. I happen to be here today to check to see whether there has been an update to this wonderful reference. Nope. Apparently they got it right the first time back in 1997.

If you're looking for a reference book that will enable you to expand your Java capability to JDBC (or to expand your JDBC capability to using all of it) - this is the one. Not too terse. Not too wordy. It covers everything from initial access to database reflection. It has just enough examples to show you how to use JDBC without over-burdening you with code. The index is terrific for quick lookups. Postit notes stick reliably to the pages for many years. A real gem.

5 out of 5 stars sasa.......1999-04-01

sas

3 out of 5 stars good coverage, not much depth........1998-09-13

I am an experienced Java programmer who bought this book in the middle of implementing a JDBC based application. After staring at the opaque JDBC documentation from Sun, I hoped to find in this book an in depth examination of design and performance issues. The examples here do not go very far. My feeling is that this book covers the subject adequately, but in the end it is not a very complex subject. The hard issues are often implementation specific, and I suppose an in depth look at the details of conformance and performance is not really possible in a book format (e.g. which databases require that resultsets read every column and only once). Now I wish I had purchased a more general book with one good chapter on JDBC, though I do appreciate the reference section in the back and still refer to it.

5 out of 5 stars Excellent book for anyone who wants to learn JDBC and more.......1998-07-28

This book is well-written and has examples on using the SQL select, insert, delete and update commands. In addition, the topics on metadata is thorough. This is the best of the bunch, you won't be disappointed. It covers everything about database transactions - stored procedures, rollbacks and more.

4 out of 5 stars Very good book for Database Programming using Java.......1998-07-16

Excellent book for starters in either Java/DB. Can be used by expert prorammers to write their own APIs. My favorite in this book is metadata explanation. A must reference for everyone whose working with JAVA/JDBC.
Professional Oracle 8i Application Programming with Java, PL/SQL and XML
Average customer rating: 4 out of 5 stars
  • Confused ramble though Oracle
  • From Stem to Stern
  • Good book but not for beginner
  • A tour of Oracle technologies
  • Excellent Book.
Professional Oracle 8i Application Programming with Java, PL/SQL and XML
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 , and Guy Ruth Hammond
Manufacturer: Wrox Press
ProductGroup: Book
Binding: Paperback

GeneralGeneral | Java | Programming | Computers & Internet | Subjects | Books
XMLXML | Languages & Tools | Programming | Computers & Internet | Subjects | Books
GeneralGeneral | Programming | Computers & Internet | Subjects | Books
GeneralGeneral | SQL | Databases | Computers & Internet | Subjects | Books
Database Management SystemsDatabase Management Systems | Databases | Computers & Internet | Subjects | Books
GeneralGeneral | Oracle | Databases | Computers & Internet | Subjects | Books
PL & SQLPL & SQL | Oracle | Databases | Computers & Internet | Subjects | Books
GeneralGeneral | Databases | Computers & Internet | Subjects | Books
GeneralGeneral | Computers & Internet | Subjects | Books
GeneralGeneral | Operating Systems | Computers & Internet | Subjects | Books
GeneralGeneral | Software | Computers & Internet | Subjects | Books
MathematicsMathematics | Professional Science | Professional & Technical | Subjects | Books | Applied | Chaos & Systems | Geometry & Topology | Mathematical Analysis | Mathematical Physics | Number Systems | Pure Mathematics | Transformations | Trigonometry
Similar Items:
  1. Oracle 9i Java Programming: Solutions for Developers Using PL/SQL and Java Oracle 9i Java Programming: Solutions for Developers Using PL/SQL and Java
  2. Expert Oracle, Signature Edition Programming Techniques and Solutions for Oracle 7.3 through 8.1.7 (Expert One-On-One) Expert Oracle, Signature Edition Programming Techniques and Solutions for Oracle 7.3 through 8.1.7 (Expert One-On-One)

ASIN: 1861004842

Amazon.com

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:

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

Customer Reviews:

1 out of 5 stars Confused ramble though Oracle.......2003-01-24

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.

5 out of 5 stars From Stem to Stern.......2002-05-16

Some other reviewers have stated that this book is uneven in quality. I agree with that assessment but argue that is unavoidable. I cannot think of any one person who possesses the knowledge to write intelligently about all of this material in the depth this book has.

In a few areas it is dated (obviously 9i is out NOW, but wasn't when this book was published), but it is still overall extremely valuable. I have had my copy for about a year now and have read it almost completely once (you can't read a 1200 page tech book cover to cover) and have referred to it in a pinch more times than I can remember.

In short, a must have for any serious Oracle developer.

3 out of 5 stars Good book but not for beginner.......2002-03-16

Good book, but goes more detail into
tools provided by Oracle. If you will be using
only oracle tools, this is a good book.

5 out of 5 stars A tour of Oracle technologies.......2002-01-17

To produce this book, Wrox took twenty expert Oracle developers and had each of them write about their area of expertise. The result is that whether you are a manager, a developer, or a DBA, if you are working with Oracle 8i this book should be on your desk. This book covers virtually every topic that you need to understand about the Oracle 8i development platform. It does not cover each topic completely but it provides a thorough and in most cases sufficient introduction on each topic. For a particular topic of interest you may need an additional book but to get all the information found in this book you would need ten volumes at least. The book opens with an introduction to Oracle 8i and some of its components including Net8 (Oracle's network solution) and Designer 6i (Oracle's development environment). The next section covers PL/SQL and PSP (this is similar to JSP). This is followed by an extensive section covering Java. This section covers JDBC, SQLJ, EJB, and interMedia (Oracle's powerful search tool). The last section covers XML and includes information on DOM and SAX parsers, SOAP, XSL, XSQL, and more. Extensive case studies are scattered throughout the book. Examples show how to use Oracle tools such as BC4J to develop enterprise applications. The book even includes primers on Java and XML. As a tour of all the features of Oracle 8i, this book is without competition.

5 out of 5 stars Excellent Book........2002-01-08

This is an excellent book as it covers a lot of ground in one volume. If you work in a organisation that has Oracle as the engine for their web based applications, you must have this book.
Many books cover Java or XML or SQL and the like; but this is one of the few books that delves into HOW to put all of these together to make it work! As this book is released in newer additions, I shall be buying it as soon as it is available.
Java Database Programming with JDBC: Discover the Essentials for Developing Databases for Internet and Intranet Applications
Average customer rating: 2.5 out of 5 stars
  • Great Book!
  • 2ND Edition repeats mistakes of the first
  • Please don't buy this book
  • Good at JDBC driver developing only
  • poor book
Java Database Programming with JDBC: Discover the Essentials for Developing Databases for Internet and Intranet Applications
Pratik Patel , and Karl Moss
Manufacturer: Coriolis Group Books
ProductGroup: Book
Binding: Paperback

GeneralGeneral | Java | Programming | Computers & Internet | Subjects | Books
Software DevelopmentSoftware Development | Software Design, Testing & Engineering | Programming | Computers & Internet | Subjects | Books
Structured DesignStructured Design | Software Design, Testing & Engineering | Programming | Computers & Internet | Subjects | Books
GeneralGeneral | Programming | Computers & Internet | Subjects | Books
GeneralGeneral | Languages & Tools | Programming | Computers & Internet | Subjects | Books
Intranets & ExtranetsIntranets & Extranets | Networking | Computers & Internet | Subjects | Books
Database DesignDatabase Design | Databases | Computers & Internet | Subjects | Books
GeneralGeneral | Databases | Computers & Internet | Subjects | Books
GeneralGeneral | Computers & Internet | Subjects | Books
GeneralGeneral | Software | Computers & Internet | Subjects | Books
MathematicsMathematics | Professional Science | Professional & Technical | Subjects | Books | Applied | Chaos & Systems | Geometry & Topology | Mathematical Analysis | Mathematical Physics | Number Systems | Pure Mathematics | Transformations | Trigonometry
ASIN: 1576100561

Amazon.com

Java Database Programming with JDBC by Pratik Patel and Karl Moss is an updated edition of the authors' guide to the Java Database Connectivity (JDBC) standard for database programming under Java. While the original edition was perhaps geared more to those developers who needed to write their own JDBC database drivers, a fairly arduous task, this new edition provides more background information on database connectivity issues in Java and so will be even more useful to the casual or intermediate programmer. After a general introduction to JDBC and Structured Query Language (SQL), useful even to beginning programmers, the authors start by building a simple database-aware applet. New chapters on "servlets," Java components that run on the server-side and manage database operations, as well as a general discussion of middleware technologies are particularly good. Database access for JavaBean components (from Sun Microsystems JDK 1.1) is also discussed, including working code for two database-aware beans. This book also includes a quick introduction to the Java language (which will only be helpful if you already know C/C++), a detailed reference for the JDBC API, and a working example of a text-based JDBC driver. Though this book is still oriented toward the JDBC driver developer, the authors now provide enough general discussion of JDBC architectural issues to make it worthwhile to any programmer who needs to ramp up on what JDBC is and what capabilities it offers.

Book Description

Teaches you how to develop Java programs, from start to finish, for connecting to databases using Java's new database connectivity environment, JDBC. Tells how to easily install drivers for most databases. Features a section on programming ODBC Java programs, including a robust ODBC client template for developing your own applications. Features a handy, ready-to-use Interactive SQL query client, including fully-explained and annotated source code. Teaches how to write your own database drivers for the JDBC. Reveals how to optimize your Java database programs for maximum efficiency and minimum time.

Customer Reviews:

5 out of 5 stars Great Book!.......2001-04-02

I found this book to be really good and it gives a great overview of Java programming with JDBC. This book really has a lot of condensed material, and quickly covers a lot of areas. I was able to use the first application right off the bat to connect to a PostgreSQL database and do some simple queries. There is a lot to RDBMS accessed through JDBC, so I would suggest that readers prepare to review web servers, TCP/IP ports and client web browser java security problems. Make sure to get a good reference book for SQL, it will be a good investment for the future. The reader should also have a good grasp of programming with java and be ready to sit in the driver's seat. This book gets my thumb of approval.

2 out of 5 stars 2ND Edition repeats mistakes of the first.......1999-09-02

I got the 2nd edition after using the middleware chapter of the 1st edition. They repeat the mistakes of the first! On page 13, it states that a combination of ROWS can be used to compose a primary key. It should read a combination of COLUMNS! Half of the book is just a repeat of the 1st edition, word for word! Very little proofreading went into this book. Commented out debugging aids are left in the code.

1 out of 5 stars Please don't buy this book.......1999-04-19

You would think that a book about JDBC programming would show you how to program using JDBC. Well, in this case, you would be absolutely wrong. It (very poorly) talks about what JDBC is, what SQL is, what a JDBC driver is, but IT NEVER TALKS ABOUT JDBC PROGRAMMING!!!! IT NEVER TELLS YOU HOW TO USE ANY OF THE JDBC CLASSES TO ACTUALLY PROGRAM SOMETHING THAT USES JDBC. It's like driving your wife to the hospital to give birth, but forgetting your wife. And remember, everything it talks about is poorly written.

2 out of 5 stars Good at JDBC driver developing only.......1998-11-19

I just finish studying this book... and want to throw this book out of my window... I own "Inside ODBC" (MS Press). If it is 10, this book is 2..

I suggest author combine part 1, 2, and 5 into one part and condense the content.. Part 3 teach you how to write a JDBC driver, must be useful to driver developer, Part 4 walks through some samples, for general reader, this part is most helpful..

My conclusion is if you are a JDBC driver developer and want to know some about SQL and database programming. Buy this book. Otherwise, buy O'Relly's JDBC book. It is much better than this book!!

1 out of 5 stars poor book.......1998-09-05

This book is so poor that I have never got any useful information about JDBC from it. We can not hope one book can cover everything, but at least one thing. This author hopes he can tell the readers more about SQL, JDBC driver, Java. In fact, almost all us do not want to get these from a JDBC book. Just give us some interesting examples and tell us how to us JDBC. If you just want to start to use JDBC, the JDBC tutorial is much more useful than this book.
JDBC: Database Programming with J2ee
Average customer rating: Not rated
    JDBC: Database Programming with J2ee
    Art Taylor
    Manufacturer: Pearson Education
    ProductGroup: Book
    Binding: Paperback

    GeneralGeneral | Java | Programming | Computers & Internet | Subjects | Books
    GeneralGeneral | Programming | Computers & Internet | Subjects | Books
    GeneralGeneral | Languages & Tools | Programming | Computers & Internet | Subjects | Books
    Database DesignDatabase Design | Databases | Computers & Internet | Subjects | Books
    GeneralGeneral | Databases | Computers & Internet | Subjects | Books
    GeneralGeneral | Computers & Internet | Subjects | Books
    GeneralGeneral | Software | Computers & Internet | Subjects | Books
    FrenchFrench | Foreign Language Nonfiction | Nonfiction | Subjects | Books
    NonfictionNonfiction | French | Foreign Language Books | Specialty Stores | Books
    All French BooksAll French Books | French | Foreign Language Books | Specialty Stores | Books
    ASIN: 0130453234
    Teach Yourself Database Programming With Jdbc in 21 Days (Teach Yourself Series)
    Average customer rating: 2.5 out of 5 stars
    • Look elsewhere for JDBC Book
    • Good for absolute beginner of the subject but not for others
    • Poorly written, quickly thrown together
    • If you used PowerBuilder you'll like this authors style of writing...
    • If you used PowerBuilder you'll like this authors style of writing...
    Teach Yourself Database Programming With Jdbc in 21 Days (Teach Yourself Series)
    Ashton Hobbs
    Manufacturer: Sams Publishing
    ProductGroup: Book
    Binding: Paperback

    GeneralGeneral | Java | Programming | Computers & Internet | Subjects | Books
    GeneralGeneral | Introductory & Beginning | Programming | Computers & Internet | Subjects | Books
    GeneralGeneral | Programming | Computers & Internet | Subjects | Books
    GeneralGeneral | Languages & Tools | Programming | Computers & Internet | Subjects | Books
    GeneralGeneral | Computers & Internet | Subjects | Books
    GeneralGeneral | Databases | Computers & Internet | Subjects | Books
    GeneralGeneral | Software | Computers & Internet | Subjects | Books
    MathematicsMathematics | Professional Science | Professional & Technical | Subjects | Books | Applied | Chaos & Systems | Geometry & Topology | Mathematical Analysis | Mathematical Physics | Number Systems | Pure Mathematics | Transformations | Trigonometry
    ASIN: 1575211238

    Amazon.com

    Following this series' trademark combination of step-by-step tutorials and tables full of reference material, Teach Yourself Database Programming with JDBC in 21 Days does a fine job of preparing you to take on a new assignment involving JDBC. True mastery won't come until many more days of JDBC programming have passed and you'll soon want a more advanced reference book to guide you beyond this book. However, Hobbs's book is a fine way to get your feet wet.

    The first two weeks of this self-paced course are academic--day by day, you study one or more new concepts, components, or objects. In these two weeks, you learn about the essentials of JDBC--establishing connections and the like. Each chapter--covering topics such as transactions, SQL statements, and result sets--concludes with a quiz, which you can use to gauge your progress through the book. During the final week, when your new knowledge is beginning to gel, you actually write two database applications. The first, a "knowledge base" program, illustrates general JDBC techniques by enabling you to query a database for articles. The second, an "employee resource" program for tracking employee data, mainly shows how things in Java 1.1 differ from Java 1.0--a sort of dated distinction. In any case, it's these guided examples and the source code on the companion CD-ROM that make this book good.

    Customer Reviews:

    1 out of 5 stars Look elsewhere for JDBC Book.......1999-05-17

    This Book does not give a lot of information about JDBC except for the first 7 days , the Rest is going nowhere with bad coding exambles.

    3 out of 5 stars Good for absolute beginner of the subject but not for others.......1999-04-05

    This is probably a good beginer's source. Not for those who understand the concepts of JDBC and Java. The book, on the back cover, implies that this is for Advanced to Experiences users, but I do not think so. The examples in the book teach you the JDBC and how to create your own objects and interfaces around it. Too basic if you know Java and has been programming in it for a while.

    If you are a beginner do not hesitate to buy this book. The accompanied CD will be a great source for you to run through the examples and to start off with few sample projects of your own. The author had a good style in teaching the subject with well chosen examples and coverage of the concepts and explanation of those examples.

    1 out of 5 stars Poorly written, quickly thrown together.......1998-07-20

    This book spends perhaps a third of its time concentrating on JDBC while the remaining two thirds gives a very sketchy overview of Java programming that would be over the heads of most beginners. Many of the examples don't work. I spent a great deal of time debugging the examples to get them to work.

    4 out of 5 stars If you used PowerBuilder you'll like this authors style of writing..........1997-11-13

    The author shows you good examples of using JDBC, dbAnywhere, and Sybase. An excellent jump start if you want to understand inner workings of JDBC application development. The author centers much of his JDBC examples around PowerBuilder concepts such as the datawindow and transaction object. If you knew PowerBuilder in the past you will feel very comfortable with this book.Only shortcomings. The book focuses on application development(meaning local development). No where does he give examples of how to write a database applet and make it work over the internet using dbAnywhere.

    4 out of 5 stars If you used PowerBuilder you'll like this authors style of writing..........1997-11-13

    The author shows you good examples of using JDBC, dbAnywhere, and Sybase. An excellent jump start if you want to understand inner workings of JDBC application development. The author centers much of his JDBC examples around PowerBuilder concepts such as the datawindow and transaction object. If you knew PowerBuilder in the past you will feel very comfortable with this book.Only shortcomings. The book focuses on application development(meaning local development). No where does he give examples of how to write a database applet and make it work over the internet using dbAnywhere.
    Database Programming with JDBC and JAVA.(by Reese, George)(Review): An article from: Journal of Database Management
    Average customer rating: Not rated
      Database Programming with JDBC and JAVA.(by Reese, George)(Review): An article from: Journal of Database Management
      Amita Goyal Chin
      Manufacturer: Idea Group Publishing
      ProductGroup: Book
      Binding: Digital

      GeneralGeneral | Java | Programming | Computers & Internet | Subjects | Books
      GeneralGeneral | Programming | Computers & Internet | Subjects | Books
      Database DesignDatabase Design | Databases | Computers & Internet | Subjects | Books
      Database Management SystemsDatabase Management Systems | Databases | Computers & Internet | Subjects | Books
      ProgrammingProgramming | Computers & Internet | Subjects | e-Docs | Formats | Books
      ASIN: B00099OZCQ
      Release Date: 2005-07-28

      Book Description

      This digital document is an article from Journal of Database Management, published by Idea Group Publishing on April 1, 1999. The length of the article is 948 words. The page length shown above is based on a typical 300-word page. The article is delivered in HTML format and is available in your Amazon.com Digital Locker immediately after purchase. You can view it with any web browser.

      Citation Details
      Title: Database Programming with JDBC and JAVA.(by Reese, George)(Review)
      Author: Amita Goyal Chin
      Publication: Journal of Database Management (Refereed)
      Date: April 1, 1999
      Publisher: Idea Group Publishing
      Volume: 10 Issue: 2 Page: 38

      Distributed by Thomson Gale
      Database Programming with JDBC and Java
      Average customer rating: Not rated
        Database Programming with JDBC and Java
        George Reese
        Manufacturer: NY
        ProductGroup: Book
        Binding: Paperback
        ASIN: B000MU95ZY

        Books:

        1. Derivation and Computation: Taking the Curry-Howard correspondence seriously (Cambridge Tracts in Theoretical Computer Science)
        2. Digital Rights Management: Business and Technology
        3. Don't Make Me Think: A Common Sense Approach to Web Usability, 2nd Edition
        4. Encyclopedia of Computers and Computer History
        5. Enterprise Integration Patterns: Designing, Building, and Deploying Messaging Solutions (The Addison-Wesley Signature Series)
        6. Enterprise Messaging Using JMS and IBM(R) WebSphere(R) (IBM Press Book)
        7. Exploring Expect: A Tcl-based Toolkit for Automating Interactive Programs (Nutshell Handbooks)
        8. Exploring Interface Design (Design Exploration Series)
        9. FileMaker Pro 8: The Missing Manual
        10. Fundamentals of Neural Networks

        Books Index

        Books Home

        Recommended Books

        1. Probability and Stochastic Processes: A Friendly Introduction for Electrical and Computer Engineers
        2. Into the West: From Reconstruction to the Final Days of the American Frontier
        3. Careers in Accounting, 2006 edition: WetFeet Insider Guide
        4. History: Fiction or Science
        5. Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
        6. Operations Management: An Integrated Approach
        7. History: Fiction or Science
        8. Managing the New Bank Technology: An Executive Blueprint for the Future
        9. Foreign Exchange Intervention as a Monetary Policy Instrument: Evidence for Inflation Targeting Coun
        10. Have Your Cake and Kill Him Too: A Blackbird Sisters Mystery