PreparedStatement#setBlob(int, InputStream) is not supported in DefaultLobCreator [SPR-12265]

[spring-projects-issues]

Kazuki Shimizu opened SPR-12265 and commented

I hope that following methods will be supported in the DefaultLobCreator.
(methods that the data will be read from the stream as needed until end-of-file is reached.)

1. PreparedStatement#setBlob(int, InputStream)
2. PreparedStatement#setClob(int, Reader)
3. PreparedStatement#setBinaryStream(int, InputStream)
4. PreparedStatement#setAsciiStream(int, InputStream)
5. PreparedStatement#setCharacterStream(int, Reader)

For example...
if contentLength is negative(-1), call method of without length.

How do think ?

---

Affects: 3.2.11, 4.0.7, 4.1 GA

Issue Links:

• INSERT SELECT of large CLOB causes ORA-01461 on setString [SPR-12240] #16854 INSERT SELECT of large CLOB causes ORA-01461 on setString

[spring-projects-issues]

Juergen Hoeller commented

Good idea! As of 4.1.1, we're calling the JDBC 4.0 set-stream variants without a length parameter if the specified content length is negative.

Juergen

[spring-projects-issues]

Kazuki Shimizu commented

Thank you for quickly resolving :D !!

[spring-projects-issues]

Kazuki Shimizu commented

Might be better that there is a constant such as the following.

For example:

public interface LobCreator extends Closeable {
    int CONTENT_LENGTH_OF_EOF = -1;
    // ... (omitted)
}

public void setNonNullParameter(PreparedStatement ps, int i, InputStream parameter, JdbcType jdbcType) throws SQLException {
    lobHandler.getLobCreator().setBlobAsBinaryStream(ps,i,parameter,LobCreator.CONTENT_LENGTH_OF_EOF);
}

How do think ?