Subject Re: Full BLOB support in auto-commit case
Author rrokytskyy
> p1.setObject(1, binaryData);
> p2.setObject(1, otherBinaryData);
> p1.execute();
> p2.execute();

And similar with getting the BLOB data:

ResultSet rs = p1.executeQuery();

while( {
// do something here

If we commit transaction after the first line and start another right
after commit, then result set traversal will be done in another
transaction which is not quite correct behavior. Therefore we cache
complete result set before we return from executeQuery() method.

Best regards,