java.sql.SQLException: Internal error when parsing callable statement metadata

[Kevin Williams]

I get this error when executing a stored proc that only inserts to a table. Here is the definition of the proc:

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`INSERTCUSTOMER`$$
CREATE PROCEDURE `test`.`INSERTCUSTOMER`( IN theID INTEGER,
IN theLASTNAME VARCHAR(30),
IN theADDRESS VARCHAR(30))
insert into CUSTOMER values (theID, theLASTNAME, theADDRESS)$$

DELIMITER ;

I invoke the proc like this:

cs = connection.prepareCall("{call INSERTCUSTOMER(?,?,?)}");
cs.setObject(1, 10);
cs.setObject(2, "A name");
cs.setObject(3, "An Address");

cs.executeUpdate();

I get the following exception ....

java.sql.SQLException: Internal error when parsing callable statement metadata
at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:6963)
at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:2721)
at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:1048)
at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:83)
at com.mysql.jdbc.Connection.prepareCall(Connection.java:1255)
at com.mysql.jdbc.Connection.prepareCall(Connection.java:1232)

I am able to execute this proc successfully from the QueryBrowser like this :

CALL INSERTCUSTOMER(10, "A name", "A Company")

Thanks in advance!!