Dynamic DataSource Routing in Spring Boot for Multi-Tenancy

Returning your database Entity directly in your API is a ticking time bomb. Early in my career, I built a simple user profile API. To save time, I just returned the JPA User entity directly from the controller. It worked perfectly, the code was clean, and the PR was approved. A few months later, another developer added a password_hash and two_factor_secret column to the database table to support a new security feature. Because my API was returning the raw entity, it automatically started serializing those new columns. We were suddenly leaking password hashes directly to the frontend without even touching the controller code. After 9 years of building backend systems, this is my biggest pet peeve. Your database schema and your API contract should never, ever be the same thing. The Senior Fix: Use Data Transfer Objects (DTOs). Yes, it feels like boilerplate. Yes, it feels tedious to map an OrderEntity to an OrderResponseDTO. But that separation is what saves you in production. 1. Security: You explicitly control exactly which fields leave your server. 2. Versioning: You can completely refactor your database schema without breaking the mobile app that relies on your API response. 3. Immutability: With modern Java, you can use Records for your DTOs. They are immutable, require zero Lombok boilerplate, and are incredibly fast. Your database represents how data is stored. Your API represents how data is consumed. Don't mix the two. What is your preferred way to map Entities to DTOs in Java? Do you write it manually, or do you use a library like MapStruct? Let's debate below. 👇 #CleanCode #Java #SpringBoot #SoftwareEngineering #BackendDevelopment #API #LLD #SystemDesign

🚀 Built a Complete Spring Boot REST API with CRUD Operations I’m excited to share my latest project where I developed a RESTful API using Spring Boot and MySQL. This project demonstrates full CRUD functionality and follows a clean layered architecture. 🔧 Tech Stack: • Spring Boot • Spring Data JPA • MySQL • REST API • RAPID API (Testing) 📁 Architecture: Client → RestController → Service → Repository →Entity-> Database 📌 Features Implemented: ✅ Create Student (POST) ✅ Get All Students (GET) ✅ Get Student By ID (GET) ✅ Update Student (PUT) ✅ Delete Student (DELETE) 🔗 API Endpoints: POST /students GET /students GET /students/{id} PUT /students/{id} DELETE /students/{id} This project helped me understand: • REST API design • Layered architecture • Database integration using JPA • Testing APIs using RAPID API CLIENT Looking forward to feedback and suggestions! #SpringBoot #RESTAPI #Java #MySQL #BackendDevelopment #SpringDataJPA #Learning #CRUD #Developer

🚀 3-Layer Architecture in Spring Boot (Industry Standard) Every professional Spring Boot application follows a 3-layer architecture to keep code clean, scalable, and production-ready. 🔄 Flow: Client (Browser/Postman) → Controller → Service → Repository → Database 🔷 Controller Layer (@RestController) 👉 Handles HTTP requests & responses 👉 Defines API endpoints 🔷 Service Layer (@Service) 👉 Contains business logic 👉 Decides what actions to perform 🔷 Repository Layer (@Repository / JpaRepository) 👉 Communicates with database 👉 Performs CRUD operations using JPA/Hibernate 🗄️ Database (MySQL) 👉 Stores and manages application data 💡 Why it matters? ✅ Clean code structure ✅ Easy maintenance & debugging ✅ Scalable for real-world apps ✅ Industry best practice 📌 Example Flow: User sends request → Controller receives → Service processes → Repository fetches data → Response returned 🔥 In short: Controller = Entry 🚪 Service = Brain 🧠 Repository = Data 💾 #SpringBoot #Java #Backend #SoftwareArchitecture #SystemDesign #JPA #Hibernate #Developers #Coding

Most transaction bugs in Spring Boot are not SQL bugs—they’re transaction boundary bugs. Today’s focus is a deep dive into @Transactional: propagation, isolation, and rollback rules. If you only use the default settings everywhere, you may accidentally create hidden data inconsistencies or unexpected commits. Example: @Service public class PaymentService { @Transactional(propagation = Propagation.REQUIRED, isolation = Isolation.READ_COMMITTED, rollbackFor = Exception.class) public void processPayment(Order order) { paymentRepository.save(new Payment(order.getId(), order.getTotal())); inventoryService.reserve(order.getItems()); } } Key idea: REQUIRED joins an existing transaction or starts a new one, REQUIRES_NEW creates a separate one, and isolation controls visibility of concurrent changes. By default, rollback happens for unchecked exceptions, so checked exceptions often need explicit rollbackFor. Treat @Transactional as an architectural decision, not just an annotation. #Java #SpringBoot #BackendDevelopment

Most transaction bugs in Spring Boot are not SQL bugs—they’re transaction boundary bugs. Today’s focus is a deep dive into @Transactional: propagation, isolation, and rollback rules. If you only use the default settings everywhere, you may accidentally create hidden data inconsistencies or unexpected commits. Example: @Service public class PaymentService { @Transactional(propagation = Propagation.REQUIRED, isolation = Isolation.READ_COMMITTED, rollbackFor = Exception.class) public void processPayment(Order order) { paymentRepository.save(new Payment(order.getId(), order.getTotal())); inventoryService.reserve(order.getItems()); } } Key idea: REQUIRED joins an existing transaction or starts a new one, REQUIRES_NEW creates a separate one, and isolation controls visibility of concurrent changes. By default, rollback happens for unchecked exceptions, so checked exceptions often need explicit rollbackFor. Treat @Transactional as an architectural decision, not just an annotation. #Java #SpringBoot #BackendDevelopment

