SQL Client

If you have never used this program before, read below first.

Security Certificate

You may be prompted about a "Security Warning" and asked whether you want to accept my security certificate, which is not signed by a trusted authority. Whether you accept my certificate is up to you, but this program requires you to accept it in order to work - this program makes network connections to databases you specify and has features that allow you to read and write data to your local hard drive.

This client is a work in progress.

Known Bugs

The Oracle JDBC driver (11.2.0.1) for Java 6 doesn't provide the isAutoIncrement API despite the fact that it claims to be JDBC 4.0 compliant. So I currently always report isAutoIncrement to be "No" for Oracle table columns.
The Microsoft JDBC driver (3.0.1301.101) for SQL Server always seems to report "No" for isAutoIncrement for a column, even when the column is an identity column.
If you query DB2 UDB "select * from syscat.columns" you will get a java.io.CharConversionException. Workaround: Avoid selecting the columns high2key and low2key from this table (don't use select *).
(Let me know if you find other bugs!)

Features not fully tested

Export (of a query/table) - mainly tested with DB2 but should work with other databases except in special cases.
Export (of a query/table) - columns of type Array, and other less common types may not be exported properly.

One thing that may annoy you

If you have several queries on the SQL tab and highlight one with your mouse to run it, as soon as you hit the Execute button the query will lose the highlight. So if you want to run it again you need to re-highlight it (unless it's the only query there). I hope to address this issue but it's actually not an easy thing in Java due to the way Swing works.