Connect to MySQL with JDBC driver
A JDBC example to show you how to connect to a MySQL database with a JDBC driver. Tested with:Java 8, MySQL 5.7, MySQL JDBC driver mysql-connector-java:8.0.16
Connect to PostgreSQL with JDBC driver
A JDBC example to show you how to connect to a PostgreSQL database with a JDBC driver. Tested with:Java 8, PostgreSQL 11, PostgreSQL JDBC driver 42.2.5
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
This is caused by the requested SID doesn’t exist in {ORACLE_HOME}/network/admin/tnsnames.ora . Tested with Oracle database 19c with ojdbc8.jar
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…