ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
by 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
Tag: Oracle
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 1.5.1.RELEASE, Oracle database 11g express, Oracle JDBC driver ojdbc7.jar, Commons DBCP2 2.1.1, Maven, Java 8
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.
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.
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 + 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 Boot 1.5.1.RELEASE, Spring Data 1.13.0.RELEASE, Hibernate 5, Oracle database 11g express, Oracle JDBC driver ojdbc7.jar, HikariCP 2.6, Maven, Java 8
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.
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 RDS from scratch and connect it your local MySQL shell.