Java Database Best Practices

When creating complex Java enterprise applications, developers have to make important decisions about the methodology, APIs and techniques they'll use to store data in a permanent fashion. They're faced with an "alphabet soup" of choices-EJB, JDO, JDBC among them-and until now, they've been left on their own to figure out which model might be most appropriate for their application. Java Database Best Practices rescues developers from having to slog through books on each of the various APIs before they figure out which method to use! This guide introduces each of the dominant APIs, explores the methodology and design components that use those APIs, and then offers practices most appropriate for different types and makes of databases, and different types of applications.

George Reese has taken an unusual path into business software development. After earning a B.A. in philosophy from Bates College in Lewiston, Maine, George went off to Hollywood where he worked on television shows such as "The People's Court" and ESPN's "Up Close". The L.A. riots convinced him to return to Maine where he finally became involved with software development and the Internet. George has since specialized in the development of Internet-oriented Java enterprise systems and the strategic role of technology in business processes. He is the author of Database Programming with JDBC and Java, 2nd Edition and the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently lives in Minneapolis, Minnesota with his wife Monique and three cats, Misty, Gypsy, and Tia. He makes a living as the National Practice Director of Technology Strategy for digital@jwt in Minneapolis.

Preface

xi

Part I. Data Architecture

Elements of Database Applications

3

(19)

Database Application Architectures

3

(15)

Component Models

18

(2)

Persistence Models

20

(2)

Relational Data Architecture

22

(31)

Relational Concepts

23

(10)

Modeling

33

(2)

Normalization

35

(11)

Denormalization

46

(3)

Object-Relational Mapping

49

(4)

Transaction Management

53

(22)

Transactions

54

(4)

Concurrency

58

(4)

JDBC Transaction Management

62

(8)

Transaction Management Paradigms

70

(5)

Part II. Persistence Models

Persistence Fundamentals

75

(22)

Patterns of Persistence

75

(5)

A Guest Book Application

80

(17)

EJB CMP

97

(16)

Which CMP Model to Use?

98

(1)

The EJB 1.0 CMP Model

99

(7)

The EJB 2.0 CMP Model

106

(6)

Beyond CMP

112

(1)

EJB BMP

113

(16)

EJBs Revisited

113

(3)

BMP Patterns

116

(7)

State Management

123

(4)

Exception Handling

127

(2)

JDO Persistence

129

(9)

JDO or EJB?

129

(2)

Basic JDO Persistence

131

(5)

EJB BMP with JDO

136

(2)

Alternative Persistence Frameworks

138

(17)

Why Alternative Frameworks?

139

(1)

Persistence Approach

140

(7)

Persistence Operations

147

(3)

Searches

150

(1)

Beyond the Basics

151

(4)

Part III. Tutorials

J2EE Basics

155

(33)

The Platform

155

(1)

Java Naming and Directory Interface

156

(11)

JavaServer Pages

167

(6)

Remote Method Invocation

173

(7)

Enterprise JavaBeans

180

(8)

SQL

188

(25)

Background

188

(4)

Database Creation

192

(2)

Table Management

194

(5)

Data Management

199

(14)

JDBC

213

(28)

Architecture

213

(5)

Simple Database Access

218

(15)

Advanced JDBC

233

(8)

JDO

241

(14)

Architecture

241

(4)

Enhancement

245

(2)

Queries

247

(4)

Changes

251

(1)

Transactions

251

(2)

Inheritance

253

(2)

Index

255

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Java Database Best Practices

Summary

Author Biography

Table of Contents

Supplemental Materials