{"id":140733,"date":"2026-01-20T17:41:00","date_gmt":"2026-01-20T15:41:00","guid":{"rendered":"https:\/\/www.javacodegeeks.com\/?p=140733"},"modified":"2026-01-20T12:16:12","modified_gmt":"2026-01-20T10:16:12","slug":"inserting-blob-using-spring-jdbctemplate-example","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/inserting-blob-using-spring-jdbctemplate-example.html","title":{"rendered":"Inserting BLOB Using Spring JdbcTemplate Example"},"content":{"rendered":"

1. Introduction<\/h2>\n

BLOB (Binary Large Object) is a large object data type in the database system. BLOB could store documents, images, audio, or video files. For smaller BLOBs, setting a byte array directly in memory is ok. For large BLOBs, streaming is more memory efficient. In this example, I will demonstrate how to use JdbcTemplate<\/a> to insert and update a BLOB field in a PostgreSQL<\/a> database.<\/p>\n

2. Setup<\/h2>\n

In this step, I will create a Spring Boot (4.0.1) Java (21) project via Spring Initializer<\/a> with PostgreSQL<\/a>, Lombok<\/a>, and JPA <\/a>dependencies.<\/p>\n

2.1 Build.gradle<\/h3>\n

Here is the generated build.gradle<\/code> file.<\/p>\n

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

plugins {\n\tid 'java'\n\tid 'org.springframework.boot' version '4.0.1'\n\tid 'io.spring.dependency-management' version '1.1.7'\n}\n\ngroup = 'org.jcg.zheng.demo'\nversion = '0.0.1-SNAPSHOT'\ndescription = 'Demo project for BLOB'\n\njava {\n\ttoolchain {\n\t\tlanguageVersion = JavaLanguageVersion.of(21)\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 'org.postgresql:postgresql'\n  \tannotationProcessor 'org.projectlombok:lombok'\n \ttestImplementation 'org.springframework.boot:spring-boot-starter-data-jpa-test'\n \ttestRuntimeOnly 'org.junit.platform:junit-platform-launcher'\n}\n\ntasks.named('test') {\n\tuseJUnitPlatform()\n}\n<\/pre>\n
2.2 InsertBlobApplication<\/h3>\n
Here is the generated InsertBlobApplication.java<\/code> file.<\/p>\n
InsertBlobApplication.java<\/em><\/span><\/p>\n
package org.jcg.zheng.demo.insert_blob;\n\nimport org.springframework.boot.SpringApplication;\nimport org.springframework.boot.autoconfigure.SpringBootApplication;\n\n@SpringBootApplication\npublic class InsertBlobApplication {\n\n\tpublic static void main(String[] args) {\n\t\tSpringApplication.run(InsertBlobApplication.class, args);\n\t}\n\n}\n<\/pre>\n
2.3 Application Properties<\/h3>\n
Here is the updated application.properties<\/code> file.<\/p>\n
application.properties<\/em><\/span><\/p>\n
spring.application.name=insert-blob\n\n# DataSource configuration\nspring.datasource.url=jdbc:postgresql:\/\/localhost:5432\/postgres?currentSchema=marydb\nspring.datasource.username=postgres\nspring.datasource.password=\nspring.datasource.driver-class-name=org.postgresql.Driver\n\nlogging.level.org.springframework.jdbc.core.JdbcTemplate=trace\nlogging.level.org.springframework.jdbc.core.StatementCreatorUtils=trace\n\n<\/pre>\n