book

Harnessing Hibernate

Name: Harnessing Hibernate
ISBN: 9780596517724

by James Elliott, Timothy M. O'Brien, Ryan Fowler

April 2008

Intermediate to advanced

380 pages

11h 26m

English

O'Reilly Media, Inc.

Read now

Unlock full access

A Note Regarding Supplemental Files
Preface
How to Use This BookFont ConventionsOn the Web SiteHow to Contact UsAcknowledgmentsJames ElliottRyan FowlerTimothy O’Brien
I. Hibernate in a Hurry
1. Installation and Setup
Getting an Ant DistributionWhy do I care?How do I do that?Check Your Java VersionWhat just happened?What about…Getting the Maven Tasks for AntHow do I do that?Installing the Maven Tasks for AntUsing the HSQLDB Database EngineWhy do I care?How do I do that?What about…Using Hibernate CoreHow do I do that?Setting Up a Project HierarchyWhy do I care?How do I do that?A quick testWhat just happened?What’s next?Why didn’t it work?
2. Introduction to Mapping
Writing a Mapping DocumentWhy do I care?How do I do that?Generating Some ClassHow do I do that?Cooking Up a SchemaHow do I do that?What just happened?What about…
3. Harnessing Hibernate
Configuring HibernateCreating Persistent ObjectsHow do I do that?What just happened?What about…Finding Persistent ObjectsHow do I do that?What just happened?What about…Better Ways to Build QueriesWhy do I care?How do I do that?What about…
4. Collections and Associations
Mapping CollectionsHow do I do that?Why didn’t it work?What about…What just happened?Persisting CollectionsHow do I do that?What just happened?Retrieving CollectionsUsing Bidirectional AssociationsWorking with Simpler CollectionsHow do I do that?
5. Richer Associations
Eager and Lazy AssociationsHow do I do that?What about…My head hurtsOrdered CollectionsHow do I do that?Augmenting Associations in CollectionsHow do I do that?What just happened?What about…Lifecycle AssociationsHow do I do that?Reflexive AssociationsHow do I do that?
6. Custom Value Types
Defining a User TypeHow do I do that?Defining a Persistent Enumerated TypeUsing a Custom Type MappingHow do I do that?What about…Working with Persistent EnumerationsHow do I do that?Not so fast!What just happened?Why didn’t it work?Building a Composite User TypeHow do I do that?What about…
7. The Annotations Alternative
Hibernate AnnotationsWhy do I care?How do I do that?Why do I have to?Annotating Model ObjectsHow do I do that?Annotating TrackAnnotating AlbumDoes it work?An Alternate ApproachWhat now?

