java.sql.SQLException : Could not find stored procedure

Question

[dbo].[GetUserCredentials]
   @Company varchar(255),
   @SchedType varchar(255),
   @ShiftHours varchar(255),
   @UserRole varchar(255),
   @UserDesc varchar(255),
   @UserOwner varchar(255)
select ... from ... where ...

存储过程^

调用存储过程的java代码

CallableStatement statement = con.prepareCall("{call GetUserCredentials}");
statement.execute();

结果

java.sql.SQLException: Could not find stored procedure 'GetUserCredentials'.

Answer 1

我发现你的存储过程缺少输入参数，请添加“？” (输入参数的数量)在prepareCall语句中例如。

stmt = con.prepareCall("{call insertEmployee(?,?,?,?,?,?)}");
            stmt.setInt(1, id);
            stmt.setString(2, name);
            stmt.setString(3, role);
            stmt.setString(4, city);
            stmt.setString(5, country);

看这个article更好地理解它