Satish Varma

Satish is post graduated in master of computer applications and experienced software engineer with focus on Spring, JPA, REST, TDD and web development. Follow him on LinkedIn or Twitter or Facebook

Spring JdbcTemplate – get Auto-generated Keys

Examples on how to get auto-generated primary key ids using JdbcTemplate and SimpleJdbcInsert in Spring Jdbc. 1. Getting Auto-Generated...

Spring JdbcTemplate – In Clause with List of Values

The IN operator allows to specify multiple values in a WHERE clause. IN clause used to avoid multiple OR conditions. In this...

Spring Data JDBC – Query Derivation Examples

This is a quick guide that provides several examples to understand how to use Query Derivation/Query Methods in Spring Data JDBC.

Fix – EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0

"EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0" is a common error when working with Spring JdbcTemplate queryForObject() operation. In this guide...

Spring JdbcTemplate – Batch Insert/Update with maxPerformance

This guide provides examples on Batch Insert/Update using Spring JdbcTemplate and explains how to run batch Inserts asynchronously/concurrently to optimize performance to...

Spring JdbcTemplate – Call Stored Procedures/Functions

This guide demonstrates several examples on how to call Stored Procedures/Functions using Spring JdbcTemplate and SimpleJdbcCall. 1. Calling Stored...

Fix for – java.sql.SQLException: Invalid column index

When you are working with JDBC, "java.sql.SQLException: Invalid column index" is a common error that you will get often. Let's have a...

Spring JdbcTemplate – Pagination Examples

Spring JDBC don't have any built-in operations to support Pagination and Sorting. This is a quick guide on how to implement Pagination...

Spring JdbcTemplate – querying Complete Guide

Several examples on Spring JdbcTemplate query, queryForObject, queryForList, queryForMap, queryForRowSet operations. This is a complete guide to understand running query operations on...

Spring Boot – Loading Initial Data

Spring Boot provides several ways to load initial data. In this guide you will see configuration support for initializing data and load...

Stay in Touch