Cheatsheet Persistence

Fondasi persistence layer sebagai boundary antara Java/JAX-RS application logic dan PostgreSQL/database state.

Driver, Connection, Statement, ResultSet, and Transaction Primitive

Fondasi JDBC sebagai primitive utama akses database Java dan dasar dari MyBatis, JPA, dan Hibernate.

Pool Size, Timeout, Leak Detection, and Kubernetes Replica Math

27 min

Connection pool sebagai shared runtime resource antara Java/JAX-RS service dan PostgreSQL, termasuk sizing, timeout, leak detection, pool exhaustion, dan Kubernetes replica math.

MVCC, Locks, Isolation, Planner, JSONB, and Timeout Semantics

24 min

Perilaku PostgreSQL yang langsung memengaruhi correctness, transaction boundary, locking, query performance, migration safety, dan production debugging persistence layer.

SQL-First Mapping, Mapper Interface, XML, SqlSession, and ResultMap

MyBatis sebagai SQL-first persistence mapper untuk Java/JAX-RS enterprise systems, termasuk mapper interface, XML, SqlSession, ResultMap, parameter mapping, TypeHandler, dynamic SQL, dan transaction integration.

Mapper Interface, XML Organization, Naming, Parameters, and Ownership

Desain mapper interface dan XML yang maintainable, ownership-aware, SQL-visible, transaction-aware, dan aman untuk enterprise production review.

ResultMap, Constructor Mapping, Association, Collection, and TypeHandler

ResultMap, constructor mapping, association, collection, nested query, custom TypeHandler, JSONB/array mapping, null handling, and column aliasing for production-grade MyBatis usage.

if, choose, where, trim, foreach, bind, Sorting, Filtering, and Injection Risk

Dynamic SQL MyBatis untuk filtering, sorting, pagination, optional parameter, IN clause, update statement, dan query composition dengan security, readability, and performance discipline.

JSONB, Arrays, Functions, Procedures, RETURNING, UPSERT, SKIP LOCKED, and Advisory Locks

Menggunakan fitur PostgreSQL advanced melalui MyBatis: JSONB, full-text search, array, enum, function, procedure, trigger awareness, RETURNING, UPSERT, SKIP LOCKED, dan advisory lock dengan transaction, correctness, performance, testing, dan review discipline.

EntityManager, Persistence Context, Unit of Work, Lifecycle, Flush, and Dirty Checking

Fondasi JPA/Jakarta Persistence sebagai ORM specification untuk entity lifecycle, EntityManager, persistence context, unit of work, flush, dirty checking, transactional write-behind, dan dampaknya pada Java/JAX-RS backend dengan PostgreSQL.

Session, Proxy, Lazy Loading, Dirty Checking, Flush Mode, and Cache

27 min

Hibernate-specific behavior di balik JPA: Session, persistence context, proxy, lazy loading, dirty checking, flush mode, first-level cache, second-level cache, query cache, configuration, dan failure mode yang sering muncul pada Java/JAX-RS backend dengan PostgreSQL.

Table, Column, Id, Sequence, Enum, Converter, Version, Timestamp, and Soft Delete

24 min

Mapping entity JPA/Hibernate ke schema PostgreSQL: @Entity, @Table, @Column, @Id, @GeneratedValue, sequence, identity, embedded value, enum, converter, AttributeConverter, @Version, timestamp, soft delete, immutable entity, dan checklist review mapping production-grade.

OneToMany, ManyToOne, Join Ownership, Cascade, Orphan Removal, and Fetch Strategy

Relationship mapping yang aman, eksplisit, dan tidak menciptakan N+1 atau cascade surprise dalam Java/JAX-RS enterprise service.

JPQL, Criteria API, Native Query, Projection, Entity Graph, Fetch Join, and Bulk Operations

Strategi query JPA dari JPQL sampai native query dengan SQL visibility, transaction awareness, dan production review discipline.

N+1, Fetch Join, Entity Graph, Batch Fetching, JDBC Batching, and Dirty Checking Cost

Performance tuning Hibernate dari fetching strategy, batching, persistence context size, dirty checking cost, cache, sampai SQL/query-plan visibility.

Flush Timing, Merge Surprise, Stale State, Unexpected Update, and Hidden SQL

14 min

Failure mode JPA yang muncul dari state management tersembunyi: flush timing, dirty checking, merge surprise, stale state, unexpected update, dan hidden SQL.

