Spring Boot Restful + PostgreSQL + JPA Hibernate Stored Procedure Functions @Procedure – Part 9

In this video I have explained how to call Stored Procedure / DB Functions and what are the ways to handle the results.

Repository Link:

https://gitlab.com/lsio.repo2021/springboot

Topics covered in this video:

1. Entity Manager
2. @Procedure
3. @NamedStoredProcedureQuery
4. @SqlResultSetMapping

Runtime Exceptions covered in this video:

1. org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111
2. org.hibernate.MappingException: Cannot mix named parameters and REF_CURSOR parameter on PostgreSQL
3. org.postgresql.util.PSQLException: cursor unnamed portal 1 does not exists