taijidude · @taijidude
20 followers · 161 posts · Server hachyderm.io

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:
pastebin.com/X0n4W7gE

Springboot Controller Method:
pastebin.com/jWEd2QHB

Testcall via powershell: pastebin.com/fcxvfC8Z

#java #SpringBoot #mssql #springjdbc

Last updated 1 year ago

taijidude · @taijidude
20 followers · 157 posts · Server hachyderm.io

Is there a working example which shows executing a stored Procedure with in and out parameters via the spring SimpleJdbcCall Class?

#SpringBoot #java #springjdbc

Last updated 1 year ago