Explicit SQL vs Persistence Context Driven State Management

Perbedaan fundamental antara MyBatis sebagai SQL-first mapper dan JPA/Hibernate sebagai entity-first unit-of-work dengan persistence context.

When to Use JDBC, MyBatis, or JPA/Hibernate

Framework pemilihan JDBC langsung, MyBatis, atau JPA/Hibernate berdasarkan use case, query complexity, transaction correctness, schema shape, performance, dan operational risk.

Coexistence by Bounded Context, Module, Schema, Use Case, and Transaction Manager

Governance coexistence MyBatis dan JPA dalam satu service atau ecosystem tanpa menciptakan duplicate persistence model, stale state, cache conflict, atau transaction surprise.

Same Table, Same Aggregate, Same Transaction, Stale State, and Cache Conflict

Analisis kapan MyBatis dan JPA dalam use case yang sama masih defensible, dan kapan menjadi anti-pattern yang memicu stale state, cache conflict, duplicate write model, dan transaction ordering bug.

Read/Write Separation, Projection Queries, Explicit Flush, Clear, and Ownership Documentation

Pola aman ketika MyBatis dan JPA harus hidup berdampingan dalam enterprise Java/JAX-RS service tanpa merusak transaction correctness, cache consistency, dan ownership persistence model.

Two Write Models, Bypassed Entity State, Hidden Flush, Duplicate Validation, and Inconsistent Filters

Anti-pattern utama ketika MyBatis dan JPA/Hibernate dipakai bersama tanpa ownership, transaction ordering, cache discipline, dan invariant consistency yang jelas.

Repository, DAO, Mapper Boundary, EntityManager Boundary, and Read/Write Separation

Boundary design antara service/application layer dan data access implementation dalam Java/JAX-RS enterprise systems.

API DTO, Domain Model, JPA Entity, MyBatis Projection, Command Model, and Mapping Ownership

Pemisahan model API, domain, persistence, command, query, dan read model dalam Java/JAX-RS enterprise systems.

ACID, Commit, Rollback, Savepoint, Local Transaction, Declarative and Programmatic Transaction

23 min

Transaction boundary sebagai unit correctness utama di persistence layer Java/JAX-RS enterprise systems.

REQUIRED, REQUIRES_NEW, SUPPORTS, NOT_SUPPORTED, MANDATORY, NEVER, NESTED, and Self-Invocation

23 min

Propagation semantics, nested transaction caveat, savepoint, self-invocation, dan visibility transaction boundary dalam Java/JAX-RS enterprise systems.

Read Committed, Repeatable Read, Serializable, Lost Update, Write Skew, SELECT FOR UPDATE, SKIP LOCKED, and Retry

Isolation level, concurrent write correctness, lost update, write skew, row locking, serialization failure, deadlock retry, dan concurrency review dalam Java/JAX-RS enterprise systems.

@Version, Manual Version Check, LockModeType, SELECT FOR UPDATE, NOWAIT, SKIP LOCKED, and Business Locks

Optimistic lock, pessimistic lock, manual version check, JPA LockModeType, SELECT FOR UPDATE, NOWAIT, SKIP LOCKED, lock timeout, deadlock, stale object, dan business-level locking.

SQLState, Constraint Violation, Deadlock, Serialization Failure, Timeout, and Retryability

21 min

SQLException, SQLState, constraint violation, deadlock, serialization failure, lock timeout, query timeout, JPA/Hibernate/MyBatis exception, domain error mapping, HTTP error mapping, dan retryable vs non-retryable error.

Bean Validation, Domain Invariant, Database Constraint, Lifecycle Callback, and Defense in Depth

24 min

Bean Validation, database constraint, domain invariant, application validation, JPA lifecycle callback, MyBatis validation boundary, NOT NULL, unique, check, foreign key, validation duplication, defense in depth, dan invariant placement checklist.

Created/Updated Fields, Version, Audit Table, Entity Listener, Trigger, Change History, and Outbox

Created by, created time, updated by, updated time, version, audit table, audit trigger, JPA auditing, MyBatis auditing, entity listener, database trigger, change history, event outbox, compliance/auditability, dan audit review checklist.

Deleted Flag, Tenant Filter, Effective Date, Validity Window, Catalog Version, and Hidden Data Bugs

13 min

Soft delete, deleted flag, deleted timestamp, tenant filter, temporal validity, effective date, valid from/valid to, catalog version, price effective date, JPA filter, MyBatis query condition, database constraint, hidden data bug, dan temporal review checklist.

