{"id":127379,"date":"2024-10-17T17:06:00","date_gmt":"2024-10-17T14:06:00","guid":{"rendered":"https:\/\/www.javacodegeeks.com\/?p=127379"},"modified":"2024-10-15T10:56:58","modified_gmt":"2024-10-15T07:56:58","slug":"spring-data-dynamicinsert-annotation-example","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/spring-data-dynamicinsert-annotation-example.html","title":{"rendered":"Spring Data DynamicInsert Annotation Example"},"content":{"rendered":"

1. Introduction<\/h2>\n

Spring Data JPA<\/a> supports common JPA<\/a> providers, e.g. Hibernate<\/a>, EclipseLink, etc. Hibernate pre-generates and caches static SQL insert statements that include every mapped column by default. The @org.hibernate.annotations.DynamicInsert<\/a> overwrites the default implementation and dynamically generates the insert SQL statement for non-null fields at runtime. In this example, I will demonstrate the Spring Data DynamicInsert<\/code> annotation with a simple Spring boot application.<\/p>\n

2. Setup<\/h2>\n

In this step, I will create a gradle project for Java 17 along with lombok<\/code>, Spring Data JPA, H2 database, and Junit<\/code> libraries. The project is generated by Spring initializer<\/a> with the details outlined in Figure 1.<\/p>\n

\n
\"Spring<\/a>
Figure 1 Create a Project<\/figcaption><\/figure>\n<\/div>\n

2.1 Generated Files<\/h3>\n

In this step, I will show three generated files. No modification is needed for this example.<\/p>\n

The generated build.gradle<\/code> file includes needed libraries.<\/p>\n

build.gradle<\/em><\/span><\/p>\n

plugins {\n\tid 'java'\n\tid 'org.springframework.boot' version '3.3.4'\n\tid 'io.spring.dependency-management' version '1.1.6'\n}\n\ngroup = 'org.jcg.zheng'\nversion = '0.0.1-SNAPSHOT'\n\njava {\n\ttoolchain {\n\t\tlanguageVersion = JavaLanguageVersion.of(17)\n\t}\n}\n\nconfigurations {\n\tcompileOnly {\n\t\textendsFrom annotationProcessor\n\t}\n}\n\nrepositories {\n\tmavenCentral()\n}\n\ndependencies {\n\timplementation 'org.springframework.boot:spring-boot-starter-data-jpa'\n\tcompileOnly 'org.projectlombok:lombok'\n\truntimeOnly 'com.h2database:h2'\n\tannotationProcessor 'org.projectlombok:lombok'\n\ttestImplementation 'org.springframework.boot:spring-boot-starter-test'\n\ttestRuntimeOnly 'org.junit.platform:junit-platform-launcher'\n}\n\ntasks.named('test') {\n\tuseJUnitPlatform()\n}<\/pre>\n
The generated DynamicinsertApplication.java<\/code> file.<\/p>\n
DynamicinsertApplication.java<\/em><\/span><\/p>\n
package org.jcg.zheng.dynamicinsert;\n\nimport org.springframework.boot.SpringApplication;\nimport org.springframework.boot.autoconfigure.SpringBootApplication;\n\n@SpringBootApplication\npublic class DynamicinsertApplication {\n\n\tpublic static void main(String[] args) {\n\t\tSpringApplication.run(DynamicinsertApplication.class, args);\n\t}\n\n}\n<\/pre>\n
The generated DynamicinsertApplicationTests.java<\/code> file.<\/p>\n
DynamicinsertApplicationTests.java<\/em><\/span><\/p>\n
package org.jcg.zheng.dynamicinsert;\n\nimport org.junit.jupiter.api.Test;\nimport org.springframework.boot.test.context.SpringBootTest;\n\n@SpringBootTest\nclass DynamicinsertApplicationTests {\n\n\t@Test\n\tvoid contextLoads() {\n\t}\n\n}\n<\/pre>\n
3. Spring Data DynamicInsert in Entity<\/h2>\n
In this step, I will create a DemoEntity.java<\/code> that annotates with @DynamicInsert<\/code>.<\/p>\n
DemoEntity.java<\/em><\/span><\/p>\n
package org.jcg.zheng.dynamicinsert.entity;\n\nimport org.hibernate.annotations.DynamicInsert;\n\nimport jakarta.persistence.Entity;\nimport jakarta.persistence.GeneratedValue;\nimport jakarta.persistence.GenerationType;\nimport jakarta.persistence.Id;\nimport jakarta.persistence.Table;\nimport lombok.Data;\n\n@Entity\n@Table(name = \"T_DEMOTABLE\")\n@DynamicInsert\n@Data\npublic class DemoEntity {\n\n\t@Id\n\t@GeneratedValue(strategy = GenerationType.IDENTITY)\n\tprivate Integer id;\n\n\tprivate String firstName;\n\n\tprivate String lastName;\n\n\tprivate String email;\n\n\tprivate Integer age;\n\n}\n<\/pre>\n