LOBs are fully materialised

[marschall]

BLOBs, CLOBs and NCLOBs are fully materialised into a single byte[]/String. In the case of large content (imagine a file stored in a BLOB) this puts quite a lot of pressure on both the allocator and the heap. It also defeats the point of streaming. Consider the following use case:

try (InputStream stream = resultSet.getBlob("column_name").getBinaryStream()) {
    // stream content
}

[ajlam]

@marschall - Any suggestions on how to redesign this?

[marschall]

As far as I can tell the existing ServerResultSet#getBinaryStream and SQLServerResultSet#getCharacterStream methods provide streaming. One could imagine building a LOB implementation around these or their underlying concepts.

[Suraiya-Hameed]

Thanks @marschall! That was a good catch, we will redesign it in the future releases.

[AfsanehR-zz]

@marschall opened #172 regarding this issue.

[AfsanehR-zz]

closed by pr #172.
Thank you @marschall for pointing out this issue.