Hi,

> What if I wanted to have a ResultSet open for the life of a
> transaction?

This is against specification.

> Will connection.commit() close any result sets opened in that
> transaction?

Yes, this is Firebird's design.

What you can do, is to fetch the blob field (rs.getBlob), then close
the result set (here the blob is closed, i.e. all open input streams
are closed) and only then obtain input stream from the Blob. I haven't
tried this, but it should work. I will add more clean way to obtain
Blob that is not controlled by underlying result set (but this will be
JayBird specific).

BTW, current version of JayBird contains implementation for
Blob.length() and has FBBlob.FBBlobInputStream.seek(int).

Best regards,
Roman Rokytskyy