Spring Boot JDBC + Oracle database + Commons DBCP2 example
In this article, we will show you how to create a Spring Boot JDBC application + Oracle database + Commons DBCP2 connection pool. Tools used in this article :Spring Boot…
How to add Oracle JDBC driver in your Maven local repository
Here’s a simple guide to show you how to add an Oracle JDBC driver into your Maven local repository, and also how to reference it in pom.xml. Note: Due to…
Spring Boot + Spring data JPA + PostgreSQL
The previous Spring Boot + Spring data JPA will be reused, modify to support PostgreSQL database. Technologies used :Spring Boot 2.1.2.RELEASE, Spring 5.1.4.RELEASE, Hibernate 5.3.7, HikariCP 3.2.0, PostgreSQL driver 42.2.5,…
Spring Boot + Spring data JPA + MySQL
The previous Spring Boot + Spring data JPA will be reused, modify to support MySQL database. Technologies used :Spring Boot 2.1.2.RELEASE, Spring 5.1.4.RELEASE, Hibernate 5.3.7, HikariCP 3.2.0, mysql-connector-java:jar 8.0.13, Maven…
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…
Spring JdbcTemplate batchUpdate() Example
Spring JdbcTemplate batch insert, batch update and also @Transactional examples. Technologies used :Spring Boot 2.1.2.RELEASE, Spring JDBC 5.1.4.RELEASE, Maven 3, Java 8.
Spring JdbcTemplate Handle Large ResultSet
Spring JdbcTemplate example to get a large ResultSet and process it. P.S Tested with Java 8 and Spring JDBC 5.1.4.RELEASE. If the table contains over millions of data, the RowMapper…
Oracle PL/SQL – CREATE function example
This article will help you to understand how to create a user defined function. It’s also known as stored function or user function. 1 - User defined functions are similar…
Spring Boot Log4j 2 example
In this tutorial, we will show you how to use Apache Log4j 2 in Spring Boot framework. Technologies used :Spring Boot 2.1.2.RELEASE, Spring 5.1.4.RELEASE, Log4j 2.11.1, Maven 3, Java 8