Coding

MyBatis – persistence framework

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 ORMIdiomatic persistence for Java and relational databases
MyBatisPersistence framework with custom SQL and stored procedures
Apache CayenneProvides object-relational mapping (ORM) and remoting services
jOOQjOOQ Object Oriented Querying
DataNucleusSupports JDO and JPA API's for persistence
Apache OpenJPAJava persistence project
EbeanDesigned to be simpler to use and understand than JPA or JDO products
EclipseLinkPersistence solution addressing relational, XML, and database web services
PersismLightweight, auto discovery, autoconfiguration ORM

Read our verdict in the software roundup.


Best Free and Open Source Software Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.

This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk.

You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more.

Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form.
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments