jdbctemplate mysql blob_插入的byte []到BLOB字段与春天的JdbcTemplate和存储过程

请求处理失败;嵌套异常是org.springframework.jdbc.BadSqlGrammarException：PreparedStatementCallback;错误的SQL语法[SELECT ID FROM sp_NEWFILE(？，？，？)];嵌套的异常是org.firebirdsql.jdbc.field.TypeConversionException：转换为对象时出错。

型号：

public class fileBody {

private int ID;

private byte[] BODY;

private String FILENAME; //getters an setters}

它插入到数据库

public class FileBodyDaoImpl implements FileBodyDao {

public int insertData(final FileBody fileBody) throws IOException {

JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

LobHandler lobHandler = new DefaultLobHandler();

final InputStream in = new ByteArrayInputStream(fileBody.getBODY());

final int fileSize = in.available();

Map out = jdbcTemplate.queryForMap("SELECT ID FROM sp_NEWFILE(?,?,?)",

new AbstractLobCreatingPreparedStatementCallback(lobHandler) {

protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException,

DataAccessException {

ps.setString(1, fileBody.getFILENAME());

lobCreator.setBlobAsBinaryStream(ps, 2, in, fileSize);

ps.setNull(3, java.sql.Types.INTEGER);

}

});

int last_inserted = Integer.parseInt(String.valueOf(out.get("ID")));

return last_inserted;

}

而且我的存储过程

create or alter procedure sp_NEWFILE (

FILENAME varchar(255),

BODY blob sub_type 0 segment size 80,

USEID integer)

returns (

ID integer)

as

begin

if (useid is not null) then ID=USEID;

else ID=GEN_ID(gen_filebody_id,1);

if ((FILENAME is NULL) or (FILENAME='')) then FILENAME='UNDEFINED';

INSERT INTO t_filebody(ID,BODY,FILENAME) VALUES(:ID,:BODY,:FILENAME);

suspend;

end^

和我得到一个异常：

Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

PreparedStatementCallback;

bad SQL grammar [SELECT ID FROM sp_NEWFILE(?,?,?)]; nested exception is org.firebirdsql.jdbc.field.TypeConversionException: Error converting to object.

版本： jaybird-jdk17-2.2.5; 来源：firebird2.5版本：2.5.1.26351.ds4-2ubuntu0.1;

2014-09-01

zond

+0

您能否包含完整的堆栈跟踪并指定您使用的Jaybird和Firebird版本？ –

2014-09-01 16:02:44