16 janeiro 2023

Data Ingestion In Plain Java


  • build simple data ingestion design that will be using simple Java SDK
  • We will Read data from remote sources and write to Database.





09 janeiro 2023

Using CachedRowSet in JDBC


Understanding RowSet 
A row set contains all data from a result set, but it can be disconnected from the database. A row set may make a connection with a database and keep the connection open during its life cycle, in which case it is called connected row set. 

Understanding CachedRowSet
A CachedRowSet object is a container for rows of data that caches its rows in memory, which makes it possible to operate (scroll and update) without keeping the database connection open all the time.

A CachedRowSet object makes use of a connection to the database only briefly: while it is reading data to populate itself with rows, and again while it is committing changes to the underlying database. So the rest of the time, a CachedRowSet object is disconnected, even while its data is being modified. Hence it is called disconnected row set.




Sourcecodejava.net