Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I use CachedRowSet with JayBird?

April 26, 2017JayBird

0

Posted

Can I use CachedRowSet with JayBird?

1 Answer

0

Posted

Yes, but third party code must be used. CachedRowSet allows you to store a copy of a rowSet and disconnect from the Firebird server for processing. This is useful because it allows you to release a connection immediately after getting a rowSet instead of holding it open while the rowSet is processed. That allows the server to run more efficiently Two third-party implementations have been tested and seem to work the same. One is 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. See: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html Another is an open source project called jxutil: XDisconnectedRowSet — only requires one jar file, jxRowSet-0.8a.jar. See: http://sourceforge.net/projects/jxutil/ Depending on the intended use, it would be appropriate to study the licenses both implementations come under. Jxutil is LGPL (Limited Gnu Public License) software, while OracleC