liveBook · Manning

Derived query method

A derived query method is a repository method whose database query is generated by interpreting its name according to framework conventions.

How 2 Manning books explain it

Spring Start Here, Second Edition

Query derivation is the technique of generating a database query by interpreting a repository method's name according to framework naming rules.

How it is used
Handles custom repository searches by deriving SQL from method names instead of requiring a written query.
How deep it goes
Maps `find` and `ByName` to SELECT and WHERE, then contrasts explicit SQL without detailing a broader naming grammar.
Examples
Uses `findAccountsByName` and `findByName` to demonstrate account-name searches.
What you can do after
Apply Spring Data naming rules to declare an account-name lookup without writing its SQL query.

Read how Spring Start Here, Second Edition explains derived query method →

Spring in Action, Sixth Edition

A derived query method is a repository method whose query behavior is inferred by parsing its name and matching name components to entity properties and query operators.

How it is used
Defines repository queries through method signatures instead of writing persistence details separately.
How deep it goes
Explains name parsing, method structure, fetch verbs, count queries, properties, and compound predicates.
Examples
Uses delivery ZIP, delivery dates, delivery names, delivery cities, case-insensitive matching, ordering, and a Seattle query.
What you can do after
Build repository methods that derive queries from entity-property names, predicates, and supported query verbs.

Read how Spring in Action, Sixth Edition explains derived query method →

Related concepts

Questions about derived query method

What is derived query method?

A derived query method is a repository method whose database query is generated by interpreting its name according to framework conventions.

Which Manning books explain derived query method?

Spring Start Here, Second Edition and Spring in Action, Sixth Edition.

What is the difference between derived query method and @Query?

A derived query method is a repository method whose database query is generated by interpreting its name according to framework conventions. @Query is a Spring Data annotation that associates a repository method with an explicitly declared query for retrieving or modifying data.

What is derived query method a kind of?

Derived query method is a kind of method. A method is a callable function or operation associated with a type, class, or object and invoked through that association.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.