java mysql异常boo_Obscure MySql Connector/J错误信息 - java.sql.SQLException：boo {感叹号}

正如问题更新中所述，这通常是由于错误地使用CallableStatement导致的。例如：

存储过程使用2个参数，一个是和一个出：

CREATE DEFINER=`example`@`localhost` PROCEDURE `sp_getSensorLocation`(IN in_id VARCHAR(128), OUT loc VARCHAR(128))

BEGIN

SELECT LOCATION INTO loc FROM table.SENSORS

WHERE ID = in_id;

END

但调用它仅使用1：

private String getSensorLocation(String sensorID) {

String location = "";

Connection c = dbr.getConnection();

String prepStatement = "{ call sp_getSensorLocation(?) } ";

try {

callableStatement cs = c.prepareCall(prepStatement);

cs.setString(1, sensorID);

ResultSet rs = cs.executeQuery();

if (rs.next()) {

location = rs.getString(1);

}

} catch (SQLException ex) {

LOG.error("Error:", ex);

}

dbr.closeConnection(c, rs, cs);

return location;

}

当正确的代码是真的：

private String getSensorLocation(String sensorID) {

String location = "";

Connection c = dbr.getConnection();

String prepStatement = "{ call sp_getSensorLocation(?, ?) } ";

try {

CallableStatement cs = c.prepareCall(prepStatement);

cs.setString(1, sensorID);

cs.execute();

location = cs.getString(2);

} catch (SQLException ex) {

LOG.error("Error:", ex);

}

dbr.closeConnection(c, rs, cs);

return location;

}

注意我也更改为cs.execute，因为我不期望结果集，并且会遇到问题(这个例子取自我正在修复的其他人的代码，喜欢-_-)