JDBC Navigator Changelog

What's new in JDBC Navigator Build 2709

Aug 26, 2014
  • Apparently, some obscure JDBC driver doesn't support DriverManager.
  • getConnection(String url, Properties props). Modified the connection code so
  • that it only uses that API when connecting to Oracle (that's the only case when
  • we specifically need it), and use getConnection(url, user, pass) for all
  • others.

New in JDBC Navigator Build 2708 (May 19, 2014)

  • Fixed more connection config deletion breakage.

New in JDBC Navigator Build 2707 (May 19, 2014)

  • Bug workaround for SQLite: DatabaseMetaData.getPrimaryKeys() returns an
  • element with KEY_SEQ = 0, which should never happen accoring to the JDBC API
  • documentation; KEY_SEQ is a 1-based index. Simply ignoring this element fixes
  • the problem.
  • Note, however, that the SQLite JDBC driver has other bugs in its metadata
  • handling as well (as of May 17, 2014) -- specifically, it throws exceptions
  • from DBMD.getIndexInfo() in many cases -- so use JDBC Navigator with SQLite at your own risk.
  • Deleting a connection configuration was broken: it would be removed from the
  • menu, but not from the stored configs, so it would reappear the next time the
  • Open JDBC Connection dialog was presented.

New in JDBC Navigator Build 2706 (Jan 23, 2013)

  • Generating escaped HTML strings would choke on character codes greater than
  • 255. This could cause saving File databases and presenting table details
  • windows to fail. Fixed.
  • When importing CSV files into tables, empty strings would be treated as
  • nulls. Fixed.
  • Upgraded Rhino to 1.7R4, and added generics

New in JDBC Navigator Build 2705 (Jan 23, 2013)

  • With Java 1.7, the Preferences, MessageBox, and Binary Editor windows would
  • throw a ClassCastException in their constructors. Fixed.

New in JDBC Navigator Build 2703 (Jan 23, 2013)

  • The JDBCDatabase constructor was protected, which caused opening
  • unrecognized database types to fail. Changed it to public, fixing the problem.
  • Improved JDBCDatabase.makeTypeSpec(): it now recognizes basic string,
  • numeric, and date/time types, so that some basic table editing is now possible
  • even with unsupported databases.

New in JDBC Navigator Build 2700 (Jan 23, 2013)

  • In JDBCDatabase.getJavaTypes(), added a "where 1 = 2" clause to the
  • statement used to find a table's column types. This prevents stupid JDBC
  • drivers (specifically, MySQL) from actually loading the whole table when all
  • we want is the metadata.

New in JDBC Navigator Build 2697 (Jan 23, 2013)

  • Changed the homepage URL to http://thomasokken.com/jdbcnav/.

New in JDBC Navigator Build 2696 (Jan 23, 2013)

  • Sorting on byte[] columns works now.
  • When moving columns, the column formatting would not move. Fixed.

New in JDBC Navigator Build 2688 (Jan 23, 2013)

  • Running a query that selects columns from only one table, including all of
  • that table's PK columns, now returns an updatable query result *even* if the
  • JDBC driver does not provide catalog/schema/table information in ResultSet.
  • Formerly, with such drivers you would only get an updatable query result if you
  • performed a "select *".

New in JDBC Navigator Build 2684 (Jan 23, 2013)

  • The initial Database.getRootNode() call, which loads all the table metadata
  • when a JDBC connection is opened, is now performed in the background, so it
  • does not freeze the UI.