Subject RE: [Firebird-Java] Re: Closing ResultSet
Author Natal Vande Casteele
Hello,

> Hi,
>
> > CachedRowSet did indeed provide an easy solution. I can confirm that
> > it
> > works with JayBird. :-)
>
> These are quite good news.
>
> I know a CachedRowSet implementation is not provided within Sun's JDK.
> I've been looking for any available implementation but I don't know
> which could be the best choice. Any suggestions?
>
> Thank you in advance.

The one from Sun was supposedly available for download at one time but I
failed to locate it.

I've tested 2 third party implementations -- both seem to work exactly
the same.

One from Oracle: OracleCachedRowSet -- it doesn't require an Oracle
database but does require the Oracle JDBC jar file. You need both
ocrs12.zip and ojdbc14.jar.
http://technet.oracle.com/sample_code/tech/java/codesnippet/jdbc/rs/Coun
tResult.html

An open source project called jxutil: XDisconnectedRowSet -- only
requires one jar file, jxRowSet-0.8a.jar.
http://sourceforge.net/projects/jxutil/

Greetings,
Natal Vande Casteele
Software Engineer
Pocket and Soul