[Java][Mysql][Resolved] java.Sql.SQLException:unable to retrieve metadata for procedure

 Error message:

java.Sql.SQLException:unable to retrieve metadata for procedure

Source code:

CallableStatement cstmt = (CallableStatement) con.prepareCall("BEGIN sp_get_test_detail(?,?); END;");

cstmt.setString(1,strClipId);

cstmt.setString(2.strPubDate);

Solution:

Check your the statement you call stored procedure is correct, for my case, I have used the orcale syntax but not mysql, here is the correction:

CallableStatement cstmt = (CallableStatement) con.prepareCall("CALL sp_get_test_detail(?,?);");

cstmt.setString(1,strClipId);

cstmt.setString(2.strPubDate);