Skip to content

JSqsh 2.2

Choose a tag to compare

@scgray scgray released this 29 Jan 19:49
· 129 commits to master since this release

You didn't ask for it, but you're getting it anyway. JSqsh 2.2 is here! Below are new and shiny features, however I'd also like to note that a lot of work went into updating the jsqsh wiki. There is now a full set of reference documentation available for all commands, variables, and additional help topics.

New Features

  • New platform support (Mac OS X X86_64, PowerPC 64bit (BE and LE) and s390x)
  • perfect display mode will try harder to avoid resizing numeric columns
  • \go options may now be provided after semicolon e.g. select * from foo; -m vert
  • The datetime_fmt now allows S to indicate fractions of a second,
    not just milliseconds, so you can now carry the precision out further.
  • Added new exit_on configuration variable. This variable indicates
    which commands, should they error, will cause the jsqsh session to
    exit.
  • Command infrastructure is no pluggable so you can provide jars that
    add additional commands into jsqsh.
  • Query time is now carried out to milliseconds precision
  • The visual query timer is now enabled by default ('cause I like it!).
    To turn off use \set timer=false
  • Upgraded jline to 2.13, and added proper handling of ^C while editing
  • Internal documentation has been refreshed, and now is nicely formatted
    to the current display width and using bold and underscore. The
    online wiki documentation is now auto-generated using the \wiki
    command. Check out the awesome new reference documentation at:
    https://github.com/scgray/jsqsh/wiki/Reference
  • The \help command now takes a --format argument to select how you want
    the help formatted
  • The new ${auto_pager} variable controls whether or not help is
    automatically send through a pager (e.g. "more")

Bug Fixes

  • Fixed NullPointerException when stored proc output parameters return a
    NULL value.
  • Fixed nested quotes in CALL statements like CALL MYPROC(?='Scott''s book')
  • Fixed bugs with word wrapping in perfect display mode
  • Handles failure of the driver to return the value for a column more
    gracefully (instead of stopping the whole result set, just prints
    *ERROR* in the column.
  • NullPointerException when calling a stored procedure in Sybase
  • Stop print DB2 warning about "statement succeeded". It is annoying.
  • Command line arguments with spaces in the value were not
    handled properly
  • Got rid of unecessary "*" when prompting for passwords
  • Fixed NPE if no password is provided at password prompt