How to Install SQLLine on Ubuntu (For Big Data Tools)

SQLLine is a Java console based for connecting to databases to execute SQL commands. This is a helper tutorial for other guides. Here is How to Install SQLLine on Ubuntu For Using With Big Data Tools. SQLLine depends on Java Virtual Machine, JLine console reader, JDBC driver (any JDBC compliant driver can be used). Of course we can use the same way of installation on Windows 10 Bash and Android bah with Termux.

 

Steps on How to Install SQLLine on Ubuntu

 

There is probably an apt version of sqlline, probably that is backdated. You should check what your application wants. There is a Python SQLLine :

We are showing Java SQLLine.

Install Java virtual machine :

java7 or java9 are releases are not recommended for development. Verify that Java and the Java compiler have been properly installed:

To set the variable for your system:

Reload your system’s environment variables:

Verify the variable was set correctly:

Install Apache Maven following our previous guide.

Create a directory named sqllinedir and work with Jline, sqlline from that directory. Install Jline from :

These are the needed commands :

Download your database specific JDBC driver files into that sqllinedir directory. For example, MySQL JDBC driver can found on MySQL’s site :

Te above step will change according to your need to use SQLLine. Final step is installing SQLLine itself. The SQLLine we are showing is fork of Marc Prud’hommeaux’s original SQLLine project on SourceForge. It is somewhat modernized :

Other matters related to SQLLine remains same. The old SourcForge reference of all commands of SQLLine is still a good place to start with :

Probably we could omit some steps with the new forked version. However, some of the tools assumes they are installed.

This Article Has Been Shared 2651 Times!

Facebook Twitter Google+ Pinterest