CallableStatment - problems
Posted by: Anders Hedstrom
Date: April 12, 2005 06:18AM


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.


//Anders =)

Options: ReplyQuote

Written By
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.