The usual
Furthermore, there is nothing to prevent the transaction that holds the java.sql.Blob/java.sql.Clob (as opposed to another transaction) from updating the underlying row. (The same problem exists with the getXXXStream methods.) Program applications to prevent updates to the underlying object while a java.sql.Blob/java.sql.Clob is open on it; failing to do this could result in undefined behavior.
Do not call more than one of the ResultSet getXXX methods on the same column if one of the methods is one of the following:
These methods share the same underlying stream; calling more than one
of these methods on the same column could result in undefined behavior.
For example:
The streams that handle long-columns are not thread safe. This means that if a user chooses to open multiple threads and access the stream from each thread, the resulting behavior is undefined.
Clobs are not locale-sensitive.