Projects / Java SQL Admin Tool

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, Derby, InstantDB, Oracle, Empress, MS SQL Server, 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. There is a tool with which SQL statements can be enriched with a few commands, generating a GUI to easily select data from a DB. You can also export and import data and transport it from one DBMS to another.

Tags
Licenses
Operating Systems
Implementation

Recent releases

  •  29 May 2014 09:21

    Release Notes: The login window now allows you to save all parameters to a file and to load parameters from previously saved files. A Jasper Report Viewer based on Jasper classes was integrated. Database Info has been extended. You can now set a table name filter pattern, and create files using Graphviz dot notation to visualise databases. SQL Monitor offers some helpers, accessed by pressing the middle mouse button within the pick list item window.

    •  05 Dec 2010 12:41

      Release Notes: This version has a new utility to import XML data files into an RDBMS table. The checkbox panels from data drilling now have a toggle button to select or unselect everything with one click. Some tests were done with Apache Derby and support was added for Derby for table creation.

      •  11 Nov 2007 14:30

        Release Notes: 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 15:11

          Release Notes: 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 09:55

            Release Notes: 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.

            Recent comments

            24 Jan 2003 11:36 afs

            Re: 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.

            20 Oct 2002 15:25 schrabnel

            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.

            Screenshot

            Project Spotlight

            OpenStack4j

            A Fluent OpenStack client API for Java.

            Screenshot

            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.