August 14, 2022

Spring Boot + Spring data JPA

In this tutorial, we will show you how to use Spring Boot + Spring data JPA to save data into an H2 in-memory database and how to also query the data. Technologies used :Spring Boot 2.1.2.RELEASE, Spring 5.1.4.RELEASE, Hibernate 5.3.7, HikariCP 3.2.0, H2 in-memory database 1.4.197, Maven 3, Java 8. Note: By default, Spring Boot 2 uses HikariCP as the database connection pool.

Spring Boot + Spring data JPA Read More

Spring Boot JDBC Stored Procedure Examples

In this tutorial, we will show you how to use Spring Boot JDBC SimpleJdbcCall to call a stored procedure and stored function from a Oracle database. Technologies used :Spring Boot 2.1.2.RELEASE, Spring JDBC 5.1.4.RELEASE, Oracle database 19c, HikariCP 3.2.0, Maven 3, Java 8. Unlike JdbcTemplate, Spring Boot didn’t create any SimpleJdbcCall automatically, we have to create it manually. In summary: For Stored Procedure – SimpleJdbcCall.execute, For Stored Function – SimpleJdbcCall.executeFunction

Spring Boot JDBC Stored Procedure Examples Read More