user1099123 user1099123 - 1 month ago 7
Java Question

Are you supposed to have one repository per table in JPA?

Are you supposed to have one repository per table in JPA? If not, how do you resolve the generics in the repository database?

For example, below is a

StoreRepository
. It handles CRUD operations on the
Store
object. If I wanted the repository to save a
StoreEvent
object as well, how would I go about changing the interface below to accommodate both objects?

@Repository
public interface StoreRepository extends JpaRepository<Store, String> {
public Store findByGuid(String guid);
}

Answer

As repository is a concept derived from Domain Driven Design, thinking about database tables is the wrong approach. By definition you access aggregate roots from a repository. Effectively a repository is simulating a collection of these.

Now what forms an aggregate root? Probably even more interesting: what does not? That's of course highly depending on your domain but let me give you an example here. An Order containing LineItems usually is modeled as an aggregate root. This is due to the composition nature of the Order. A LineItem would not exist without a surrounding Order.

Usually the persistence access mechanisms should follow the domain principles. Thus, you'd model both Order and LineItem as @Entity classes but only create an OrderRepository, as the form the aggregate root and effectively control the consistency rules within the object graph.

We also strongly recommend not to use the store specific repository base interfaces as they - as the name suggests - expose store specifics (e.g. flush()) to the clients which the shouldn't be aware of if possible. Read more on that in my answer here.