Tenant ID, Schema/Database Strategy, Tenant Filters, RLS, Indexing, and Cache Isolation

13 min

Tenant ID, shared database shared schema, separate schema, separate database, tenant discriminator, tenant filter, row-level security, JPA multi-tenancy, MyBatis tenant condition, accidental cross-tenant query, tenant-aware index, tenant-aware cache, dan multi-tenancy review checklist.

Offset, Keyset, Cursor, Stable Ordering, Dynamic Sort, Count Query, and Injection Risk

Offset pagination, keyset pagination, cursor pagination, stable ordering, dynamic sorting, dynamic filtering, count query, large offset problem, MyBatis pagination, JPA pagination, Criteria query, SQL injection risk, API pagination contract, dan pagination review checklist.

JDBC Batch, MyBatis Batch Executor, JPA Batching, Bulk JPQL, Chunking, and Stale Context

Batch insert, batch update, batch delete, JDBC batch, MyBatis batch executor, JPA/Hibernate batching, bulk JPQL update, persistence context stale after bulk update, chunking, memory pressure, transaction size, retry strategy, dan batch operation review checklist.

Fetch Size, Cursor, MyBatis Cursor, JPA Stream, Connection Lifetime, and Backpressure

14 min

Streaming result, JDBC fetch size, cursor, MyBatis cursor, JPA stream, transaction requirement, connection held open, HTTP streaming, memory pressure, timeout, cancellation, backpressure, resource closing, dan large result review checklist.

Slow Query, EXPLAIN ANALYZE, Index Usage, Generated SQL, Logging, Redaction, and Regression

Slow query, EXPLAIN, EXPLAIN ANALYZE, index usage, join strategy, query plan, query generated by JPA, SQL written in MyBatis, safe SQL logging, parameter logging, PII redaction, query regression, dan performance review checklist.

Lazy Loading, Fetch Join, Entity Graph, Batch Fetching, Nested Select, DTO Projection, and Query Count

N+1 problem, lazy loading, eager loading, fetch join, entity graph, batch fetching, MyBatis nested select N+1, nested result, DTO projection, query count assertion, relationship loading strategy, dan N+1 review checklist.

First-Level Cache, Hibernate L2 Cache, MyBatis Cache, Redis Cache, Invalidation, and Transaction Coupling

14 min

Cache sebagai performance tool sekaligus sumber stale data, read-after-write anomaly, dan consistency bug pada persistence layer Java/JAX-RS enterprise.

CallableStatement, MyBatis Procedure Call, JPA Stored Procedure Query, Triggers, PL/pgSQL, and Hidden Business Logic

13 min

Database-side logic di PostgreSQL dan dampaknya terhadap persistence boundary, transaction correctness, migration discipline, testing, observability, dan code review.

Liquibase, Flyway, Versioned Migration, Expand-Contract, Entity/Mapper Mismatch, and Roll-Forward

Database migration sebagai kontrak evolusi schema dengan mapper, entity, transaction boundary, deployment pipeline, dan production data correctness.

Add, Rename, Drop, Type Change, Backfill, Dual-Read, Dual-Write, and Compatibility Window

Schema evolution aman untuk Java/JAX-RS services dengan rolling deployment, MyBatis/JPA compatibility, backfill, dual-read, dual-write, dan production correctness.

Unit, Integration, Testcontainers, Repository, Mapper, Transaction, Migration, Query, and Concurrency Tests

26 min

Strategi testing persistence layer untuk membuktikan mapping, migration, transaction, query correctness, concurrency behavior, dan production data safety.

Mapper Integration, SQL Syntax, ResultMap, Dynamic SQL Branch, TypeHandler, JSONB, Pagination, and Injection Guard

25 min

Testing MyBatis mapper, XML, ResultMap, dynamic SQL, TypeHandler, PostgreSQL-specific SQL, transaction behavior, locking, pagination, dan SQL injection guard.

Entity Mapping, Repository, JPQL, Native Query, N+1, Dirty Checking, Flush, and Lock Tests

Testing JPA/Hibernate entity mapping, repository, JPQL/native query, relationship loading, N+1, dirty checking, flush, optimistic/pessimistic locking, dan migration compatibility.

Database per Service, Shared Database Risk, Read Model, Reference Data, Saga, Compensation, and Ownership

