- Taschenbuch: 450 Seiten
- Verlag: O'Reilly & Associates (12. Dezember 2001)
- Sprache: Englisch
- ISBN-10: 059600088X
- ISBN-13: 978-0596000882
- Größe und/oder Gewicht: 17,8 x 2,9 x 23,3 cm
- Durchschnittliche Kundenbewertung: Schreiben Sie die erste Bewertung
- Amazon Bestseller-Rang: Nr. 818.732 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
- Komplettes Inhaltsverzeichnis ansehen
Java Programming with Oracle JDBC (Classique Us) (Englisch) Taschenbuch – 12. Dezember 2001
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Wenn Sie dieses Produkt verkaufen, möchten Sie über Seller Support Updates vorschlagen?
JDBC is the key Java technology for relational database access. Oracle is one of the most widely used relational database platforms. In this volume, Don Bales brings these two technologies together, and shows the reader how to leverage the full power of Oracle's implemantation of JDBC. It begins with establishing database connections. Detailed information and examples showing how to make database connections from applications, applets, servlets, and even from Java programs running within the database itself are used. Next is coverage of JDBC's relational SQL features. It shows 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 how to interface with Oracle's other built-in programming language PL/SQL. It also covers how to use JPublisher and JDBC to work seamlessly with Oracle database objects from within Java programs, and how to access nested tables and arrays using JDBC. It concludes with a discussion of transaction management, locking, concurrency, and performance topics with which every professional JDBC programmer should be familiar.
Über den Autor und weitere Mitwirkende
Donald Bales is a Computer Applications Consultant specializing in the analysis, design, and programming of distributed systems; systems integration; and data warehousing. Don has over sixteen years experience with Oracle as both a developer and a database administrator, and six years experiance with Java. He is currently working on the migration of medical and industrial hygiene systems to a web environment for a major Oil company. When he is not developing applications, Donald can often be found working with horses, playing the piano, or playing the bagpipes. Donald has had several careers, and has at various times been a mechanic, a general contractor, Mr. Mom, a developer, and currently a consultant. He has a bachelor of science degree in Business from Elmhurst College in Elmhurst, Illinois. Don currently resides in Downers Grove, Illinois with his wife Diane and his daughter Kristyn. He can be contacted by email at email@example.com
Die hilfreichsten Kundenrezensionen auf Amazon.com
It's immediately obvious Mr. Bales is familiar with actual process of developing real applications. He has presented this complex and complicated subject in a direct and pleasant manner for advanced programmers. Relatively new to Java but very familiar with Oracle, I found his organization of the material very helpful - and the sections on Relational SQL and Object-Relational SQL based on sound knowledge and experience. Mr. Bales includes a final Section on Essentials where he discusses transactions and locking, performance and trouble shooting - all very practical and extremely useful if you are developing serious applications. And yes, those last eleven pages were very helpful.
I have not found a book that addresses using Oracle JDBC in application development directly, and have found few books that address database application development very well - but this book does both. One small thing I thought was missing were guidelines for using weakly typed object SQL vice strongly typed - in other areas good advice was offered.
Before I bought this book, I used Oracle's documentation at otn.oracle.com. This required a file of bookmarks, several large block diagrams, lots of notes and much patience. It's much better to start with this book - and get a well-organized and coherent view along with practical advice and examples, before wading into Oracle's extensive documentation.
It covers establishing database connection in sufficient details, all basic SQL commands and the best practices on using them. Highlights the differences between Statement, PreparedStatement, and CallableStatement and zooms in on Oracle way of implementing them.
Shows quite a few little "cotchas" that are not easy to spot on your own.
I didn't find chapters on object-relational SQL very useful, but I guess that the book should have had that for completeness of coverage.
Also, I'd like to argue with author's performance tests. The author used INSERT statement for tests, but it is SELECT statement that incurres additional overhead of metadata passing. If the author used SELECT statements when comparing performance of Statement vs. PreparedStatement, he would probably found PreparedStatement perform better. Also his tests assume single user database connection. If there are many (like hundreds) of open database connections, PreparedStatement will scale better because of database-side caching. Especially if you can use Oracle MTS.
But this is really not that important, the book is not about JDBC performance tuning.
I also totally agree with the statement that the author keeps repeating throughout the book: "Use the set-oriented nature of SQL to its fullest". That's the best single pefrormance improvement that one can do to JDBC-related code.
I highly recommend this book to everyone who is working with Oracle JDBC. Our team has been using Oracle JDBC for about 2 years now, and yet after reading this book I could easily spot at least three problems in our design/code.
Likewise, the numerous references to the "thin driver" and the banchmark figures revealing that it was either close to or exceeded the performance of the OCI driver was another eye opener (and enhanced the portability of my Oracle/JDBC code).
The examples are all comprehensible and they really do work. It's obvious the author thought these through and tested them.
The only drawback (and it's covered by the author in the preface) is that examples and pathing presume a Windows platform -- in spite of his preference for Unix. That can be forgiven..and it only cost a single star in this review. :-)