I have an sql server express(2019) locally installed. On it i have a database with a tiny stored procedure. I'm trying to connect to this database via spring boot and execute this procedure. But i always get an sql exception that the procedure could not be found. Has anyone come across this problem?
Code for the procedure:
https://pastebin.com/X0n4W7gE
Springboot Controller Method:
https://pastebin.com/jWEd2QHB
Testcall via powershell: https://pastebin.com/fcxvfC8Z
#java #SpringBoot #mssql #springjdbc
Is there a working example which shows executing a stored Procedure with in and out parameters via the spring SimpleJdbcCall Class? #springboot #java #springjdbc