未分类的SQLException Jdbc模板

Question

我正在尝试调用一个存储过程来在SQL表中创建一个项。运行代码时，运行存储过程并创建项，但抛出此错误。表中存储的值是正确的，generate键生成正确的键。

下面是我创建参数映射的create函数：

public int create(Job job) throws DataAccessException, NullPointerException {
    Assert.notNull(job,"Job must not be null.");
    Assert.notNull(job.getSite(),"Site must not be null."); 


    KeyHolder keyHolder = new GeneratedKeyHolder();
    final String columnNames[] = {"id"};

    MapSqlParameterSource params = params("intSiteId",job.getSite().getId())
            .addValue("dtmStart", job.getStartDate() == null ? null : dateTimeString(job.getStartDate()))
            .addValue("dtmEnd", job.getEndDate() == null ? null : dateTimeString(job.getEndDate()))
            .addValue("intManualFl",job.isManual());

    getTemplate().update(getSql("create"), params, keyHolder, columnNames);


    return keyHolder.getKey().intValue();
}

@Override
public int update(
        String sql, SqlParameterSource paramSource, KeyHolder generatedKeyHolder, String[] keyColumnNames)
        throws DataAccessException {

    ParsedSql parsedSql = getParsedSql(sql);
    String sqlToUse = NamedParameterUtils.substituteNamedParameters(parsedSql, paramSource);
    Object[] params = NamedParameterUtils.buildValueArray(parsedSql, paramSource, null);
    List<SqlParameter> declaredParameters = NamedParameterUtils.buildSqlParameterList(parsedSql, paramSource);
    PreparedStatementCreatorFactory pscf = new PreparedStatementCreatorFactory(sqlToUse, declaredParameters);
    if (keyColumnNames != null) {
        pscf.setGeneratedKeysColumnNames(keyColumnNames);
    }
    else {
        pscf.setReturnGeneratedKeys(true);
    }
    return getJdbcOperations().update(pscf.newPreparedStatementCreator(params), generatedKeyHolder);
}

public int create(Job job) throws DataAccessException, NullPointerException {
    Assert.notNull(job,"Job must not be null.");
    Assert.notNull(job.getSite(),"Site must not be null."); 


    MapSqlParameterSource params = params("intSiteId",job.getSite().getId())
        .addValue("dtmStart", job.getStartDate() == null ? null : dateTimeString(job.getStartDate()))
        .addValue("dtmEnd", job.getEndDate() == null ? null : dateTimeString(job.getEndDate()))
        .addValue("intManualFl",job.isManual());

    getTemplate().update(getSql("create"), params);


    return 0;

}

Answer 1

您是否可以询问服务器端跟踪或在可以启用跟踪的服务器上复制它？因为可以在SQL Server服务器上以更具体的方式记录客户端上的未知错误。