This example shows how to connect to the Oracle database and use Oracle specific features in Spring JDBC application. We are going to use Oracle Database Express Edition. If you do not have the Oracle database server installed, follow this guide for downloading/installing Oracle Express Edition and getting started with Oracle SQL Developer.

Installing JDBC driver to local Maven repository

JSON data in SQL Server.; 13 minutes to read +25; In this article. APPLIES TO: SQL Server 2016 and later Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse JSON is a popular textual data format that's used for exchanging data in modern web and mobile applications. Apr 27, 2016  SQL Server functions. SQL Server also supports database functions, which, unlike stored procedures, don’t use input and output parameters, but one or more function arguments and a single return value. SQL Server function returning a simple value. The first stored procedure can be turned into a function which looks like this.

Follow this guide to install Oracle JDBC driver.

Inserting example data in the database

We are going to create following table and its corresponding sequence (Oracle does not provide feature like AUTO_INCREMENT embedded in the create table statement, we have to create a Sequence object separately and then use its reference in the insert statement):

src/main/resources/createPersonTable.sql

To execute above database statements, we need to use Oracle SQL developer as shown:

Don't forget to commit by clicking the green check icon (where our red arrow is pointing to)

Creating Spring JDBC application

Additional Maven dependency

Following dependency is the one which we installed ourselves above.

pom.xml

Creating the DAO

Note that we used 'sq_person.nextval' in above insert statement which is an Oracle specific way to generate Primary ids.

A Test Client

Java Config and main class

Output

Example Project

Dependencies and Technologies Used:

• spring-context 4.2.3.RELEASE: Spring Context.
• spring-jdbc 4.2.3.RELEASE: Spring JDBC.
• ora-jdbc 7: POM was created from install:install-file.
• JDK 1.8
• Maven 3.3.9