Skip to content

Files

Latest commit

f8de0a1 · Dec 24, 2019

History

History

HibernateSpringBootCallStoredProcedureNativeCall

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Dec 24, 2019
Nov 27, 2019
Dec 23, 2019

Calling Stored Procedure That Returns A Result Set Via Native Query

Description: This application is an example of calling a MySQL stored procedure that returns a result set (entity or DTO) via a native query.

Key points:

  • rely on a native call as @Query(value = "{CALL FETCH_AUTHOR_BY_GENRE (:p_genre)}", nativeQuery = true)

If you need a deep dive into the performance recipes exposed in this repository then I am sure that you will love my book "Spring Boot Persistence Best Practices"If you need a hand of tips and illustrations of 100+ Java persistence performance issues then "Java Persistence Performance Illustrated Guide" is for you.