BatchPreparedStatementSetter and BLOB

[reachbadri]

Hi,

I am facing a problem when using JDBCTemplate.batchUpdate(sql,BatchPreparedStatemen tSetter ) and if the BatchPreparedStatementSetter sets a BLOB

I am using the following technique to set the blob in the setValues() method..
LobCreator lobCreator = new DefaultLobHandler().getLobCreator();
lobCreator.setBlobAsBytes(ps,5,bytes);

The message I am getting is

Error Message Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements

Thanks
Badri

[karldmoore]

I don't really know much about this, but you haven't actually said what the problem was.