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.