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

ORBADA Changelog

What's new in ORBADA 1.2.5.395

Mar 23, 2017
  • Added:
  • # 349 (fr) - New views for PostgreSQL
  • # 352 (fr) - Domains in postgresql
  • # 351 (fr) - Editing table column and pg view comments
  • # 349 (fr) - New views for PostgreSQL
  • Fixed:
  • # 365 (bug) - Session list on pg 9.6
  • # 161 (bug) - Ordering of type attributes
  • # 159 (bug) - White characters
  • # 157 (bug) - Problem with column reltoastidxid on Detail tab
  • # 155 (bug) - No comments in the view source
  • # 151, # 154 (bug) - Problem with users combo on schema list box

New in ORBADA 1.2.4.369 (Apr 3, 2015)

  • Added:
  • Shortcut key for next/prev editor on sql tab #17
  • Tab in sql editor chage focus instead of write a tab. #343
  • PostgreSQL, storage type on table column list
  • Fixed:
  • Kopiowanie do schowka
  • Modified:
  • A way to set a name for specified tab

New in ORBADA 1.2.3.346 (Oct 31, 2014)

  • Added:
  • store size of param window
  • save query result as file and open on another machine
  • Now you can use beanshell script at sql query tab for save and open result from a file
  • Just execute any sql command and next, write and execute below scripts (Ctrl+Enter) beanshell {saveQueryFile("file_name");} beanshell {openQueryFile("file_name");}
  • Fixed :
  • java.lang.NullPointerException when change look and feel
  • layout problem with param window on java 8
  • IDE: replace selection by snippet Modified
  • Oracle, recyclebin ordere by drop date
  • Klepsydra : octopus
  • List of sessions with sql commands like DBA
  • WARNING: global tablespace never has databases
  • Inherited tables total size on table size list view
  • Modified:
  • Oracle, recyclebin ordere by drop date
  • Klepsydra : octopus
  • List of sessions with sql commands like DBA
  • WARNING: global tablespace never has databases
  • Inherited tables total size on table size list view

New in ORBADA 1.2.2.335 (Aug 14, 2014)

  • Added:
  • PostgreSQL: some words for the highlight editor
  • PostgreSQL: Role / user list
  • Import bookmarks set and layout of another connection
  • CSV: Plugin for importing data from csv files
  • SQL Table: auto cloning connecion
  • PostgreSQL: plan of sql
  • Fixed:
  • Some hangs after the show message box
  • modified:
  • new splashscreen series with the theme of cities
  • performances as a script
  • Preview values ​​(Alt + F3)

New in ORBADA 1.2.0.303 (May 31, 2014)

  • Added:
  • Zamkanie programu
  • PostgreSQL: highlight complex operators in sql editor
  • PostgreSQL: edit comment
  • PostgreSQL: record length on view table size
  • PostgreSQL: aggregate function list
  • Query timing if exception is raised
  • json data view
  • PostgreSQL, expand highlights for non public, system or main tables, views and functions
  • sky library, syntax editor, expand highlight to delimited objects
  • PostgreSQL, serial and bigserial in editor highlight
  • PostgreSQL 9.2+, range types in highlight
  • Rozszerzenie wyszukiwania w źródłach dla Oracle
  • Oracle, search object in all schemas
  • PostgreSQL, type list
  • PostgreSQL, session list
  • PostgreSQL, on table size list add schema name
  • PostgreSQL shown raise messages
  • Fixed:
  • java.lang.NullPointerException
  • PostgreSQL: not warns change the source of the function
  • Zarządzanie zadaniami dbms_job
  • Problem with save width of the column after move
  • IDE: problem with shortcut key on data view (alt+f3)
  • [Assertion failed] - this argument is required; it cannot be null
  • Znak mniejszości w oknie historii poleceń SQL
  • NullPointerException on PostgreSQL and array with null element
  • Problem with date on query parameters
  • Modified:
  • PostgreSQL: Search object and source on schema getted from search_path
  • PostgreSQL - on table size tab show current_schemas table size
  • sql queries, command result, auto show
  • usedb, close statement in command after fire execute event
  • Copy grid to clipboard and number format

