Main

Screenshots

Download

Install

Change Log

Bugs

To Do

Mailing List

Links

License

Please report bugs on the ViennaSQL mailing list www.topica.com/lists/viennasql/read.


Installation is fiddly. A free, portable and simple installation tool for Java applications is needed. Anyone know of one?


If there is an error in an SQL statement, Vienna does not tell you where. I can't work out how to get this information from JDBC. I have a horrible feeling it isn't available. Can anyone help with that?


If you execute a "commit" or "rollback" statement, the GUI doesn't know there are no longer any updates to commit and the "commit" and "rollback" buttons are still active.


After saving the configuration, the current connection is closed. (This is an unfortunate side-effect of the Observer/Observable behaviour used by Models and Views).

Fixed in version 0.12.


The Schema List dialog doesn't respond to mouse clicks the second and subsequent time it is opened.

Fixed in version 0.12.


Saving the configuration sometimes fails with an unhelpful "java.awt.Font" error dialog.

Fixed in version 0.13.


There may be a problem with the thread handling in the schema view. ViennaSQL has been reported to lock solid when switching between tables. This requires careful inspection of the thread handling code.

I believe this happens when waiting for the rdbms to respond to a request for a table's column list. ViennaSQL waits for one fetch to complete before starting another. This is to prevent dozens of threads getting started which will return columns details we don't want. ViennaSQL doesn't interrupt () the running thread as Oracle's JDBC driver will crash and burn if interrupted. This means we have to wait for the current request to complete before starting another.

More information: I managed to reproduce this by repeatedly dragging up and down the table list. If the button is then released on a synonym that isn't for a table, ViennaSQL pops up a message dialog. This wasn't done in the event dispatch thread which upset Swing. Changed that to use the event dispatch thread.


Column selections in the Schema view are not cleared when switching to another table.

Fixed in version 0.14


Underscores may be stripped from the password in the configuration XML file.

I have been unable to reproduce this.


This page is maintained by Mike Wilson.
Comments and suggestions are welcome.