SQLcl Embedded JREs

When you are restrained in the JRE that you can use with SQLcl, you can embed your own in the sqlcl directory tree.  We currently support 1.8 meaning that if you run with 1.7, you're going to have problems.

When you look inside a sqlcl distribution, you will see the bin and lib directory. 

Go grab a jre from somewhere, In my case, I'm getting it from my installed jdk

Zip up the JRE and unzip it in the top level sqlcl directory.  You should have a structure like this now.

Test what you have now by running SQLcl.  I'm doing a silent run to test it works for a start and also to check where the java is coming from. If you type 'show java' you'll get a lot of information about what is running and where it is.

You can see here that the JRE from the installtion is being used so you can now drop this in another environment and run normally.