> p1.setObject(1, binaryData);
> p2.setObject(1, otherBinaryData);
> p1.execute();
> p2.execute();

And similar with getting the BLOB data:

ResultSet rs = p1.executeQuery();

while(rs.next()) {
// 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,
Roman