Java SQL Admin Tool
Admin is entirely written in Java. It uses Swing GUI Components and JDBC to connect to databases. It has been succesfully tested with MySQL, InstantDB, Oracle, Empress, and PostgreSQL. You can have a tree view of the RDBMS or pick a single instance to have a look at its metadata. It allows you to create, modify, and drop tables and to create indices on a table. The dynamic form makes it easy to enter data into a certain table, and the guided query makes it easy to retrieve data from a table and to export it. Java developers will probably enjoy the code generator doing an OO relational wrapper and a swing GUI for them. You can also export and import data and transport it from one DBMS to another.
| Tags | Database Front-Ends Software Development Code Generators |
|---|---|
| Licenses | GPL |
| Operating Systems | OS Independent |
| Implementation | Java |
Recent releases
- 11 Nov 2007 06:30
Changes: This version has a new tool, called Data Selection. This tool was initially developed to allow complex data selections for users not knowing much about RDBMS and Joins and other such complicated things in the world of databases. This tool has been in production for three years. SQLAdmin can now also be launched via Java Webstart.
- 08 Oct 2004 08:11
Changes: This release adds a new CreateTable-GUI which allows you to create the table within a grid. It supports additional parameters not available in the "old" Version; you can set default values, check-constraints, and foreign-key-relationships. There is an editor that allows you to select the referencing column by simply clicking it. SQL-Monitor now allows the use of "desc". Bugs have been fixed.
- 17 Aug 2003 02:55
Changes: This version features a better data export utility, it is faster, and supports CSV, XLS, and XML format. If the underlying RDBMS is MySQL there is an additional menu to display a dashboard.
- 18 May 2003 01:36
Changes: The generated code now has an additional constructor to save connections to the DBMS. This new constructor allows giving an existing connection over. Getting the next() row also now reuses the existing connection. The code generator has two additional buttons that allows developers to compile and run the generated code.
- 22 Jan 2003 07:44
Changes: The number of connections can now be defined. If this number is exceeded, the connections are cycled. This means that Admin can now be used on an RDBMS without exceeding the number of connections allowed by the license. java.util.logging is now used. AlterTable is now more compatible with different RDBMS. Some fixes were made within the code generator. StackTraces now popup in a window and offer much more information. SimpleLogServer, which captures a logrecord configured to be sent by java.util.logging.SocketHandler, was added. A DashBoard for MySQL is now available.
- All comments
Recent commentsRe: Bad Exception Handling
> The Software seems to be real nice, yet
> it lags to give out any meaningful
> exceptions. Such as it does not seem to
> correctly accept the image system
> property, nor does it give out any
> meaning ful stacktraces when dealing
> with jdbc.
I did some enhancements into this direction. Many
thanks for the hint. Best in common with the java.util.logging mechanism. So I also did a simple
logserver listening on a port. I think, this now gives a lot of info. Hope I met your needs.
Bad Exception Handling
The Software seems to be real nice, yet it lags to give out any meaningful exceptions. Such as it does not seem to correctly accept the image system property, nor does it give out any meaning ful stacktraces when dealing with jdbc.