New in ORBADA 1.1.1.281 (Apr 17, 2014)

  • Added:
  • PostgreSQL, alter view/function owner to
  • PostgreSQL, commented DROP VIEW and FUNCTION
  • Fixed:
  • Problem z listą wyzwalaczy w widoku tabeli
  • Podgląd zawartości pola w gridzie jako HEX
  • PostgreSQL - index columns and condition
  • Editor highlight - documenting keyword problem
  • Klucz do bazy HSQLDB pojawia się w logach!
  • Modified:
  • Wybór pliku jako wartość parametru
  • Zapamiętywanie rozszerzenia ostatnio wybranego pliku na ekranie edycji wartości parametru
  • PostgreSQL, on table, view, sequence tab show all objects visible in search_path

New in ORBADA 1.1.0.273 (Oct 11, 2013)

  • Added:
  • Plug-in for PostgreSQL database
  • bit type as boolean
  • refresh 2 sec
  • Oracle, materalized view index source problem
  • B³êdy w wyniku polecenia (Errors as a result of the command)
  • Eksport do Excel - format 2007
  • adapting to run orbada using postgresql as the internal database
  • Oracle, session list, blocking_session and event
  • Fixed:
  • change refresh interval
  • java.lang.OutOfMemoryError: Java heap space in export dbf/datatext for PostgreSQL
  • W³asne ikonki i ucinanie tekstu
  • Modified:
  • Szyfrowanie bazy HSQL
  • numeric values in data lists
  • reduce oracle-dba plug-in size and speed up connection
  • reduce mysql plug-in size and speed up connection
  • reduce sqlite plug-in size and speed up connection
  • Zabijanie sesji (KILL SESSION)
  • speed up of data mover plug-in
  • log4j configuration with rolling

New in ORBADA 1.0.9.233 (Jun 12, 2013)

  • Added:
  • start transaction
  • The window is an instruction in the performance of scripts
  • The titles of pages editor (SQL tab, comment -- at first line in tooltip and search [Alt+-])
  • Does not store the last window size
  • PostgreSQL EXECUTE like SELECT
  • DATABASE TRIGGERS PROBLEM
  • Left/Right diff with shift key - copy selected text
  • CPU time and Elapsed time
  • Fixed:
  • Not correctly lined up with bright updated program
  • Error when creating the function parameters
  • Problem with pdczycie large scripts
  • Problem with database driver specyfic types like Postgres::hstore, json
  • MULTI-ACTION TRIGGERS PROBLEM
  • VARCHAR UTF8 DDL problem
  • Problem with FORCE attribute in VIEW creator
  • Problem with columns in sys view V$SQL on SQL plan window
  • Modified:
  • The list of processes in MySQL < 5.1.7
  • Editor SQL - free work over RDP
  • Scripting
  • Switched part of the release (enable/disable triggers)
  • A preview of the SQLite plan

New in ORBADA 1.0.9.217 (Feb 18, 2013)

  • Fixed:
  • on Oracle, for RAC detection I use v$instance instead of gv$instance BUG#90 [ORACLE] sys_guid() returns bad data
  • FB rdb$db_key value
  • Dancer java.lang.NullPointerException
  • ORA-00942: table or view does not exist after connect to oracle xe
  • (Ctrl+Shift+C) (It does not work "Copy as program code")
  • IDE: closure of broken connections
  • IDE: ast location on save content
  • Modified:
  • filters LIKE not working in tables tab
  • Create View FORCE attribute
  • SQL Macro: SQL and beanshell
  • Oracle: no table comment problem

