Sebastopol, CA--Oracle JDBC is where Oracle, the write-once-run-anywhere database meets Java, the write-once-run-anywhere programming language. But what is JDBC and how does it work? Donald Bales, author of Java Programming with Oracle JDBC (O'Reilly, US $39.95) tells us that JDBC, or Java DataBase Connectivity, is a Java API for executing dynamic SQL statements; Oracle JDBC is for executing dynamic SQL statements in a standard way and for leveraging Oracle's extended functionality. As Bales explains, Oracle JDBC acts as the bridge between Java and Oracle. This answers the question of what it is, but how it works is the deeper question that Bales addresses throughout his book, drawing from his sixteen-plus years of experience with Oracle, and six years' experience with Java.
"With Java and Oracle," Bales says, "we can leverage the strength of relational technology and object orientation in our enterprise applications on both client and server. But to leverage this technology to build enterprise applications, we need to have a solid foundation. That's what this book is all about. Oracle JDBC is the foundation for all your Java/Oracle applications."
According to the author, most books on JDBC lack coverage in three important areas. "First, they explain how to use JDBC without regard for the context in which it is being applied. This puts the beginning JDBC user at a distinct disadvantage," says Bales. "For example, most JDBC books spend far too little time on how to establish a connection to a database. They'll take a couple of pages to regurgitate the JDBC API specification on how to call the getConnection() method for DriverManager or DataSource, but don't give the reader a context on what is appropriate for the situation. I give my readers a jump-start by showing everything within a real-world context.
"Second, no other book I know of spends any time discussing the object-relational extensions to JDBC. I've included three chapters explaining the use of Oracle as an object database. And finally, there are vendor-specific extensions to JDBC, which are necessary because the JDBC API does not completely define a standard way to implement functionality. A generic book on JDBC doesn't cover these."
Java Programming with Oracle JDBC begins with an in-depth discussion of establishing database connections from applications, applets, Servlets, and from Java stored procedures. Bales then explains how to issue SQL statements and get results back, and moves on to more advanced topics such as streaming large objects, calling PL/SQL procedures, and working with Oracle9i's object-oriented features. The book also covers transactions, concurrency management, and performance.
In addition to practical advice on how to implement Oracle JDBC, Java and Oracle professionals will benefit from the insights Bales' experience has given him, which he shares throughout the book. "There's what I consider a bit of madness going around," Bales explains, "The Java purists, that is, those who would like to do everything in Java, are progressively moving more and more 'database' functionality from the database to the application server. They treat the database as a file system rather than a persistence for a massive amount of objects. My three chapters on object-relational technology show you how to use the database as an extension to the memory of your Java application, using SQL to access 'objects' in the database as objects in Java. I treat the database as part of the memory of my application, a potentially unlimited amount of memory.
"With Oracle9i," Bales adds, "anything you can model in Java, you can model in Oracle. If just a few good programmers see the value of using this existing reliable infrastructure rather than recreating it, we can get on with the next paradigm shift, which is to model our business problems as objects instead of relationally mapped to Java objects. We're still stuck in the relational rut just as the hierarchical and network databasers of the past were stuck in a rut when relational technology first came out."
Java Programming with Oracle JDBC is a book written by a programmer for programmers. This book is an essential tool for all Java and Oracle developers who need to work with both technologies.
For over 40 years, O’Reilly has provided technology and business training, knowledge, and insight to help companies succeed. Our unique network of experts and innovators share their knowledge and expertise through the company’s SaaS-based training and learning platform. O’Reilly delivers highly topical and comprehensive technology and business learning solutions to millions of users across enterprise, consumer, and university channels. For more information, visit www.oreilly.com.