26 posts
Designing a Non-Business Day Table for Oracle

Non-business day table design in Oracle for business day calculations — weekend strategy, unique constraints, and code taxonomy.

Developmentoracledatabase-designbusiness-day-calculationtable-designholiday-api
Business Day Calculation with a Non-Business Day Table (Oracle)

Business day calculation done right: why a non-business day table beats a holiday-only table, plus batch sync with a government holiday API.

Developmentbusiness-dayoraclespring-batchholiday-apidatabase-design
Spring Boot favicon.ico 404 Fix — The Catch-All Controller Trap

Fix favicon.ico 404 or 500 errors in Spring Boot when a catch-all controller hijacks static resource requests. Diagnosis and Filter-based solution.

Developmentspring-bootfavicontroubleshootingstatic-resourcetomcatservlet-filter
SVN E155015: How to Fix 'Remains in Conflict' Commit Error

Fix SVN E155015 remains in conflict error caused by tree conflicts. Step-by-step resolution via terminal and IntelliJ.

Developmentsvntree-conflictversion-controlintellijtroubleshooting
Preventing IDOR in Spring MVC Parameter-Based Resource Access

When building Spring MVC features that accept a resource ID as a URL parameter, IDOR vulnerabilities are easy to miss. Here's how to catch and fix them.

Developmentspringsecurityidorjavabackend
Thymeleaf Ajax Search: Fragment Pattern and Common Mistakes

How to build Ajax-powered search pages in Spring MVC with Thymeleaf — fragment separation, the replaceWith() bug, DAO/DTO split, and MyBatis dynamic queries.

Developmentthymeleafspring-mvcmybatisajaxjava
How to Check Your Java Version via Terminal

Learn how to quickly check your installed Java version using the terminal with simple commands for developers.

Developmentjavadevelopmentclitutorialprogramming
Converting a Detail Query into a List Aggregate in Oracle SQL

How to convert a single-record Oracle SQL query into a per-entity aggregate for list views. Practical patterns with MyBatis and CTEs.

Developmentoraclesqlmybatisaggregatesubquery
Converting JS Functions to Java: 3 Patterns to Get Right

String comparison, array membership checks, and static constants — the three places where JS-to-Java conversions quietly break.

Developmentjavajavascriptstring-comparisonrefactoringbackend
Designing a Budget Visibility Feature for B2B Approval Workflows

How I designed a feature letting approvers view requesters' budgets in a B2B e-commerce platform, with lessons on scope control.

Developmentb2bbudget-managementapproval-workflowfeature-designscope-management
Oracle YYYYMMDD String Comparison: Skip TO_DATE Entirely

Oracle YYYYMMDD date strings can be compared without TO_DATE. Learn why lexicographic order equals chronological order and how to avoid ORA-01839.

Developmentoraclesqldate-comparisonyyyymmddtroubleshootingora-01839
How to Add a Favicon to Spring Boot + Thymeleaf

Add a favicon to your Spring Boot Thymeleaf project — from generation to Security config to fixing manifest BOM errors.

Developmentfaviconspring-bootthymeleafwebmanifestjava
Spring Session Redis OOM: Root Cause and Prevention

Spring Session throws OutOfMemoryError during Redis deserialization. Here's why it happens and how to fix it permanently with serializer changes and session trimming.

Developmentspring-sessionredisoomjavaserializationtroubleshooting
Thymeleaf: Show Product Option Next to Name in Cart

Three Thymeleaf patterns for displaying a product's selected option next to its name in a cart list — with proper null handling.

Developmentthymeleafspringjavatemplate-enginecart
Reading Complex Cart Logic in Java — Branching, APIs, and Delivery Fees

A step-by-step breakdown of a real Java cart DTO assembly method: multi-type branching, external API calls in loops, and delivery fee calculation strategy.

Developmentjavaspringcartecommercerefactoring
How to Decline B2B Data Requests Using System Policy

Stop wasting resources on unreasonable log retrieval requests. Learn how to professionally push back by leveraging privacy policies and system design.

Developmentbusinesscommunicationsoftware-engineeringsoftskills
Fix Slow Login Pages in Thymeleaf by Splitting Your Layout

How a shared Thymeleaf layout caused unnecessary DB queries and resource loading on a login page, and the simple layout split that fixed it.

Developmentthymeleafspringperformancelayout-dialectpage-speedfrontend-optimization
Can CSS Group Elements? DOM vs CSS Explained

Can CSS group elements into one container? Learn the difference between DOM structure and CSS, and how to properly group elements in real projects.

Developmentcssdomjavascriptfrontendlayout
Java DAO vs DTO: Roles, Rules, and Naming

Confused about DAO vs DTO in Java? Learn the difference, common mistakes, and the exact naming conventions your team expects.

Developmentjavadaodtonaming-conventionbackendclean-code
How to Search Logs with grep in Linux

Learn how to search logs with grep in Linux, including file patterns, useful options, and real-world debugging techniques.

Developmentlinuxgreplog-analysisclidebugging
MyBatis #{param} Not Working in IntelliJ? Fix It

MyBatis #{param} fails in IntelliJ Database Console because it's not real SQL. Learn how to fix it using ? parameter binding correctly.

Developmentmybatisjdbcintellijsqldebugging
Oracle Hierarchy Query: Fix Menu Sorting with CONNECT BY

Oracle hierarchy query using CONNECT BY solves menu sorting issues that ORDER BY cannot handle. Learn the correct pattern for tree-structured data.

Developmentoraclesqlhierarchyconnectbydatabase
How to Find Oracle Synonym Target Tables

Learn how to query Oracle synonyms and find their target tables using ALL_SYNONYMS, including how to detect broken synonyms.

Developmentoraclesqldatabasesynonymmetadata
Spring Exception Logging: Find Errors Fast

Spring exception logging explained. Learn how to use stack traces and traceId to quickly find the root cause in production systems.

Developmentspringexceptionloggingbackenddebugging
Fix Thymeleaf null boolean error (SpEL issue)

Thymeleaf null boolean error happens when SpEL cannot convert null to boolean. Learn the root cause and how to fix it properly.

Developmentthymeleafspelspringnullbooleanerror
How to Fix ORA-02292 Foreign Key Constraint Errors
Development