Building a RESTful API with Spring Boot: From Database to Endpoints

Spring Boot REST API Implemantation Project Configuration Spring Setup The project is initialized using Spring Initializr at https://start.spring.io/. The following properties are configured in the application.properties file: spring.datasource.url=jdbc:mysql://localhost:3306/personnel_directory spring.datasource.username=admin spring.datasourc ...

Posted on Sun, 05 Jul 2026 16:26:11 +0000 by j3rmain3

Troubleshooting MyBatis and MyBatis-Plus Mapper Binding Failures

When working with MyBatis or MyBatis-Plus in Spring Boot applications, encountering "Invalid bound statement (not found)" exceptions typically indicates that mapper interfaces cannot locate their corresponding XML mapping files. This guide outlines common misconfigurations and their solutions. Mapper Location Configuration The primary ...

Posted on Fri, 03 Jul 2026 16:18:29 +0000 by ident

Comprehensive Guide to Exception Handling in Spring Web MVC

Exception management is a critical aspect of web applications, requiring attention on both client and server sides. For robust systems, implementing exception handling at both ends is recommended. This article focuses specifically on managing HTTP request exceptions on the server side using Spring's Web MVC framework. Common Exception Types Whe ...

Posted on Thu, 02 Jul 2026 16:57:51 +0000 by mrmigu

Implementing Stateless Authentication with JSON Web Tokens in Spring Boot 2.x

Transitioning from Session-Based to Stateless Authentication Traditional HTTP sessions maintain user state directly on the server. During authentication, the server creates a session object, persists it in memory or a shared cache, and returns a session identifier embedded in a client-side cookie. Every subsequent request automatically attaches ...

Posted on Mon, 29 Jun 2026 17:00:30 +0000 by shashiku

Spring Boot Development Workflow: From Setup to API Implementation

Backend Development Framework Architecture Overview: Client sends HTTP request to Controller layer Controller receives the request and passes data to Service layer Service layer handles business logic, may interact with DAO layer for database operations or Client layer for remote service calls DAO layer executes database operations and returns ...

Posted on Fri, 26 Jun 2026 17:27:05 +0000 by mlcheatham

Spring Boot Configuration Loading Order and YAML Essentials

Internal Configuration Resolution Order File-name precedence bootstrap.yml (or bootstrap.properties) is processed before any application.* file. application.yml (or application.properties) is processed next. Directory precedence (highest → lowest) ./config/ – a config folder in the project root ./ – the project root itself classpath:/config/ ...

Posted on Thu, 25 Jun 2026 17:51:30 +0000 by 4evernomad

Batch IP Geolocation Enrichment Using CSV and REST APIs

When tasked with enriching a dataset of IP addresses with geographic metadata—such as country, province, and city—the priority is rapid, reliable execution. This scenario involved processing several hundred IP records stored in a Excel file, converting them to CSV for simplicity, then calling an external geolocation API to append loccation deta ...

Posted on Wed, 24 Jun 2026 18:23:17 +0000 by Hi I Am Timbo

Understanding Druid Database Connection Pool Internals and Configuration

Database connection pooling is a foundational optimization in modern Java applications, especially within Spring Boot ecosystems. Misconfigurations or misunderstandings of pool behavior frequently lead to subtle production issues — such as stale connections, timeouts, or resource exhaustion — even among seasoned developers. Why Connection Pools ...

Posted on Wed, 24 Jun 2026 18:04:01 +0000 by bcamp1973

Integrating MongoDB with Spring Boot for Data Persistence

Project Dependencies To begin, configure the pom.xml file with the necessary dependencies for Spring Boot, MongoDB integration, and Lombok to reduce boilerplate code. <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0"> <modelVersion>4.0.0</modelVersion ...

Posted on Mon, 22 Jun 2026 18:02:18 +0000 by cheald

Database Sharding and User Registration Implementation for a Train Booking System

User Table Structure The original table structure is designed as follows. Due to the large user base, database sharding becomes necessary. Sharding Strategy Design Based on the system design assumptions, the 12306 system needs to support approximately 1 billion registered users, with roughly 10 million new users annually. Before implementing da ...

Posted on Sat, 20 Jun 2026 16:47:10 +0000 by ari_aaron