Oracle REST JDBC Driver and SQLcl

Oracle just released its first REST JDBC driver on OTN, in conjunction with the 17.3.0 Oracle REST Data Services Beta release.

Dermot posted this morning about how to setup ORDS and Enable REST SQL Statements. The JDBC driver connects to this service and allows you to connect your JDBC based program to a REST services.

As an example of this working with a standard application we can download the driver and drop it into Oracle SQLcl and connect to a service out of the box.

• Firstly download SQLcl from OTN 

• Unzip the sqlcl-17.2.0.184.1230-no-jre.zip

• Download the JDBC Beta Driver from OTN 

•  and drop it into the SQLcl lib directory

• Lastly start sqlcl with your appropriate URL, in my case is demo/demo@http:///ords//