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.

Source: i-sammy.medium.com
Code: github.com/imsurajmishra

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.

Source: codejava.net

WebAtricle - Configuring JDBC in TomEE

Source. tomitribe4.wpengine.com

WebArticle - JDBC Driver Maven dependency list

Source: vladmihalcea.com

Book - High-Performance Java Persistence

About the book

This book is a journey into Java data access performance tuning. From connection management, to batch updates, fetch sizes and concurrency control mechanisms, it unravels the inner workings of the most common Java data access frameworks.
The first part aims to reduce the gap between application developers and database administrators. For this reason, it covers both JDBC and the database fundamentals that are of paramount importance when reducing transaction response times.
The second part demonstrates how you can take advantage of JPA and Hibernate without compromising application performance.
The third part is dedicated to jOOQ and its powerful type-safe querying capabilities, like window functions or common table expressions.

More information in:

• Author page
• Book page

Web Article - JDBC Batch Update Example

Approach 1: Jdbc Batch Update using Statement object

Approach 2: Jdbc Batch Update using PreparedStatement

Source: javacodegeeks.com

JDBC Tutorial

JDBC Tutorial


Mysql
MySQL Installation
MySQL Workbench

JDBC Basics
JDBC Introduction
JDBC Architecture
JDBC : Steps to Connect to the Database
JDBC Demo
JDBC : DriverManager
JDBC Connection
JDBC Connection Demo

JDBC Statement & PreparedStatement
JDBC Statement
JDBC PreparedStatement
JDBC PreparedStatement Demo

JDBC ResultSet

JDBC ResultSet
JDBC ResultSet Demo
JDBC Scrollable ResultSet
JDBC Scrollable ResultSet Demo

JDBC ResultSetMetadata

JDBC ResultSetMetadata
JDBC ResultSetMetadata Demo

JDBC DatabaseMetadata

JDBC DatabaseMetadata
JDBC DatabaseMetadata Demo

JDBC Create|Read|Update|Delete Records

JDBC Insert Record Demo
JDBC Update Records Demo
JDBC Read Records Demo
JDBC Delete Records Demo
JDBC Where Clause Demo
JDBC Like Clause Demo
JDBC Sorting Data Demo

Source: ramj2ee