August 14, 2022

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 Oracle license restrictions, the Oracle JDBC driver is not available in the public Maven repository. To use the Oracle JDBC driver with Maven, you have to download and install it into your Maven local repository manually.

How to add Oracle JDBC driver in your Maven local repository Read More

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 in findAll method will busy converting objects and put all objects into a List, if the object size is larger than the Java heap space. We can increase the heap size, but a better solution is to use RowCallbackHandler to process the large ResultSet on a per-row basis.

Spring JdbcTemplate Handle Large ResultSet 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