VisualSQL is a JDBC client for databases. You can send SQL queries and see the result in a table. It is released under GPL thus, the sources are available.
Auto installer vsql-0.5.jar
To install VisualSQL, you must first :
To install VisualSQL, type
java -jar vsql-.jar in the directory of the
archive. This will launch the auto installer. You must then drop the
JDBC driver for your database in the lib directory of VisualSQL.
Windows users must edit the bin\vsql.bat file to add the driver jar
file in the CLASSPATH. If your driver’s archive is a zip file, simply
rename it to make a .jar file.
The latest version of VisualSQL is on my web page.
To build VisualSQL, you will need Ant version 1.3, you will find it on
Apache web site. Go to the
directory and type
ant all to rebuild from sources.
vsql on the command line to launch VisualSQL. The application
will look like :
First, you must connect to the database:
Then click on the button to connect. If connection fails, a dialog box should detail the error. When connected (no error message), you can send SQL queries to the database by typing them in the text area and clicking on the query button. The result is shown on the lower pane. You can display previous queries with arrows (up for previous and down for next ones).
You disconnect from the database when quitting or by clicking on the disconnect button. When quitting, your configuration is saved in a configuration file (~/.vsql.properties on Unix or <VSQL_HOME>\vsql.properties on Windows). The query history (last 100 queries) is saved in a file (~/.vsql.history on Unix or <VSQL_HOME>\vsql.history on Windows).
Key bindings are the following:
The database connection properties are saved when you quit the application in the following properties:
There are other properties you can change by editing the properties file:
This software is free and released under the GPL. You can find a copy of this license in the file LICENSE in the installation directory.
Bug correction (query related key bindings were active even when not connected to the database).
Disconnection from the database on VM shutdown (using finalizer execution request on 1.2 VMs and a shutdown hook on 1.3).
The program has been completely rewritten using a (supposed) clean object design.
Bug corrections (the program didn’t started if no history file was found in the user’s home) and enhancements (tool tips on the column headers). Thanks to Laurent ROMEO for his contribution.
Directory tree changed, Hot Keys and theme added.
Minor bug fix (related to the Connect button) and an enhancement (related to the History list).