Search⌘ K
AI Features
Home
Courses
Spring Data: Bridging Multiple Databases

MyBatis Integration

Explore how to integrate MyBatis with Spring Data JDBC by configuring mappers and using @Mapper, @Select, and @Insert annotations. Understand managing SQL queries and transactions for seamless data access using BookMapper and AuthorMapper interfaces.

We'll cover the following...

Integrating MyBatis with Spring Data JDBC involves configuring the MyBatis SQL mapper framework alongside the Spring Data JDBC repository infrastructure. This allows seamless SQL-based data access using MyBatis annotations or XML mappings while leveraging the transaction management and other features provided by Spring Data JDBC.

The mybatis-spring-boot-starter dependency

First, we add the required mybatis-spring-boot-starter (a Spring Boot starter dependency for MyBatis that includes mybatis, mybatis-spring, and mybatis-spring-boot-autoconfigure dependencies) dependency to our Spring Data JDBC project’s build.gradle file.

TypeScript 4.9.5
plugins {
    id 'java'
    id 'org.springframework.boot' version '3.0.2'
    id 'io.spring.dependency-management' version '1.1.0'
}
group = 'com.smartdiscover'
version = '0.0.1-SNAPSHOT'
sourceCompatibility = '17'
repositories {
    mavenCentral()
}
dependencies {
    implementation 'org.springframework.boot:spring-boot-starter-data-jdbc'
    implementation "org.mybatis.spring.boot:mybatis-spring-boot-starter:3.0.1"
    implementation 'org.projectlombok:lombok:1.18.26'
    annotationProcessor 'org.projectlombok:lombok'
    runtimeOnly 'com.h2database:h2'
}
...