Maven – How to create a multi module project
In this tutorial, we will show you how to use Maven to manage a Multi-module project containing four modules. Password module – Interface only. Password md5 module – Password module…
Connect to Oracle DB via JDBC driver
A JDBC example to show you how to connect to a Oracle database with a JDBC driver. Tested with:Java 8, Oracle database 19c, Oracle JDBC driver for Java 8, ojdbc8.jar
Spring Boot JDBC + MySQL + HikariCP example
In this article, we will show you how to create a Spring Boot JDBC application + MySQL and HikariCP. Tools used in this article :Spring Boot 1.5.1.RELEASE, MySQL 5.7.x, HikariCP…
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…