CallableStatment - problems
Hi,
I use MySQL 5.0.3-beta-nt and mysql-connector-java-3.1.7 and JBoss 4.0.1.
When I try to call a stored procedure in the database using CallableStatement;
cs = conn.prepareCall("{call mySP(?,?,?)}");
I get an exception with the following message:
"Driver requires declaration of procedure to either contain a '\nbegin' or '\n' to follow argument declaration, or SELECT privilege on mysql.proc to parse column types."
What does this message really mean?
If I instead use a PreparedStatement;
ps = conn.prepareStatement("call mySP (?,?,?)");
everything works fine.
Cheers
//Anders =)
Subject
Written By
Posted
CallableStatment - problems
April 12, 2005 06:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.