8. Criteria Queries
Using Simple CriteriaHow do I do that?What about…Compounding CriteriaProjection and Aggregation with CriteriaHow do I do that?Applying Criteria to AssociationsHow do I do that?What just happened?Querying by ExampleHow do I do that?Property-Oriented Criteria FactoriesWhat about…
9. A Look at HQL
Writing HQL QueriesHow do I do that?What just happened?What about…Selecting Properties and PiecesHow do I do that?What about…SortingHow do I do that?Working with Aggregate ValuesHow do I do that?What just happened?Writing Native SQL QueriesHow do I do that?What about…
II. Playing Nice with Others
10. Connecting Hibernate to MySQL
Setting Up a MySQL DatabaseHow do I do that?Connecting to MySQLTrying It OutWhat just happened?Looking at the DataWhat about…
11. Hibernate and Eclipse: Really Using the Hibernate Tools
Installing the Hibernate Tools in EclipseHow do I do that?What went wrong?Now what?Creating a Hibernate Console ConfigurationMore Editing SupportBut wait, there’s more!The Hibernate Console PerspectiveWhat about…Code GenerationMapping Diagrams
12. Maven in More Depth
What Is Maven?Maven’s standard directory layoutInstalling MavenBuilding, Testing, and Running a ProjectGenerating IDE Project Files using MavenGenerating Reports with MavenA Maven Project Object ModelParent/child Project Object ModelsThe Maven Build LifecycleUsing the Maven Hibernate3 Plug-inConfiguring the Hibernate3 plug-inGenerating Hibernate mapping documentationBecoming a Maven Maven
13. Put a Spring in your Step: Hibernate with Spring
What Is Spring?What is inversion of control?Combining Spring and HibernateAdding the Spring framework as a project dependencyWriting a Data Access ObjectWhat is a Data Access Object?Why would I want to use a DAO?Writing the ArtistDAO interfaceImplementing the ArtistDAO interfaceWhat HibernateDaoSupport providesHow do I do that?Where are the other DAOs?Creating an Application ContextHibernate configuration propertiesPutting It All TogetherTransactions: the test interfaceHow do I activate the transactional annotation?Adapting CreateTest, QueryTest, and AlbumTestTestRunner: loading a Spring ApplicationContextRunning CreateTest, QueryTest, and AlbumTestIt worked! Now what?
14. The Finishing Touch: Stripes with Spring and Hibernate
Earn Your StripesDispatcherServletStripesFilterActionBeansViewsPrepare TomcatCreate the Web ApplicationWhat just happened?Add StripesWrite up an ActionBeanWhat just happened?What’s next?Dealing with AssociationsInterceptors: a powerful way to extend stripes
A. Hibernate Types
Basic TypesCustom Value Types“Any” Type MappingsAll Types
B. The Criteria API
The Criterion FactoryThe Projection FactoryThe Order FactoryThe Property Factory
C. Hibernate SQL Dialects
Getting Fluent in the Local SQL
D. Spring Transaction Support
Using the Spring Framework’s Transactional AnnotationTransactional annotation attributesTransaction propagationTransaction isolationUsing a JTA Transaction Manager
E. Where to Go Next
Online ManualsBooksSource CodeDealing with Newer ReleasesGetting Involved
Index
About the Authors
Colophon
Copyright

Content preview from Harnessing Hibernate

Appendix C. Hibernate SQL Dialects

Getting Fluent in the Local SQL

Hibernate ships with detailed support for many^[9] commercial and free relational databases. While most features will work properly without doing so, it’s important to set the hibernate.dialect configuration property to the right subclass of org.hibernate.dialect.Dialect, especially if you want to use features like native or sequence primary key generation or session locking. Choosing a dialect is also a very convenient way of setting up a whole raft of Hibernate configuration parameters you’d otherwise have to deal with individually.

Database system	Appropriate hibernate.dialect setting
Caché 2007.1	`org.hibernate.dialect.Cache71Dialect`
DB2	`org.hibernate.dialect.DB2Dialect`
DB2 AS/400	`org.hibernate.dialect.DB2400Dialect`
DB2 OS390	`org.hibernate.dialect.DB2390Dialect`
Derby	`org.hibernate.dialect.DerbyDialect`
Firebird	`org.hibernate.dialect.FirebirdDialect`
FrontBase	`org.hibernate.dialect.FrontbaseDialect`
H2	`org.hibernate.dialect.H2Dialect`
HSQLDB	`org.hibernate.dialect.HSQLDialect`
Informix	`org.hibernate.dialect.InformixDialect`
Ingres	`org.hibernate.dialect.IngresDialect`
Interbase	`org.hibernate.dialect.InterbaseDialect`
JDataStore	`org.hibernate.dialect.JDataStore`
Mckoi SQL	`org.hibernate.dialect.MckoiDialect`
Mimer SQL	`org.hibernate.dialect.MimerSQLDialect`
Microsoft SQL Server	`org.hibernate.dialect.SQLServerDialect`
MySQL (versions prior to 5.x)	`org.hibernate.dialect.MySQLDialect`
MySQL (version 5.x and later)	`org.hibernate.dialect.MySQL5Dialect ...`

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780596517724Errata Page

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Harnessing Hibernate

by James Elliott, Timothy M. O'Brien, Ryan Fowler

Appendix C. Hibernate SQL Dialects

Getting Fluent in the Local SQL

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.