MyBatis is a persistence framework with support for custom SQL, stored procedures and advanced mappings.
MyBatis eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results. MyBatis can use simple XML or Annotations for configuration and map primitives, Map interfaces and Java POJOs (Plain Old Java Objects) to database records.
This is free and open source software.
Key Features
- Maps Java methods to SQL statements.
- Provides a mapping engine that maps SQL results to object trees in a declarative way
- Use all your database functionality like stored procedures, views, queries of any complexity and vendor proprietary features. It is often a good choice for legacy or de-normalized databases or to obtain full control of SQL execution.
- Simplifies coding compared to JDBC. SQL statements are executed with a single line.
- Integrates with Spring Framework and Google Guice.
- Supports declarative data caching. A statement can be marked as cacheable so any data retrieved from the database will be stored in a cache and future executions of that statement will retrieve the cached data instead hitting the database. MyBatis provides a default cache implementation based on a Java HashMap and default connectors for integrating with: OSCache, Ehcache, Hazelcast and Memcached. It provides an API to plug other cache implementations.
Website: mybatis.org/mybatis-3
Support: Documentation , Mailing Lists, GitHub Code Repository
Developer: The MyBatis team
License: Apache License Version 2.0
MyBatis is written in Java. Learn Java with our recommended free books and free tutorials.
Related Software
| Java Object-Relational Mapping Software | |
|---|---|
| Hibernate ORM | Idiomatic persistence for Java and relational databases |
| MyBatis | Persistence framework with custom SQL and stored procedures |
| Apache Cayenne | Provides object-relational mapping (ORM) and remoting services |
| jOOQ | jOOQ Object Oriented Querying |
| DataNucleus | Supports JDO and JPA API's for persistence |
| Apache OpenJPA | Java persistence project |
| Ebean | Designed to be simpler to use and understand than JPA or JDO products |
| Jimmer | Modern ORM for Java and Kotlin |
| EclipseLink | Persistence solution addressing relational, XML, and database web services |
| Persism | Lightweight, auto discovery, autoconfiguration ORM |
Read our verdict in the software roundup.
Explore our carefully curated directory of recommended free and open source software, covering every major software category.The directory forms part of our extensive collection of articles for Linux enthusiasts. It includes hundreds of detailed reviews, together with free and open source alternatives to proprietary software from companies such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. LinuxLinks also covers interesting projects worth exploring, Linux-compatible hardware, free programming books and tutorials, and much more. Know a useful free and open source Linux application that we haven’t covered? Tell us about it using our submission form. |


Please read our Comment Policy before commenting.