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:

Topics covered in this video:

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

Runtime Exceptions covered in this video:

[semugutkha]

Thank you man, this is exactly what I needed. I will try this out and get back to this video.

[pulkitkaushik]

Great stuff man.. i will definitely try it and get back if i face anything

[TheLoveking]

Hi Bro, This is realy useful for me and thanks for sharing this vedio. but ur voice is very lower to hear u

[MessierNoventayNueve]

Thanks. lot of thanks, was an great helpfull video.

[sagarsomwanshi]

Thanks for giving a Nice Explanation for JPA with the procedure ..But the whole video is for the calling function not the Store procedure in PostgreSQL ..Could you please give that example?

[thiru]

Hi, i am getting following error in oracle DB with same

ORA-06553: PLS-306: wrong number or types of arguments in call to 'procedure'

[rajchavan]

I am getting an exception that says.
Cannot invoke "java.util.iterator" because "this.parameters" is null.

[karthickselvam]

Hi Man,
Please help...How to map multiple result set from one single SP.

[AhmadHamid]

@Procedure didn't work if the function is not defined in the public schema on postgresql

[minmai]

How about procedure using multiple tables ? Please help me

[EjazAhmad-xscc]

Hello sir,
I am trying with these code but with SQL Oracle developer, I am not getting, can you help me

[nilolima]

How i can create Stored Functions in Spring Boot????

[yaswanthsatyavarapu]

Nice video,
If there are placeholders in sql stored procedures, then how to handle it in spring boot.

Please explain this

[HariKrishna-irmx]

According to you, which one is better to call DB object in Spring boot.. please reply

[ThabiraGamingShorts]

Hi Sir,
I am getting "No Dialect mapping for JDBC type: 1111" this error for void method
is there any fix for this

[ciliyaciliya]

Is it possible to pass entire insert query to a function or procudre via spring jpa?

[tanvia]

What are the benefits of using @Procedure over @Query?

[venkateshv]

Hello Mate, The video is very good and your explanation too. But in the real world project we get the result set from procedure from different tables.
Ex: select A.a, B.b, C.c
from table A, table B, table C
where A.id=B.id and B.id=C.id
column a from table A, column B from table B etc...how to handle this scenario or map in @Entity.