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.

This essential guide offers serious Java developers a focused resource on using JDBC 3 to build robust, enterprise-class applications for the Internet or intranet. This title provides a step-by-step tutorial on the JDBC 3 API, as well as many examples and discussions about advanced techniques. It also provides a complete reference of the API's packages and extensions. Powerful and enhanced new features are covered: Batch updates, DataSource object, transaction savepoints, connection pooling, distributed transaction support, XA compatibility, types of ResultSets, holdable cursors, SQL99 types, scalar functions, CLOB, array, reference and datalink objects, customized type mapping, transform groups, ParameterMetaData API, auto generated keys, and more.

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.

* First book on the market that covers building high-performance Java applications on the Oracle database—using the latest versions of both the Oracle database (10g) and the JDBC API (3.0). * Promotes and explains an "anti black box" approach to Oracle development complete with benchmark code) that will allow developers to write highly efficient, high performance Oracle JDBC applications. * A new book from the prestigious OakTable Press, which Apress will be strongly promoting and supporting throughout 2004.

1 -- Introduction to JDBC -- 2 -- Presenting Information to Users -- 3 -- Querying the Database -- 4 -- Updating the Database -- 5 -- Advanced JDBC Topics -- 6 -- An eCommerce Example -- 7 -- How to Stay Current with JDBC -- 8 -- Appendix.

bull; A comprehensive tutorial AND useful rufescence in one volume bull; Includes multiple explanations and examples for the new features of the JDBC 3.0 specification bull; Written by the JDBC 3.0 architects, Maydene Fisher, Jon Ellis and Jonathan Bruce

* The only standard size JDBC "cookbook" in market with clear specification of problems and ready-to-be-used working code solutions (in a cut-and-paste fashion) that work for at least two leading databases such as MySQL and Oracle. • Most existing JDBC-related books provide only generic solutions, which might not work on any vendor’s database. This book shows the importance of "vendor" factor for solving JDBC problems. • Complete coverage of database and result set "metadata" (which is missing from most JDBC books).

First book to market on metadata specific recipes related to JDBC and its use with MySQL and Oracle, databases standard to Java. Compliant with the new Java EE 5. Provides cut and paste code templates that can be immediately customized and applied in each developer’s application development.

This text presents the JDBC standard, Java's database connectivity environment, and provides information for using Java with JDBC for accessing databases. The manual is designed for users who are learning database programming for the Internet or company In

JDBC has simplified database access in Java applications, but a few nagging wrinkles remain—namely, persisting Java objects to relational databases. With this book, you’ll learn how the Spring Framework makes that job incredibly easy with dependency injection, template classes, and object-relational-mapping (ORM). Through sample code, you’ll discover how Spring streamlines the use of JDBC and ORM tools such as Hibernate, the Java Persistence API (JPA), and Java Data Objects (JDO). If you’re a Java developer familiar with Spring (perhaps through O’Reilly’s Just Spring tutorial) and want to advance your data access skills, this book shows you how. Learn how to use Spring’s basic and advanced data access tools Work with Spring’s JdbcTemplate class to separate non-critical code from business code Eliminate placeholder variables in your queries with the NamedParameterJdbcTemplate class Use Spring’s template classes to perform batch executions Operate inserts on database tables without writing any SQL statements Learn about Spring’s support for Hibernate as an object-relational-mapping tool Use JPA as a standards-based ORM—alone or with Spring support Move data from a relational to a non-relational database with JDO