1. Overview

In this article, we will see how we can call Spring boot JPA call MySQL procedure or stored procedure. While working with @Procedure to call stored procedure at that time throwing an exception like org.springframework.dao.InvalidDataAccessApiUsageException: Type cannot be null; nested exception is java.lang.IllegalArgumentException: Type cannot be null to overcome this issue we have tried so many solutions but not able to find the proper solution so finally decide to call the stored procedure using the native query whose example as below:

JavaDeveloperZone is the group of innovative software developers. We are expert in Java JEE and BigData application development. Our contributions will help Java developers and make development journey easy. Feel free to ask any question and suggestion. Always have space for improvement !
We are also providing software application development as service. Contact us