- Paperback: 152 pages
- Publisher: O'Reilly Media; 1 edition (January 1, 2003)
- Language: English
- ISBN-10: 0596004575
- ISBN-13: 978-0596004576
- Product Dimensions: 4.2 x 0.4 x 7 inches
- Shipping Weight: 4.8 ounces (View shipping rates and policies)
- Average Customer Review: 4 customer reviews
- Amazon Best Sellers Rank: #2,627,302 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
JDBC Pocket Reference 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Customers who viewed this item also viewed
Customers who bought this item also bought
About the Author
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 firstname.lastname@example.org
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
The book is intended for programmers, but could also be applicable to ambitious database administrators (DBA) that want to create Java utilities to monitor and automate some of their DBA tasks. If you are familiar with SQL and database topics the book can provide you with a quick reference on syntax and procedures that you might forget. The book is not a tutorial on SQL, client/server programming, or relational databases. If you are not familiar with these topics or you want to learn more the JDBC Pocket Reference is not for you.
The first 45 pages of the book are packed with helpful examples of how to use the JDBC API. Most JDBC programmers are familiar with these examples but often need reminders on proper syntax for different database vendors and drivers. Here are a few examples of explanations I found helpful:
1. JDBC Driver types: There are four classes of JDBC drivers called type 1, 2, 3, and 4 respectively. Type 4 is the only pure 100% Java driver and is the only type described in the book, but it is helpful to understand what driver types are available.
2. Database URL Syntax: Getting the proper database connection string can be frustrating since every database vendor is different. This task is usually done only once at the start of a project so it is easy to forget the correct syntax. The Pocket Reference describes 9 different database drivers giving the appropriate connection information, online references, archive file name, and supported properties for the driver.
3. Using JNDI to obtain a data source.
4. Using DatabaseMetaData API to find information about the database properties and capabilities.
5. Good examples for executing standard SQL statements and retrieving the results through the ResultSet interface.
6. Store Procedures: Using the CallableStatement object to execute a stored procedure is one of the most difficult JDBC calls because stored procedures are vendor dependent. The book outlines how to set input and output parameters appropriately to make the call. I found this very helpful since a lot of the documentation from database vendors do not describe this operation very well.
7. Properly handling "null" values in JDBC. This is important because a database NULL is different than a Java null.
8. Inserting and updating binary blobs is explained.
9. Describes and explains how to use User-Defined Data Types (UDTs) to help you map objects to a relational database.
10. Describes proper escape sequences ensure that your JDBC code is portable across database vendors.
The only criticism I have for the book is its lack of examples for database connection pooling and transaction support. Committing and rolling back transactions was mentioned briefly, but the book didn't give any examples. Also, the only reference to distributed transaction support was in the JDBC API reference under the XAConnection class. Distributed transaction support is a big part of the Java 2 Enterprise Edition (J2EE) and comes standard with most J2EE containers. Then again this is just a pocket reference so the author couldn't include everything.
... I highly recommend it for any programmer that works with database systems. The books provides a quick reminder on proper syntax and procedures without requiring you to carry a backpack full of 500 page books.
The book is probably enough to get you started using JDBC, especially if you have some experience using database APIs in the past (ODBC or a vendor-proprietary one).
So, my recommendation is: It's half useful, so buy it used for half price. ;-)