JSqsh JSqsh software is a Java re-implementation of a tool that I originally authored called sqsh.
Download

JSqsh Ranking & Summary

JSqsh Tags

database database query query database frontend query piping piping

JSqsh Description

JSqsh software is a Java re-implementation of a tool that I originally authored called sqsh. JSqsh software is a Java re-implementation of a tool that I originally authored called sqsh. 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 != SqshIt 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 DocumentingJSqsh 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> helpWhat's New in This Release:· Added new mechanism to connect to allow a logical name to be assigned to a connection and persistently saved away so that the connection can be re-established in the future using only the name. This provides a cleaner mechanism for managing connections than the 'alias' command. Run "help connect" for more details.· Added session-to-session redirection, allowing the output of a command executed in one session to be executed by another session (or even re-executed by itself). See 'help redirection' for details.· The call command can now iterate through a CSV file and execute a prepared statement once for each line in the file, using the fields in the file as arguments to the procedure.· Fixed handling of "bit" datatypes.· Fixed ^C handling that I broke the last release.· Fixed the eval command aborting when it executes a command that causes a session switch, such as session or connect -n.· Fixed "connect -c" not finding classes that are specified in the ${classpath} jsqsh variable.· Fixed OutOfMemoryError when processing the results of a backtick expression (e.g. set x=`echo 1234`)

JSqsh Related Software