From jsqsh

Welcome to JSqsh!

JSqsh (pronounced jay-skwish) is a Java re-implementation of a tool that I originally authored called sqsh (also hosted on SourceForge). The original sqsh was a Sybase-specific console based tool (i.e. non-graphical) that combined the ability to query the database with much of the functionality of a shell, such as piping the results of queries out to external programs (grep, more, etc.), expanding variables, redirecting output to files, command line editing, etc.

Jsqsh attempts to re-create the most frequently used features found in sqsh but, with the use of JDBC (Java's database driver architecture), allow it to be used against any database that provides a good JDBC driver. JSqsh attempts to shield the user from much knowledge of Java and JDBC as much as possible, so it should be suitable for the average user to use, but there are a couple of places in which some knowledge of the basics of JDBC are useful.

JSqsh 1.2 Now Available

Jsqsh version 1.2 is now available. It has a couple of new useful features, including:

• Connection management
• Session redirection
• Batch SQL

As well as some critical bug fixes over 1.1. For a complete list of changes to the release, check out the Whats New? page.

JSqsh != Sqsh

It is important to note that jsqsh is not a perfect recreation of sqsh, so please do not blindly run scripts explicitly build for sqsh against jsqsh without some thorough testing!

Self Documenting

JSqsh attempts to be as self documenting as possible, so if at any time you have any questions about how to use it you can execute the \help command at the prompt and get a list of help topics:

1> \help

In addition you can visit the Getting started page for a quick tour of getting started with jsqsh.