New in ORBADA 1.0.9.205 (May 25, 2012)

  • Added:
  • Oracle: Complement the function names
  • Oracle: Explain Plan - FULL SCAN - color
  • IDE: Ctrl+F8 (re/store window size) •
  • Fixed:
  • IDE: B³¹d parsowania sql'a (sql parsing error)
  • IDE: Usuwanie szablonów (delete templates)
  • Oracle: Structure parser bad show labels
  • Oracle: Pozycjonowanie po b³êdzie SQL (Positioning the SQL error)
  • IDE: Eksport konfiguracji po³¹czeñ - problem (problem with schema configuration export) ± Modified Structure Parser: some optimizations
  • Oracle: Empty message box on store object

New in ORBADA 1.0.9.197 (Oct 21, 2011)

  • Added:
  • #3375048 - IDE: Plug-in for JTatoo LAF
  • Fixed:
  • #3417723 - IDE: Problem with sort after click column, 'O' char at end
  • #3412929 - CSV - Missing Translation
  • #3411937 - SQLite: NULL type of column
  • #3389913 - UseDB: usedb.escape-processing parameter don't work
  • #3388854 - Oracle: Jobs tab, filter problem
  • #3367514 - MySQL: problem on ver 5.5.14 and show db version
  • #3360394 - IDE: problem with font settings on data table, windows 7
  • Modified:
  • #3385281 - IDE: Initial window size to 800x600
  • #3368800 - MySQL: View on object search are shown as table
  • #3360603 - IDE: new swing-layout library

New in ORBADA 1.0.8.187 (Jun 15, 2011)

  • Added:
  • CSV: more separators in csv export
  • IDE: schema disable the collection info about objects
  • IDE: settings provider for schema
  • IDE: on welcome page, info about support request
  • IDE: option that on close question means NO rollback
  • DOC: BeanShell action example copy ddl to clipboard #
  • Oracle: quick stop button on session list
  • IDE: full screen mode (F11 or menu file)
  • MySQL: CAST, EXTRACTVALUE and other functions highlight
  • SQLite: vacuum, rollback, transaction keyword highlights
  • SQLite: boolean, varchar types highlight
  • DOC: Tips & tricks - colorizing the name of the schema
  • SQLTab: many sql query tab with save content
  • SQLite: wizard (on database list) for PRAGMA integrity_check
  • IDE: Check updates every 24 h
  • Oracle: WAIT, FORALL keyword highlight
  • Oracle: VARRAY type highlighting
  • Firebird: CHARACTER keyword highlights
  • FB page containing DDL on TABLE tab
  • Firebird: computed info on index list
  • IDE: universal changing ORDER BY by column click (with holded Ctrl key) DOC: posibilyty to transfer orbada local hsql database to remote
  • Oracle: column position after refresh
  • Fixed:
  • IDE: problem with jdbc parameters on edit schema
  • Problem with BLOB's in SQLite
  • IDE: AND in filters
  • Component state change must be done on Event Dispatch Thread
  • IDE: Time format is limited to a maximum of 99 hours Modified
  • Oracle: in session list, analyze index shown as IX
  • IDE: in editor after Ctrl+G search, current line selection
  • IDE: Buttons with x or + in tab should have bkg color
  • IDE: Sorting the table should be initiated as DESC
  • Losing order by in session tab on refresh
  • Oracle: remove upper in filters