Persistence layer dalam microservices: database per service, shared database risk, cross-service data query, reference data, read model, eventual consistency, saga, compensation, data ownership, schema ownership, migration ownership, dan service boundary.

Transactional Outbox, Inbox, Event Table, Idempotency Table, Kafka/RabbitMQ Publication, CDC, Debezium, and Reconciliation

Transactional consistency antara PostgreSQL writes dan event publication melalui outbox, inbox, idempotency table, Kafka/RabbitMQ publication, CDC, Debezium, polling publisher, replay, dan reconciliation.

Idempotency Key, Request Fingerprint, Response Replay, Processing State, Redis/PostgreSQL Store, and Unique Constraint

Persistence design untuk duplicate request, retry, timeout, idempotency key, request fingerprint, response replay, processing state, Redis/PostgreSQL idempotency, unique constraint, MyBatis/JPA implementation, dan duplicate submit prevention.

SQL Injection, Parameter Binding, Least Privilege, Read-Only User, Migration User, RLS, Encryption, and Redaction

Security risk pada persistence layer: SQL injection, parameter binding, dynamic SQL, least privilege DB user, schema permission, row-level security, sensitive data, encryption, log redaction, auditability, dan security review checklist.

PII, Masking, Tokenization, Encryption, Retention, Deletion, Audit Trail, Backup Privacy, and Test Data

Privacy dan compliance concern pada persistence layer: PII di database dan logs, masking, tokenization, encryption, data retention, deletion, audit trail, access traceability, backup privacy, test data privacy, data export, dan compliance evidence.

SQL Logs, Slow Query, Query Count, Pool Metrics, Transaction Duration, Lock Wait, Deadlock, Hibernate/MyBatis Metrics, and Alerting

Metrics, logs, traces, dashboards, dan alerting untuk persistence runtime pada Java/JAX-RS, JDBC, MyBatis, JPA/Hibernate, PostgreSQL, Redis cache, dan deployment Kubernetes/cloud.

Slow Endpoint, Pool Exhaustion, Deadlock, Lock Wait, Serialization Failure, Bad Plan, Failed Migration, Stale Context, and Cache Inconsistency

23 min

Runbook diagnosis untuk incident persistence layer di production: slow endpoint, pool exhaustion, deadlock, lock wait, serialization failure, bad query plan, failed migration, stale JPA persistence context, dan cache inconsistency.

Query Tuning, Index Tuning, Fetch Size, Batch Size, Pool Size, Transaction Duration, Fetch Strategy, Round Trip, and Memory

Tuning end-to-end persistence layer dari query, index, fetch size, batch size, connection pool, transaction duration, JPA fetch strategy, MyBatis SQL optimization, round trip, serialization cost, dan memory usage.

Pod Replica Math, Connection Storm, RDS/Aurora, Azure PostgreSQL, Private Endpoint, Secret Rotation, and Migration Jobs

Dampak Kubernetes, cloud PostgreSQL, replica count, connection pool per pod, rolling deployment, connection storm, network latency, private endpoint, secret rotation, database credential, dan migration job terhadap persistence layer.

Local PostgreSQL, Docker Compose, Testcontainers, Migration Startup, Seed Data, SQL Console, and SQL Debugging

Workflow lokal yang reproducible untuk debugging mapper, entity, migration, query, transaction, dan data correctness di persistence layer Java/JAX-RS enterprise.

Repository, Mapper, Entity, DTO, TypeHandler, Converter, Migration, Fixture, SQL Organization, and Code Ownership

Struktur package, folder, SQL, migration, fixture, converter, TypeHandler, repository, mapper, entity, dan ownership agar persistence layer scalable dan reviewable.

Repository, Mapper, Entity, Transaction, Query, Index, Migration, Mixing, Locking, Security, Observability, and ADR Questions

Checklist senior engineer untuk mereview perubahan repository, DAO, mapper, entity, transaction, query, index, migration, MyBatis/JPA mixing, security, observability, dan production readiness.

CRUD, Reporting, Batch, Stored Procedure, JSONB, Dynamic Search, Relationship Model, Legacy Schema, Audit, Outbox, and Read Model

Matriks final pemilihan JDBC, MyBatis, atau JPA/Hibernate berdasarkan CRUD, reporting, batch, stored procedure, JSONB, dynamic search, relationship-heavy domain, legacy schema, audit, outbox, dan read model.

Learn Schema, Mapper/Entity Structure, Transaction Convention, Query Performance, Locking, Migration Safety, and Review Quality