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
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 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…
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…