SQLRunner Changelog

What's new in SQLRunner 10.0

Feb 23, 2015
  • Compatible to Java 7+ and to OSX Yosemite

New in SQLRunner 9.5 (Aug 27, 2014)

  • Can handle binary data (update in value editor and using them as primary key).

New in SQLRunner 9.4 (Jul 25, 2014)

  • SQL code generator: Table order follows now foreign key constraints
  • SQL code generator: identifier equals to keywords will be enclosed (char depends on database type)
  • Editor: Highlighting take care of enclosing char
  • Talend Schema Export from Query Function added
  • Value editor: date format now always in synch with the date format from the result table renderer

New in SQLRunner 9.3 (Jul 25, 2014)

  • Regex tester: Checkbox Case sensitive added

New in SQLRunner 9.2 (Mar 25, 2014)

  • Fixed Bug: latest table used for updates was always lower case. In some case in MySQL this is a problem if the table is case sensitive created.

New in SQLRunner 9.1 (Mar 25, 2014)

  • After load of SQL scripts all comments are correct colored.

New in SQLRunner 8.8 (Mar 25, 2014)

  • Import flat files: Import configuration can be saved as Talend Schema.
  • OSX: A click on the application in the dock restores the current window and does not open a new window.

New in SQLRunner 8.6 (Nov 16, 2013)

  • Regex tester fixed: Test text field does not scroll
  • Talend Schema Export: For number types, the length and precision is taken into account for choosing Java class

New in SQLRunner 8.5 (Oct 10, 2013)

  • Talend Schema Export sets the pattern attribute in case of Date columns

New in SQLRunner 7.13 (Jan 7, 2013)

  • Data model view: filter for object names added
  • Data model view: Bug in refreshing table view solved

New in SQLRunner 7.11 (Oct 4, 2012)

  • Bug fixed:
  • Loading schemas stops if security exceptions raise
  • Meta model some times does not disappears correctly after close connection
  • MS SQL Server 2008r2 supported with JTDS driver from sourceforge.org
  • Encapsulating $ in identifier inn generated SQL code

New in SQLRunner 7.10 (Aug 14, 2012)

  • Bug fixes:
  • current schemas is selected correctly (using for code completion feature)
  • data model expands the tree for current selected schema
  • Select and run a statement with CTRL+Enter works also if code is already selected

New in SQLRunner 7.8 (Apr 5, 2012)

  • SQLDataModel API changes
  • Reconnect action added to Database menu
  • Datamodel view: double clicks on databases or schemas puts there names into the editor
  • Datamodel view: sends element name to editor by hit Enter key
  • Datamodel view: added an info panel with count and comment panel
  • History detail view shows URL and user of statements

New in SQLRunner 7.7 (Mar 24, 2012)

  • avoid pasting \00
  • Help menu contains links to help pages and the homepage

New in SQLRunner 7.5 (Feb 24, 2012)

  • Explain feature for Derby database implemented
  • Column width of result table will fit to the available width

New in SQLRunner 7.1 (Jan 19, 2012)

  • Keybinging CTRL+7 added for toggling line comment
  • Keybinding SHIFT+CTRL+A for select current line
  • Keybinding in data model changed for ENTER: sends selected element name to editor
  • Regex-Tester: added a text field for escaping java strings
  • Code creation for schema includes now all views
  • History view can take over multiple statements (only copy sql in editor)