Spring Data Relational4.1.0

Spring Data Relational provides the core infrastructure for Spring Data modules that access relational databases. It serves as an umbrella project encompassing both Spring Data JDBC and Spring Data R2DBC, offering shared functionality, consistent abstractions, and a unified programming model for relational data access across both synchronous and reactive paradigms.

Spring Data JDBC

Spring Data JDBC makes it easy to implement JDBC-based repositories. This module deals with enhanced support for JDBC-based data access layers. It makes it easier to build Spring-powered applications that use data access technologies.

Features

• Based on the aggregate abstraction
• Annotation-based entity mapping
• Immutable entities
• Query derivation
• Custom queries via @Query annotations
• MyBatis integration
• Lifecycle callbacks
• Auditing

Spring Data R2DBC

Spring Data R2DBC makes it easy to implement R2DBC-based repositories. R2DBC stands for Reactive Relational Database Connectivity, a specification to integrate SQL databases using reactive drivers. Spring Data R2DBC applies familiar Spring abstractions and repository support for R2DBC. It makes it easier to build Spring-powered applications that use relational data access technologies in a reactive application stack.

Features

• functional API
• Template API via R2dbcEntityTemplate
• Support for an array of different databases: H2, MariaDB, Microsoft SQL Server, MySQL, jasync-sql MySQL, Postgres and Oracle
• Running statements for mapped entities using the Criteria API built on top of Spring Framework’s R2DBC DatabaseClient.
• Parameter binding using the native syntax.
• Result consumption: Update count, unmapped (Map<String, Object>), mapped to entities, extraction function.
• Reactive repositories using @Query annotated methods.
• Query derivation.