Store File or byte[] as SQL Blob in Java (Store and Load)

In many applications, you might need to store files or binary data directly in a database. PostgreSQL offers a data…

Read More »

Resolving Spring Boot H2 JdbcSQLSyntaxErrorException: “Table not found”

Spring Boot makes it easy to develop Spring applications with its pre-configured components. However, we often encounter the JdbcSQLSyntaxErrorException: Table…

Read More »

Spring JPA LIKE Query Example With JdbcTemplate or JpaRepository

LIKE queries in SQL allow users to search for specified patterns in the database table columns, enabling flexible and dynamic…

Read More »

Best Practices for Using JDBC in Java Applications

Java Database Connectivity (JDBC) is a powerful API that bridges the gap between your Java applications and relational databases. By…

Read More »

10 JdbcTemplate Examples in Spring Framework

Hello guys, If you have been using the Spring framework then you may know that the JdbcTempalte is one of the most…

Read More »

Tomcat JDBC Pool – Connection Leak – Catch the Culprit

Database connection leaks are something that can stay hidden unless paid specific attention and would come to the surface at…

Read More »

Spring Boot and Micrometer with InlfuxDB Part 3: Servlets and JDBC

In the previous blog we setup a reactive application with micrometer backed with an InfluxDB. On this tutorial we shall…

Read More »

Read replicas and Spring Data Part 4: Configuring the read repository

Previously we set up two EntityManagers in the same application. One for the reads and one for the writes. Now…

Read More »

Read replicas and Spring Data Part 3: Configuring two entity managers

Our previous setup works as expected. What we shall do now is to get one step further and configure two…

Read More »