Hi,

In Domain Logic and SQL (http://martinfowler.com/articles/dblogic.html), Martin Fowler talks about 3 styles of interfacing with a database:

1. Transaction Script
2. Domain Model, and
3. Logic in SQL

What I'd like to know is:

1. When employing Hibernate for persistence, which of the above 3 styles is typically used and/or encouraged?
2. Is there any 4th style when using Hibernate?

(In context of Hibernate, substitute HQL in place of SQL above.)

Also, is this point covered in the Manning Hibernate book (2nd edition)?

Many thanks...


PS: I have cross-posted this on Stack Overflow too (http://stackoverflow.com/questions/3555603/newbie-question-on-hibernate-in-context-of-martin-fowler-article). But I'm hoping that Hibernate experts here on this forum would be able to give an authoritative answer.

in the context of this quite old article it's definitely "2 - domain model", but it's actually an evolution of that as the transaction model coupled with automatic dirty checking and good second-level caches makes it both maintainable and performing well.

About the book, yes reading it would help.