How do I set up MyBatis with Spring Boot?

Integrate MyBatis with Spring Boot by adding the mybatis-spring-boot-starter dependency, configuring the datasource in application.properties, and using @MapperScan to detect mapper interfaces. Define SQL in XML files or annotations within mapper interfaces for seamless integration.

What's the difference between MyBatis and Hibernate?

MyBatis gives you full control over SQL with manual mapping, making it ideal for performance-tuning, while Hibernate is a full ORM that generates SQL and manages relationships automatically, better for rapid development. MyBatis requires more SQL knowledge, Hibernate abstracts it away.

Can I use MyBatis without XML configuration?

Yes, MyBatis supports annotations for SQL mapping, allowing you to define queries directly in Java interfaces using @Select, @Insert, etc. However, for complex or dynamic SQL, XML might still be preferred for better organization and reuse.

How does MyBatis handle performance compared to JPA?

MyBatis often outperforms JPA in read-heavy or complex query scenarios because you can optimize raw SQL directly. However, it lacks built-in caching and connection pooling features, requiring external setup for best performance.

What are common pitfalls when using MyBatis?

Common issues include N+1 query problems due to manual relationship handling, SQL injection risks if parameters aren't properly bound, and verbose XML files that can become hard to maintain. Regular code reviews and using MyBatis generators can mitigate these.

Is MyBatis good for microservices architectures?

Yes, MyBatis's lightweight nature makes it suitable for microservices where control over database interactions is crucial. However, consider the trade-off with more abstract ORMs for consistency across services, as MyBatis requires per-service SQL management.

Open-Awesome

MyBatis

Apache-2.0Javamybatis-3.5.19

A SQL mapper framework for Java that couples objects with SQL statements using XML or annotations.

Visit Website GitHub

20.4k stars12.9k forks0 contributors

What is MyBatis?

MyBatis is a SQL mapper framework for Java that facilitates database interactions by mapping Java objects to SQL statements and stored procedures. It solves the impedance mismatch between object-oriented applications and relational databases, giving developers precise control over SQL execution and result mapping. The framework uses XML descriptors or annotations to define these mappings, avoiding the complexity of full object-relational mapping (ORM) tools.

Target Audience

Java developers building applications that require fine-tuned SQL control, such as those working with complex queries, legacy databases, or performance-critical systems. It's also suitable for teams preferring explicit SQL over abstract ORM-generated queries.

Value Proposition

Developers choose MyBatis for its simplicity, flexibility, and transparency—it allows raw SQL usage while automating parameter setting and result mapping. Unlike heavy ORMs, it doesn't hide SQL, making optimization and debugging more straightforward.

Overview

MyBatis SQL mapper framework for Java

Use Cases

Best For

Applications needing explicit SQL control and optimization
Integrating with legacy databases or complex stored procedures
Projects where SQL transparency is preferred over ORM magic
Java systems requiring lightweight persistence without full ORM overhead
Teams that want to write and maintain SQL directly
Mapping complex query results to Java objects with custom logic

Not Ideal For

Projects requiring automatic database schema generation or migrations, as MyBatis focuses solely on SQL mapping without built-in DDL support.
Teams that prefer a full ORM with out-of-the-box features like lazy loading, change tracking, and complex relationship handling without manual SQL writing.
Applications where rapid prototyping with minimal configuration is key, since MyBatis requires setting up XML or annotation mappings for each query.

Pros & Cons

Pros

SQL Control and Flexibility

MyBatis allows developers to write and optimize raw SQL directly, providing fine-grained control over database interactions as emphasized in its flexible query philosophy.

Simplicity in Design

The framework prioritizes straightforward configuration and usage, avoiding complex abstractions, which is highlighted as its biggest advantage in the README.

Lightweight and Non-Intrusive

Unlike full ORMs, MyBatis has minimal overhead and doesn't impose heavy runtime costs, making it suitable for performance-sensitive applications without bloated dependencies.

Reduces Boilerplate Code

By automating parameter setting and result mapping through XML or annotations, MyBatis cuts down on repetitive JDBC code, simplifying database interactions.

Cons

Manual SQL Maintenance

Developers must write and maintain all SQL statements manually, which can be time-consuming, error-prone, and require ongoing optimization efforts in evolving projects.

Limited ORM Features

MyBatis lacks advanced ORM capabilities like automatic relationship management, lazy loading, and built-in caching, often necessitating custom implementations or third-party integrations.

XML Configuration Verbosity

While annotations are supported, XML descriptors for mapping can become lengthy and complex, increasing configuration overhead and potential for errors in large codebases.

Open Source Alternative To

MyBatis is an open-source alternative to the following products:

Hibernate

An object-relational mapping (ORM) tool for Java that provides a framework for mapping an object-oriented domain model to a relational database.

JPA implementations

JPA implementations are libraries that provide the actual functionality for the Java Persistence API specification, such as Hibernate, EclipseLink, and Apache OpenJPA.

Frequently Asked Questions

Related Projects

MyBatis-Plus

An powerful enhanced toolkit of MyBatis for simplify development

Stars17,414

Forks4,448

Last commit7 days ago

ObjectiveSql

Writing SQL using Java syntax

Stars1,260

Forks158

Last commit2 years ago

Doma

DAO oriented database mapping framework for Java

Stars503

Forks75

Last commit19 hours ago

SimpleFlatMapper

Fast and Easy mapping from database and csv to POJO. A java micro ORM, lightweight alternative to iBatis and Hibernate. Fast Csv Parser and Csv Mapper

Stars458

Forks78

Last commit10 months ago

Community-curated · Updated weekly · 100% open source

Found a gem we're missing?

Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.

Submit a project Star on GitHub