New in ORBADA 1.0.7.165 (May 19, 2011)

  • Added:
  • DOC: How to Report Bugs Effectively
  • SQLite: database file size in database list view
  • DOC: Tips & tricks - SELECT from table
  • IDE: proxy settings on welcome page
  • SQLite: extended info about databases
  • SQLite: wizard for PRAGMA locking_mode
  • DOC: Tips & tricks, opening multiple connections
  • BeanShell: openQueryFile from SQL Query tab
  • UseDB: open query file
  • UseDB: write query structure in temp file
  • IDE: SQL macro for driver
  • IDE: JDBC driver reseting after edit driver spec
  • SQLite: vacuum
  • SQLite: wizard for PRAGMA auto_vacuum
  • SQLite: wizard for PRAGMA max_page_count
  • SQLite: wizard for PRAGMA case_sensitive_like
  • SQLite: wizard for pragma cache_size
  • Oracle: SQL Query tab, after error set cursor position
  • UseDB: property usedb.escape-processing
  • IDE: please wait process test button
  • IDE: info that the command can be added to the startup
  • IDE: editor find/replace, new line
  • IDE: information about where orbada connects through a proxy
  • Deleted:
  • DOC: remove FAQ
  • Orbada: remove xdb.jar and xmlparserv2.jar from distribution
  • Fixed:
  • Oracle: problem with structure parser and default params
  • BeanShell: String index out of range: -1 when {} is empty
  • Could not display content in unicode
  • IDE: problem find/replace with regexp in procedure body
  • Oracle: problem with explain plan when ? uccurs
  • Oracle: java.lang.NoClassDefFoundError: oracle/xdb/XMLType
  • Modified:
  • Oracle: problem with change schema on SQL Plan view
  • IDE: editor parentheses finder
  • IDE: optymize editor cursor move
  • UseDB: SQL script commands end by semicolon

New in ORBADA 1.0.6.148 (Apr 20, 2011)

  • Added:
  • Firebird: Test for Firebird JDBC/ODBC Driver 2.0
  • Enable HSQLDB 2.0 (2.1 recommended)
  • IDE: block lighting for editor structure parser
  • DerbyDB: adapt to newer versions
  • HSQLDB: 2.0 extended information about sessions
  • Firebird: structure parser
  • IDE: time of open and execution query in UseDB status window
  • Firebird: Firebird JDBC/ODBC driver specyfication
  • Oracle: Oracle JDBC/ODBC driver specyfication
  • IDE: sql param window and clob/blob
  • IDE: additional libraries to loading with the jdbc driver
  • IDE: CSV driver type for stels and sf.net jdbc driver
  • IDE: support jdbc connection without transactions
  • IDE: shared jdbc drivers
  • Fixed:
  • Oracle: problem on structure parser on some "if"
  • Oracle: problem with "

New in ORBADA 1.0.5.132 (Mar 22, 2011)

  • Added:
  • Oracle: extended info (synonyms) for editor highlight
  • MySQL: autocomplete
  • MySQL: comments on search object view
  • IDE: menu, open page with reviews, donations, etc
  • MySQL: Open/freeze object selected in editor (Ctrl+Shift+F7)
  • Oracle: DBMS Output settings for connection
  • IDE: proxy settings
  • Fixed:
  • Oracle: Transaction isolation level problem
  • SqlTab: Rectangle width and height must be > 0 Modified
  • IDE: some changes in the icons of the buttons
  • MySQL: waiting too long to open the search objects view

New in ORBADA 1.0.5.125 (Mar 7, 2011)

  • Added:
  • From now on, you can support (by donations) my dream - Ford Mustang
  • DOC: Tips&Tricks, Oracle database sessions view
  • SQLTab: cancel execute sql block like query
  • SQLTab: sql command execution time info
  • HSQLDB: primary and foreign key wizard add to column list
  • Firebird: primary and foreign key wizard add to column list
  • MySQL: primary and foreign key wizard add to column list
  • Oracle: primary and foreign key wizard add to column list
  • Oracle: Freeze view trigger
  • IDE: rename button icon
  • MySQL: search database object view
  • Oracle: collecting types for editor highlights
  • MySQL: kill queries on process list
  • MySQL: kill connection on process list
  • MySQL: Process list
  • MySQL: statistics on sql queries tab (Ctrl+T)
  • Oracle: create indexes for table foreign keys wizard
  • Html: Export to html values with spaces begin or end
  • Fixed:
  • Oracle: collecting tables for editor, current_schema
  • Firebird: BIGINT to INT64 procedure
  • IDE: problem with comma in procedure param on autocomplete
  • Oracle: Boolean params on 11g, create view, table, etc source
  • Oracle: message kill session on session list display %s
  • IDE: Problem with open documentation on windows 7
  • Modified:
  • Oracle: -67 on session list at command column
  • Oracle: show views actions showing them on the toolbar
  • IDE: version on splashscreen
  • IDE: update info dialog, hiperlink open browser
  • IDE: Last changes, grouping by modifications

