ByThorben JanssenUp 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…
ByThorben JanssenUsing 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…
ByThorben JanssenThis 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…
ByThorben JanssenThis 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….
ByThorben JanssenThis is the second part of my SQL result set mappings series. We had a look at some basic result type mappings in the first post Result Set Mapping: The Basics. In this one, we will define more complex mappings that can map a query result to multiple entities and handle additional columns that cannot be mapped to…