Installation

This page will attempt to walk you through the process of installing the pre-compiled releases of jsqsh to get you up and running as quickly as possible on your platform.

Java Version

Regardless of platform, jsqsh requires a JVM compatible with Java 5 or later. While jsqsh will work on most JVM's, support for cancelling queries (by hitting CTRL-C while the query is running) is only supported by JVM's that provide Sun's signal handling API's. The following JVM are known to provide this support:

• Sun/Oracle JRE
• OpenJDK JRE
• IBM JRE

You can download Sun's JVM from http://java.sun.com or OpenJDK from http://openjdk.java.net. Most Linux distributions have mechanisms available to automatically download and install Java and I will try to cover those specifically in the following sections.

Linux installation

The following detail binary installation instruction for major Linux platforms that I've tested. It is important to note that many of these Linux platforms have other distributions that are derived from them and should work just fine. For example, Ubuntu has related distributions Kubuntu, Edubuntu, xubuntu, Mint, etc. Again, please let me (scottgray1@gmail.com) know if you have instructions for a platform not listed here and I'll add them.

Debian (.deb)

I do most of my development on Mint Linux (an Ubuntu variant). Installation should be as simple as downloading the latest release from:

• Grab the appropriate .deb file from the latest version here. NOTE The giant green Sourceforge download button isn't aware of if you are 32bit or 64bit so will present the 32bit version by default. If you are 64bit, don't use that button and use the link.
• Download the .deb file and open it from the download window/bar in your browser, you should be asked if you want to install it

Alternatively, you can manually install it with:

 dpkg --install jsqsh-*.deb

RedHat (.rpm)

I build the RPM build on Centos 5.8 (32 and 64 bit - thank you Virtual Box! Since jsqsh has few dependencies other than the JVM it should install on most any RPM distribution.

• Grab the appropriate .rpm file from the latest version here. NOTE The giant green Sourceforge download button isn't aware of if you are 32bit or 64bit so will present the 32bit version by default. If you are 64bit, don't use that button and use the link.
• Download the .rpm file and open it from the download window/bar in your browser, you should be asked if you want to install it

Alternatively, you can manually install it with:

 rpm --install jsqsh-*.rpm

Windows

The windows build has no installer because I am lazy and learning two build systems (.deb and .rpm) was two too many for me. I welcome anyone that wants to build an installer for it for me!

However, the installation is easy:

• Download the appropriate jsqsh-win*.zip file from here
• Unpack it where ever you want
• Run the bin/jsqsh.exe binary to launch jsqsh

HELP The 2.0 release only has a Windows 32 bit build. This is because I only own an ancient Windows XP 32bit version running in Virtual Box. I don't plan on buying a new version of Windows just for this, so if anyone would like to donate a Windows 7 or 8 64bit build or license (Microsoft you out there?) I'd be happy to start providing builds.

Other Platforms

If you run on a platform other than the above and you want a pre-built version, then download the jsqsh-*-noarch.zip version from here.

This build should run on any platform with a JVM, but it doesn't include jsqsh's JNI (Java Native Interface) layer that provides certain functionality, such as command piping. Command line editing should continue to work on any platform supported by the JLine library.

Building

For any platform not listed above, you can build jsqsh from source pretty easily (especially for UNIX variants). For this you will need:

• Java JDK 5 or later
• Apache Ant 1.7 or later
• A C compiler that is recognized by GNU autoconf
• The $JAVA_HOME environment variable pointing to your Java JDK
• The jsqsh source downloaded from the jsqsh-*-src.tar.gz file from here

Provided these criteria are met, you can do one of the following

ant dist-bin

This will produce a .zip file in the build/ directory. When unpacked, it will contain a directory structure containing a bin/jsqsh script that should be capable of launching jsqsh with all of its functionality and glory.

ant dist-deb

This will produce a build/*.deb installation package for Debian distributions. By default the .deb file produced will be tagged as being for x86 architecture, but you may override this with:

ant -Darch=amd64 dist-deb

where arch can be whatever architecture you are building on.

ant dist-rpm

This will produce a build/*.rpm installation package.