javamysqljdbc

Can't execute a MySQL stored procedure from JDBC

Im trying to connect to the mariadb server in jdbc and call my stored procedure but im getting this error. Ive also tried:

'''GRANT all ON mysql.proc TO 'Gruppe18'@'i3ED6FBF0.versanet.det';'''

but in mysql i got access denied error.

And the server is from university so I dont have full access on it.

enter image description here

Solution

  • The image shows that you're using named parameters, which means that the JDBC driver needs to query the meta-data of the stored procedure to learn what those parameters are.

    Your user is not authorized to query that meta-data.

    Solution: Use positional parameters.