Failed to execute stored procedure from the JDBC code using mysql connection

Question

I have one database. I executed a stored procedure on it. I wrote some JDBC code to connect to this database. When I am calling this stored procedure from my JDBC code it is throwing SQLException.

One interesting thing I found is that I have one user other than root user. This user has all the privileges to this database where the stored procedure is present.

When I use the root user I am able to call the stored procedure successfully. But with the other user I am getting SQLexception. I am not able to find why it happens like this.

For sure I want this user(other than root) has to call this stored procedure successfully.

Thanks in advance.

I think you should provide the whole exception stacktrace, and the stored procedur. — Bozho
– Bozho, Commented Jul 1, 2010 at 11:44
Are you sure the user has execute proceure rights? If not try GRANT EXECUTE ON PROCEDURE mydb.myproc TO 'someuser'@'somehost'; — Emre Yazici
– Emre Yazici, Commented Jul 1, 2010 at 15:53
I'd recommend adding JDBC to your tags, I recall having trouble calling sprocs from my JDBC code before too, that's all i remember though — walnutmon
– walnutmon, Commented Jul 2, 2010 at 4:06

Puru · Accepted Answer · 2010-07-01 11:42:52Z

1

The user should have SELECT permissions to the mysql.proc and mysql.procs_priv.

I don't know if there exists any other solution.

answered Jul 1, 2010 at 11:42

Puru

9,14329 gold badges74 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Failed to execute stored procedure from the JDBC code using mysql connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related