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

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 to procedures. The only difference is that function always returns a value. 2 – User defined functions can be used as a part of an SQL expression. Note: Oracle SQL does not support calling of functions with Boolean parameters or returns.

Oracle PL/SQL – CREATE function example 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

Amazon RDS: Introduction and Tutorial

Amazon RDS is a Relational Database Service by Amazon Web Services. A relational database is a type of database that stores data in tables with rows and columns. Amazon RDS provides an industry-standard relational database that is cost-efficient with resizable capacity. It gives users solutions for easier setup, operation, and scale of a relational database in the cloud. In this blog, we will cover everything you need to know about Amazon RDS, Amazon RDS Pricing, and a step-by-step tutorial to create a Relational Database on AWS.

Amazon RDS: Introduction and Tutorial Read More