weird error in my JDBC code

[scott]

Hi,

I am trying to learn how to invoke mysql stored procedures from Java.

So, I have a stored procedure as follows:

CREATE PROCEDURE `init`(IN `sName` VARCHAR(192), OUT `sId` INTEGER)
BEGIN
set sId= 30;
END

I am using the following java code to invoke the stored procedure:

//get the connection, then
CallableStatement cstmt = (CallableStatement) m_conn.prepareCall("call init(?, ?);");
cstmt.setString(1,m_BIuser.getName());
cstmt.registerOutParameter(2,Types.INTEGER);
cstmt.execute();

However, the above code throws the follwoing exception at the cstmt.execute() line:

java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sId`)' at line 1

The 'init' stored procedure does not have any syntax error since I can compile and execute it from within MYSQL Maestro. What am I doing wrong here? Is this a bug?

I am using the mysql 5.0 release canditate and the latest mysql JDBC driver.

thanks

scott