Day 14. My API worked perfectly. Until it hit 100 users. I had this: List<Order> orders = orderRepository.findAll(); for (Order order : orders) {   System.out.println(order.getUser().getName()); } Because of queries I didn’t even know existed. Looks clean. It’s not. Here’s what was actually happening: → 1 query to fetch all orders → 1 query per order to fetch the user → 100 orders = 101 queries hitting your database That’s the N+1 problem. And it hides in plain sight. Your code looks clean. Your database is suffering. And you probably have this in your codebase right now. The fix is simple: Fetch what you need. In one query. @Query("SELECT o FROM Order o JOIN FETCH o.user") List<Order> findAllWithUser(); One query. One JOIN. Everything loaded together. What actually changes: → Performance — 101 queries becomes 1 → Scalability — works at 100 rows, breaks at 100,000 → Visibility — you won’t notice until production The hard truth: → ORMs make it easy to write slow code → Lazy loading is convenient until it isn’t → You need to know what SQL your code is generating Writing code that works is easy. Writing code that doesn’t silently destroy your database is the real skill. Are you logging your SQL queries in development? If not — you should be. 👇 Drop it below #SpringBoot #Java #Hibernate #BackendDevelopment #JavaDeveloper

🚀 Deep Internal Flow of a REST API Call in Spring Boot 🧭 1. Entry Point — The Gatekeeper DispatcherServlet is the front controller. Every HTTP request must pass through this single door. FLOW: Client → Tomcat (Embedded Server) → DispatcherServlet 🗺️ 2. Handler Mapping — Finding the Target DispatcherServlet asks: “Who can handle this request?” It consults: * RequestMappingHandlerMapping This scans: * @RestController * @RequestMapping FLOW : DispatcherServlet → HandlerMapping → Controller Method Found ⚙️ 3. Handler Adapter — Executing the Method Once the method is found, Spring doesn’t call it directly. It uses: * RequestMappingHandlerAdapter Why? Because it handles: * Parameter binding * Validation * Conversion FLOW : HandlerMapping → HandlerAdapter → Controller Method Invocation 🧭 4. Request Flow( Forward ): Controller -> Service Layer (buisiness Logic) -> Repository Layer -> DataBase 🔄 5. Response Processing — The Return Journey Now the response travels back upward: Repository → Service → Controller → DispatcherServlet -> Tomcat -> Client. ———————————————— ⚡ Hidden Magic (Senior-Level Insights) 🧵 Thread Handling * Each request runs on a separate thread from Tomcat’s pool 🔒 Transaction Management * Managed via @Transactional * Proxy-based AOP behind the scenes 🎯 Dependency Injection * Beans wired by Spring IoC container 🧠 AOP (Cross-Cutting) * Logging, security, transactions wrapped around methods ⚡ Performance Layers * Caching (Spring Cache) * Connection pooling (HikariCP) ———————————————— 🧠 The Real Insight At junior level i thought: 👉 “API call hits controller” At senior level i observe: 👉 “A chain of abstractions collaborates through well-defined contracts under the orchestration of DispatcherServlet” #Java #SpringBoot #RestApi #FullStack #Developer #AI #ML #Foundations #Security

🌟 Understanding Entity, Repository, and Service Layers in Spring Boot 📌 A well-structured Spring Boot application follows a layered architecture to ensure clean, maintainable, and scalable code. 👉 Entity Layer Represents the database structure. It defines how data is stored using annotations like @Entity and @Id. 👉 Repository Layer Handles database operations. Using Spring Data JPA, it provides built-in methods like save, find, and delete without writing SQL. 👉 Service Layer Contains the business logic of the application. It processes data, applies rules, and connects the controller with the repository. -->A well-structured application using these layers ensures clean code, scalability, and maintainability, which are essential for real-world backend development. #SpringBoot #Java #BackendDevelopment #SoftwareArchitecture #LearningInPublic

#Post5 In the previous post, we saw how @RequestBody helps us handle request data. Now the next question is 👇 How do we get data from the URL? There are two common ways: • @PathVariable • @RequestParam Let’s understand 👇 👉 @PathVariable Used when the value is part of the URL path Example: GET /users/10 @GetMapping("/users/{id}") public String getUser(@PathVariable int id) { return "User id: " + id; } 👉 @RequestParam Used when the value comes as a query parameter Example: GET /users?id=10 @GetMapping("/users") public String getUser(@RequestParam int id) { return "User id: " + id; } 💡 Key difference: @PathVariable → part of URL @RequestParam → query parameter Key takeaway: Use the right approach based on how data is passed in the request 👍 In the next post, we will explore exception handling in Spring Boot 🔥 #Java #SpringBoot #BackendDevelopment #RESTAPI #LearnInPublic

Are you still loading everything into memory? Let me ask you something. How many times have you seen this in a codebase? repository.findAll() ☠️ Looks harmless, right? Until it isn’t. That single line can: • Pull millions of records into memory • Fill your Hibernate context • Trigger massive GC pressure • And eventually… crash your application This is not a performance issue. This is an architectural flaw. Most systems don’t fail because of complexity. They fail because of unbounded data processing. You are not controlling how much data your system loads, processes, or returns. And memory… has limits. So what’s the right approach? Stop thinking: "How do I get all the data?" Start thinking: "How do I guarantee I NEVER load too much?" The solution is simple (but often ignored): • Use pagination for APIs • Use streaming for large exports • Process data in controlled chunks • Return DTOs instead of heavy entities • Set hard limits Golden rule: Never load, process, or serialize everything at once. Always paginate, stream, or limit. Most production outages I’ve seen had one thing in common: Someone assumed the data would always be small. It never is. #SoftwareArchitecture #Java #SpringBoot #DistributedSystems #SoftwareEngineering #DesignPatterns