Java JDBC CachedRowSet

Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database.


Sun Microsystems released JDBC as part of Java Development Kit (JDK) 1.1 on February 19, 1997. Since then it has been part of the Java Platform, Standard Edition (Java SE; now from Oracle Corporation).

A set of rows obtained by executing a SQL SELECT statement in a database is known as a result set (ResultSet interface). The ResultSet can be updatable. The RowSet interface inherits from the ResultSet interface.
A ResultSet is not Serializable. A RowSet is Serializable, it can be sent over the network or saved to a disk for later use. A ResultSet is always connected to a data source. A RowSet object does not need to be connected to its data source all the time. It can connect to the database when needed such as to retrieve/update data in the data source. The two properties of a RowSet, serialization and connectionlessness, makes it very useful in a thin client environment such as a mobile device or a web application