What benefits MyBatis provides over working with plain JDBC

java sql jdbc ibatis mybatis
Gili Nachum picture Gili Nachum · Apr 24, 2012 · Viewed 7.6k times · Source

I need to write pretty straight forward DB code and I'm considering MyBatis over plain JDBC (I believe full ORM is an overkill).

Considering that in both MyBatis and plain JDBC you find yourself:

  1. Hand writing SQL statements.
  2. Manually wiring DB rows to JAVA DTO objects (either via code or config).

The MyBatis benefits over JDBC I know of are:

  1. Out-of-the-box table/query caching.
  2. Dynamic SQL.
  3. SQL is stored outside of the code.
  4. Templating SQL for easier DB vendor Independence.

What other MyBatis-Over-JDBC benefits are there to consider?

Answer

Anuj Patel picture Anuj Patel · Jun 9, 2012

I dont know you'll count this one as advantage or not but there's MyBatisGenerator, And It generates all basic needed Queries plus some Advanced Queries too and DTO objects automatically based on a single XML file.

Plus it has Eclipse Plugin For the same.

Related questions

How do I get the size of a java.sql.ResultSet?

Shouldn't this be a pretty straightforward operation? However, I see there's neither a size() nor length() method.

Read More
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname

I have this Java program: MySQLConnectExample.java import java.sql.*; import java.util.Properties; public class MySQLConnectExample { public static void main(String[] args) { Connection conn1 = null; Connection conn2 = null; Connection conn3 = null; try { String url1 = "jdbc:mysql://localhost:3306/aavikme"; String …

Read More
How to get the insert ID in JDBC?

I want to INSERT a record in a database (which is Microsoft SQL Server in my case) using JDBC in Java. At the same time, I want to obtain the insert ID. How can I achieve this using JDBC API?

Read More