Barry McGillin

Director of Development at Oracle. Building SQLcl, SQL Developer, ORDS & SQL Developer for VS Code. Based in Omagh, Northern Ireland.

less than 1 minute read

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.

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

  • and drop it into the SQLcl lib directory

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

You May Also Enjoy

Long Running Tasks in SQLcl

1 minute read

SQLcl 24.1 introduced background task execution — run any command in parallel, name it, track it, and wait for it to finish.

git bash completion

less than 1 minute read

Try this in bash git p You get a file names p or a list of them.  Thats not much good, but there is a great bash completion library which you can source in...

Migrating Subversion to Git with LFS

4 minute read

When a project has been on the go for a while theres going to be all sorts of stuff in there from jars to zips and everything in between.  We went though thi...