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 + 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…
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…
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…
Spring Boot + Spring Data JPA + Oracle example
In this article, we will show you how to create a Spring Boot + Spring Data JPA + Oracle + HikariCP connection pool example. Tools used in this article :Spring…
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…
What is Amazon RDS in AWS? – Creating Amazon AWS RDS MySQL Instance
Here, in this blog on AWS Relational Database Service, we will be discussing the all the basic concepts of Amazon Relational Database Service and also learn how to create an…