When you write a criteria query or create a dynamic entity graph, you need to reference the entity classes and their attributes. The quickest and easiest way is to provide the required names as Strings. But this has several drawbacks, e.g. you have to remember or look-up all the names of the entity attributes when you write the query….
Up to Version 2.1, JPA was missing real support for stored procedures. The only available option was to use a native query. This changed with JPA 2.1, when @NamedStoredProcedureQuery and StoredProcedureQuery were introduced as two of the new features. I wrote about @NamedStoredProcedureQuery and how to use it to define stored procedure calls in the…
Using stored procedures to implement parts of the application logic in the database is a widely used approach in huge, data-heavy applications. Nevertheless, there was no good support for them before JPA 2.1. You had to use a native query, to call the stored procedure in the database. Since the JPA 2.1 release, JPA supports two different…
This is the fourth and last part of my series about SQL result set mappings: Result Set Mapping: The Basics Result Set Mapping: Complex Mappings Result Set Mapping: Constructor Result Mappings Result Set Mapping: Hibernate Specific Features In the first post, we had a look at some basic mapping definitions to map the query result to an entity. The…
This is the third part of my series about SQL result set mappings: Result Set Mapping: The Basics Result Set Mapping: Complex Mappings Result Set Mapping: Constructor Result Mappings Result Set Mapping: Hibernate Specific Features In the first post of this series, we had a look at some mapping definition between the query result and one entity….