New in ORBADA 1.0.4.109 (Feb 7, 2011)

  • Added:
  • 3169019 - IDE: window with orbada changes after press update button
  • 3169712 - Dev: Copy as Java code, SQL parameters
  • 3167812 - HSQLDB: Rename column wizard
  • 3167795 - Firebird: Rename column wizard
  • 3167790 - MySQL: Rename column wizard
  • 3165485 - Oracle: Rename column name wizard
  • 3165486 - storing/restoring sql queries tab editor position
  • 3164432 - DOC: New tip - sql statement queue
  • 3164431 - DOC: New tip - cloning connection
  • 3156517 - IDE: Adder available by Ctrl+Alt+A shortcut on data grid or popup menu
  • 3163536 - Plugin for export to DataText files
  • 3161928 - CSV: export params escape, endl, force qualifier
  • Fixed:
  • 3167996 - UseDB: problem with binary data stored in xml record
  • 3167775 - Oracle: no resource (en) text in settings
  • 3163960 - IDE: NullPointerException when no internal db connection
  • Modified:
  • 3169931 - Dev: New definition created clear all params
  • 3167011 - UseDB: change dtd for saved records in xml files
  • 3165531 - Oracle: no create thread if no oracle connection
  • 3165487 - Oracle: focus on comment edit box for all comment wizards
  • 3163955 - Oracle: sql quary for plan list works too long
  • 3163529 - CSV: optimize export by removing variant creation
  • 3161462 - IDE: window for usedb status opening query more redable

New in ORBADA 1.0.4.94 (Jan 19, 2011)

  • Added:
  • Oracle: highlight all named exceptions
  • DOC: tips and tricks section
  • Oracle: highlight exception declaration in sql editor
  • Oracle: highlight integer type in sql editor
  • MySQL: create function wizard from template
  • MySQL: create procedure wizard from template
  • MySQL: Freeze trigger
  • MySQL: Drop table trigger
  • MySQL: drop trigger
  • MySQL: All trigger list
  • MySQL: alter table order by wizard
  • Oracle: Ctrl and PgDn, PgUp in types view like on packages
  • Oracle: structure analyzer on types view
  • Oracle: highlight keywords: constructor and member
  • MySQL: restore procedure/function on compile error
  • Oracle: Freezing shortcut F3
  • Fixed:
  • IDE: NullPointerException on editor with structure
  • IDE: set an incorrect number format in the settings
  • Oracle: structure analyzer is lost
  • MySQL: comment edition apostrophe problem
  • Oracle: comment edition apostrophe problem
  • Modified:
  • DOC: Pages next/prev on orbada history page
  • SQL Queries tab, text action "select database"

