Softpedia >Windows >Internet >Servers >Database Utils >SQLRunner >  Changelog

SQLRunner Changelog

What's new in SQLRunner 20.20

Sep 25, 2019
  • Main window: Bug solved: At the end of the query: number records will not be displayed
  • Model: for queries with nmo schema, the key fields will noit be detected

New in SQLRunner 17.4 (Oct 25, 2017)

  • Export result table as xlsx now uses streaming function and can export huge amount of data
  • Import:
  • Messages contains the line number corresponding to the mapping dialog and the parser checks the max number of chars
  • Boolean parser now accepts a lot of different number and String content as boolean
  • Length of fields checked if length is given - before this value will be send to the database

New in SQLRunner 9.5 (Sep 5, 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 15, 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 15, 2014)

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

New in SQLRunner 8.8 (Mar 15, 2014)

  • Import flat files: Import configuration can be saved as Talend Schema.

New in SQLRunner 8.6 (Mar 15, 2014)

  • 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 (Mar 15, 2014)

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

New in SQLRunner 8.4 (Mar 15, 2014)

  • Bug fixed: Table cell editor does not use the given data format
  • DB2: more keywords added

New in SQLRunner 8.3 (Mar 15, 2014)

  • Editor: bug fixed: if a script runs from a selected text it fails in set caret for current statement position

New in SQLRunner 8.2 (Mar 15, 2014)

  • Editor: Paste smart: paste multiple line clipboard content into multiple line text You can pickup the line position by pattern (select text)
  • Editor: selected line count appears in status

New in SQLRunner 8.1 (Mar 15, 2014)

  • Importer differentiate between Double, Integer, Long
  • Data model view: filters only tables, views and procedures
  • Data model view: if catalog name is missing, a default catalog (database) node will be created
  • Talend Schema Export: Number and Decimal data types will be mapped to BigDecinal

New in SQLRunner 8.0 (Mar 15, 2014)

  • Data model view: Send To Editor function added in context menu
  • Data model view: Export table as Talend schema XML file.

New in SQLRunner 7.14 (Mar 15, 2014)

  • Boolean data type: bug solved: null values enabled
  • Database type Informix: URL part SCHEMA renamed to DATABASE

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.12 (Jan 7, 2013)

  • Preferences: Editor font chooser added
  • Bug fixed: comment font unchanged after change editor font

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 (Oct 4, 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.9a (Aug 6, 2012)

  • Bugfixes in Import Flatfile:
  • automatically created field import description starts not with the first field.
  • tables without schema in name fails in create import description

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.6 (Mar 14, 2012)

  • MySQL Extension added (supports explain)
  • avoid useless collecting metadata for references if query is based on views or explains
  • Comments will be added as SQL commands to update meta data
  • Data model view shows database nodes
  • Line comments will be replaced with space because of a lack of parsing feature in MySQL
  • Bug fixed: if statement ends with ; explain failed
  • Explain statements will not registered in history

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.4 (Feb 24, 2012)

  • Changes in data model API
  • Next SQLExceptions will be displayed in message dialogs and logs
  • Avoid (useless) exception after connect to database if no current selected schema is available
  • Integer column type added to GenericDatabaseExtension to avoid useless length term in code generator
  • Data model reflects new tables and views without the need of collapse and open tree nodes
  • Data model fixed comparison of views

New in SQLRunner 7.3 (Feb 24, 2012)

  • CTRL+Enter runs the current text block (limited by empty lines)
  • Key binding changed: SHIFT+CTRL+a for select current text block
  • Export to Excel fixed (avoid NullPointerException while exporting null values)
  • Abort connecting can be done with a new menu entry in menu Database
  • Fixed syntax highlighting for escaped string constants
  • Meta data view can handle broken network connections to database

New in SQLRunner 7.2 (Feb 24, 2012)

  • Create code can handle spaces within identifiers
  • Goto line dialog can jump to position (also relative to selected text)
  • Fixed wrong check if files in newer then loaded file
  • Fixed Excel date format in exports
  • Fixed highlighting current word under Windows
  • Model comparison includes procedures

New in SQLRunner 7.1 (Jan 16, 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)

New in SQLRunner 7.0 (Jan 16, 2012)

  • Syntax completion in editor implemented
  • Data model dialog now always on top

New in SQLRunner 6.2 (Jan 16, 2012)

  • Productive property added to connections (to change the background in editor)
  • Compatibility to previous versions in Import API restored
  • Import set commit size to batch size if set

New in SQLRunner 6.1a (Jan 16, 2012)

  • Use database specific modules to improve code creation and functionality
  • Provide an Explain button (if database provide this feature)
  • PostgreSQL and Oracle (partial) implemented
  • Can execute scripts with a large number of statements
  • logging extended
  • Data model shows new models from new opened connections
  • Added sum and max converting of selected text (e.g. "column" becomes "sum(column) as column")
  • Run time of current statement/script shown in the status bar
  • Code generation for procedure calls fixed
  • Status of commit and rollback button set to disabled if auto commit
  • Auto commit is now per default set on

New in SQLRunner 5.2a (Jan 16, 2012)

  • Increasing of session pool for meta data view avoided
  • Fix Windows problem with table context menu
  • Can set custom window title

New in SQLRunner 5.2 (Jan 16, 2012)

  • Create SQL for update schema now asynchronously
  • Added more look&feels: Tiny, Nimbus, new version of JGoodies
  • PostgreSQL driver changed to version for 9.1
  • Little changes because of Nimbus Look&Feel bugs
  • Shows in result table header the value class name

New in SQLRunner 5.1 (Jan 16, 2012)

  • Result table: can select all rows of an column (per mouse context menu)
  • Result table: can select a range with mouse+shift
  • Inline comments within statements will be send to the database because of getting the correct error position in case of syntax errors

New in SQLRunner 5.0 (Jan 16, 2012)

  • Data model comparison implemented
  • In datamodel view select two schemas and choose menu Schema Comparison

New in SQLRunner 4.60a (Jan 16, 2012)

  • Data model knows indexes and provide SQL statements for them
  • Bug fix for strange Oracle driver bug in meta data
  • Code generation fixed for drop tables for a schema

New in SQLRunner 4.54b (Jan 16, 2012)

  • Import recognize \N as null value
  • bug fixed: auto indention works also in next windows
  • bug fixed: opened window will be deiconified
  • bug fixed: new added row in table will rendered with an asterix at start
  • can delete or copy to clipboard more than one row
  • named prepared statements are working now for postgreSQL database

New in SQLRunner 4.52a (Jan 16, 2012)

  • Result table renders null values as grey cells
  • more tolerant against network problems