{{theTime}}

Search This Blog

Total Pageviews

JDBC rowset subclasses

JdbcRowSet - to encapsulate a result set or a driver that is implemented to use JDBC technology
CachedRowSet - disconnects from its data source and operates independently except when it is getting data from the data source or writing modified data back to the data source. This makes it a lightweight container for as much data as it can store in memory.
FilteredRowSet - extends CachedRowSet and is used to get a subset of data
JoinRowSet - extends CachedRowSet and is used to get an SQL JOIN of data from multiple RowSet objects
WebRowSet - extends CachedRowSet and is used for XML data. It describes tabular components in XML using a standardized XML schema.

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...