New in ORBADA 1.0.4.85 (Jan 3, 2011)

  • Added:
  • IDE: info if new version released
  • MySQL: wizard for create foreign key
  • MySQL: wizard for create table index
  • MySQL: wizard for create unique constraint
  • MySQL: wizard for create primary key
  • MySQL: Enable/Disable keys wizard
  • On list of last updated object add search field
  • MySQL: wizard for create table as select from view
  • MySQL: wizard for create table as select from table
  • MySQL: wizzard for checksum table - added on details tab for selected table
  • MySQL: wizzard for repair table - added on details tab for selected table
  • MySQL: wizzard for analyze table - added on details tab for selected table
  • MySQL: wizzard for optimize table - added on details tab for selected table
  • MySQL: Freeze procedure
  • MySQL: Freeze function
  • MySQL: Freeze view
  • MySQL: Freeze table
  • MySQL: freezing mechanism
  • MySQL: columns or parameters info on sql queries tab
  • MySQL: drop primary key or foreign key
  • MySQL: drop table index or primary key
  • MySQL: check view (specification view for selected view)
  • MySQL: check table (specification view and option on detail tab for selected table)
  • MySQL: copy view columns list to cliboard
  • MySQL: copy table columns list to cliboard
  • MySQL: wizard for table column NULL/NOT NULL
  • MySQL: wizard for default value of table column
  • MySQL: wizard for comment column table
  • MySQL: drop table column
  • MySQL: wizard for comment table
  • MySQL: wizard for rename table
  • MySQL: truncate table
  • MySQL: drop function
  • MySQL: drop procedure
  • MySQL: drop view
  • MySQL: drop table
  • Fixed:
  • MySQL: problem with parameters list of procedure/function
  • Problem with display TIMESTAMP
  • Oracle: text (pl) for cache table option
  • Problem with inactive notifications on menu program
  • Modified:
  • HSQLDB: Explain plan option not visible in sql queries menu
  • MySQL: CREATE OR REPLACE instead of ALTER VIEW
  • all the functions / actions in the "Actions" menu
  • MySQL: tool window for database select is too small

New in ORBADA 1.0.3.72 (Dec 6, 2010)

  • Added:
  • 3097702 - MySQL plug-in
  • Plug-in for MySQL Database was made for using and testing.
  • For now it contains:
  • Database objects info collecting for sql editor
  • Explain plan tab in sql queries (Ctrl+E)
  • View with MySQL build-in help
  • Extended tab for "Connection info" view
  • Tables view with:
  • column list
  • indexes
  • constraints
  • triggers
  • privileges
  • column privileges
  • referenced to
  • referenced from
  • table details
  • content
  • table creation script
  • Views view with:
  • column list
  • content
  • view creation script, editing enabled
  • #3127531 - Read only indicator on editor when is not editable
  • #3127515 - Cursor on editor when is read only
  • Fixed:
  • #3128194 - Universal tab with data table, table name for MySQL
  • #3127980 - UpperCase and LowerCase in editor names of the mysql
  • Modified:
  • #3106851 - documentation
  • Added section with helpful shortcut keys
  • #3124817 - default content editor (tab SQL Queries) memorizing for schema

New in ORBADA 1.0.3.67 (Nov 29, 2010)

  • Added:
  • properly display :: operator (like postgres cast) in editor
  • Add showing explain plan getted from system view v$sql_plan
  • View "SQL Plans" was made in Oracle Tune plug-in.
  • To start the functionality, the schema for which you are connected, must have privileges to objects: "V$SQL", "V_$SQL", "V$SQL_PLAN" and "V_$SQL_PLAN".
  • You can just connect as SYSTEM or SYS user.
  • Plug-in depends
  • Fixed:
  • Proper cleaning "Display time as Please Wait"
  • NOT NULL CONSTRAINT CHANGE
  • Modified:
  • some improvements
  • pl.mpak.util: Variant (big decimal)
  • pl.mpak.usedb: column sorting
  • Edit the comment columns of the table does not include the newly added column
  • Documentation updated..

New in ORBADA 1.0.3.64 (Nov 23, 2010)

  • Added:
  • Display time as PleaseWait
  • Octopus animation as PleasrWait display
  • Plug-in for visited and edited objects
  • Added a window showing the last modified database objects. The window is available from the "Tools" menu or the shortcut Ctrl+Alt+F8. Plugins: orbada-oracle and orbada-firebird that support freezing facilities, respecting the appropriate messages and let you see objects.
  • integration with sf.net tracker system
  • From the menu "Program", you can now go directly to the sourceforge.net and report a future request, problem with application and from the window of exception - error.
  • Fixed:
  • Java objects not stored in local history
  • Problem during editing action script
  • Can't find resource for bundle java.util.PropertyResourceBundle, key ComponentActionsAction-implemented
  • Refresh object problem on Oracle plug-in
  • Modified:
  • Default laf JGoodies and Metal tab style