Beginning Database-Driven Application Development in Java EE (eBook)

Yuli Vasiliev is a software developer, freelance author, and consultant currently specializing in open source development, Java technologies, databases, and service-oriented architecture (SOA). He has over 10 years of software development experience as well as several years of technical writing experience. He wrote a series of technical articles for the Oracle Technology Network (OTN) and Oracle Magazine.

Contents at a Glance 5
Contents 7
About the Author 16
About the Technical Reviewer 17
Introduction 18
Who Is This Book For? 18
How Is This Book Structured? 18
What Will You Need to Use This Book? 19
Introduction 20
Setting Up Your Working Environment 21
Setting Up the GlassFish Application Server 21
Setting Up the NetBeans IDE 28
Setting Up Oracle Database XE 32
Setting Up MySQL 37
Summary 43
Getting Started with GlassFish 44
Overview of the GlassFish Application Server 44
Starting the Application Server 48
Performing GlassFish Administration with Admin Console 49
Performing GlassFish Administration with asadmin 53
Deploying Applications to the Server 54
Creating and Deploying a Web Application with the NetBeans IDE 61
Understanding GlassFish Domains 63
Summary 65
Introducing EJB 3 and the Java Persistence API 66
Overview of EJB 3 67
Your First EJB 3 Application 74
JPA at a Glance 81
Your First EJB JPA Application 83
Summary 93
Planning the Application 94
Planning a Java EE Application 95
Understanding the Structure of a Java EE Application 95
Planning Application Components and Their Interactions 100
Application Organization and Reuse 135
Planning the Steps to Building and Deploying Your Application 144
Planning the Sample Application 148
Summary 150
Planning the Underlying Database 151
Planning the Persistence Tier Upon an Existing, Underlying Database 151
Implementing Some Business Logic of an Application Inside the Database 155
Planning the Database Tier of the Sample Application 172
Summary 174
Building the Database Tier 175
Implementing the Database Tier 176
Creating the Database Schema for the Sample Application 177
Creating Database Tables to Store Application Data 179
Building the Stored Subprograms 184
Defining the Triggers 190
Testing the Underlying Database 192
Summary 196
Setting Up the Data Source 197
Overview of JNDI 197
Installing a Database Driver on the Application Server 199
Setting Up and Configuring the Data Source 200
Performing a Quick Test of the Data Source 206
Configuring the Settings of an Existing Data Source 209
Summary 210
Building the Persistence Tier 211
Designing JPA Entities 212
Creating JPA Entities Upon the Underlying Database Tables 212
Adjusting the Database Tier 222
Performing a Quick Test of the Newly Created JPA Entities 226
Building the Sample with the NetBeans IDE 234
Summary 235
Object/Relational Mapping 236
Mapping Java Objects to the Underlying Database 236
Specifying Object/ Relational Mapping Metadata 240
Utilizing Entity Relationships 245
Dealing with Entity Primary Keys 252
Summary 265
Using EntityManager 266
Managing Entities 266
Using EntityManager to Manipulate Entities 275
Using Entity Life- Cycle Callback Methods 289
Summary 295
Using Java Persistence Query Language ( JPQL) 296
Defining Queries Over Entities 296
Retrieving Entities with JPQL 302
Using Native SQL Queries 313
Summary 314
Building the Business Logic Tier 316
Designing Session Beans 317
Creating Session Beans Implementing the Sample Application Logic 317
Testing the Newly Created Session Beans 323
Continuing with the Sample Project in the NetBeans IDE 329
Summary 330
Managing Transactions 331
Using Transactions in Java EE Applications 331
Some Transaction Scenarios 340
Summary 346
Building the Presentation Tier and Testing 347
Building the Presentation Tier 348
Accessing Java EE Functionality from a Presentation Tier 348
Using JAAS to Secure Java EE Applications 352
Building the Sample’s Presentation Tier with JSF 356
Summary 366
Testing the Application 367
Launching the Sample Application 367
Testing the Functionality of the Sample 370
Summary 372
Appendix 373
Getting Familiar with Relational Databases 374
What Database to Choose? 375
Using the SQL Database Language 385
Using Management Tools Shipped with Your Database 399
Index 402