Linux SoftwareDatabaseAdministrative frontendsJava SQL Admin Tool 2.4.0

Java SQL Admin Tool 2.4.0


Admin is entirely written in Java
Developer:   Fredy Fischer
      more software by author →
Price:  0.00
License:   LGPL (GNU Lesser General Public License)
File size:   506K
Language:   
OS:   
Rating:   0 /5 (0 votes)
Your vote:  
enlarge screenshot


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.

Requirements:
Admin runs with JDK 1.4.x because it is using the java.util.logging API to give more Info. As well as you need a RDBMS and a JDBC-Driver, see the Tested with section.
You need to add the following libraries to your CLASSPATH

  • JDOM for the Codegenerator
  • Martin Newsteads MSeries for the Codegenerator
  • Calendarbean for the Codegenerator
  • I did some tests with servlets, so if you want to dig in, you need to have servlet-engine
  • POI if you want to export data into XLS


    What's New in This Release:
    Data Export

  • This version got a better data export utility. Thanks to the Apache POI -Project it is possible to export Data directly into XLS-file format. Also I changed the behaviour of the CSV-exporter to be much faster, because I'm now using a PrintWriter to export data. There is a simple way to export into XML-Format (please let me know, if it feeds your needs).

    Licensing

  • The License changed to LGPL to make Admin more available.

    Dashboard

  • If the underlying RDBMS is MySQL there is an additional menu that opens a simple dashboard, to see, what MySQL is doing


    Installation

    Best thing is, to create a own directory, let's name it ./java. Then unpack admin in this directory. It will create the tree:

    gpl/fredy/admin you will find there in the main classes of Admin
    gpl/fredy/share all common used classes
    gpl.fredy.ui the user interface classes, needs
    gpl.fredy.share
    gpl.fredy.metadata
    gpl/fredy/images here you will find the images used by admin.
    gpl/fredy/metadata the classes that handles all about meta-information of the DB
    gpl/fredy/sqltools the classes around the tools struggeling around with SQL-commands, needs
    gpl.fredy.share
    gpl.fredy.metadata
    gpl/fredy/generate all about generating code, needs:
    gpl.fredy.share
    gpl.fredy.ui
    gpl.fredy.metadata
    gpl.fredy.io
    applications/basics here you will find all the classes needed for launching generated applications. As soon as you generate the first classes, there will be a directory named as the database is named.

    So you see, the path to ./java has to be in your classpath and you are on speed.
    tags gpl fredy  fredy metadata  fredy share  the codegenerator  you will  needs gpl  export data  for the  share gpl  will find  the classes  metadata gpl  you need  

    Download Java SQL Admin Tool 2.4.0


     http://www.trash.net/~ffischer/admin/sources/unix/sources.tar.gz
     http://www.trash.net/~ffischer/admin/sources/unix/sources.tar.Z
     http://www.trash.net/~ffischer/admin/sources/unix/sources.zip


    Authors software

    Java SQL Admin Tool 2.4.0 (by Fredy Fischer)
    Admin is entirely written in Java


    Similar software

    Java SQL Admin Tool 2.4.0 (by Fredy Fischer)
    Admin is entirely written in Java

    JDatabaseImport 0.1 (by Guilherme Silveira)
    JDatabaseImport is a simple tool created to import data between different databases.

    How does it work?

    You can work with it in

    DBD::mysql 3.0007 (by Jochen Wiedmann)
    DBD::mysql is a Perl module with MySQL driver for the Perl5 Database Interface (DBI).

    SYNOPSIS

    use DBI;

    $dsn = "DBI:

    Java for C++ 0.4 (by Stefan Palme)
    Java for C++ is a tool to generate C++-wrapper-classes for existing Java-classes

    BBDB::Export 0.012 (by wu)
    BBDB::Export is a Perl module to export data from The Insidious Big Brother Database.

    SYNOPSIS

    use BBDB::Export;

    # expor

    Gaudi - Database Visual Editor 1r1 (by Memoria Persistente)
    Gaud? - Database Visual Editor is a Java application that allows you to visually design the tables of a database using a JDBC 2.0 (or

    EMS Data Export 2005 for PostgreSQL 1.5.0.4 (by EMS Database Management Solutions, Inc.)

    Photovault 0.3.1 (by Harri Kaimio)
    With it you can easily keep even a large photo archive in good order and find the images you need.

    Here are some key features of "Ph

    DBD::mSQL 1.2219 (by Jochen Wiedmann)
    DBD::mSQL / DBD::mysql is a Perl module with mSQL and mysql drivers for the Perl5 Database Interface (DBI).

    SYNOPSIS

    use DB

    Druid 3.8 (by Andrea Carboni)
    Druid project is a tool that allows users to create databases in a graphical way


    Other software in this category

    phpMyAdmin 2.9.1.1 (by phpMyAdmin Devel Team)
    phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW.

    Currently it can create and drop

    TUTOS 1.3.20060914 (by Gero Kohnert)
    TUTOS prpject is a tool to manage the the organizational needs of small groups, teams, departments ...

    Here are some key features

    Information Resource Manager 1.5.7 (by Yann Ramin)

    Netjuke 1.0 RC2 (by Blake Watters)
    Artekopia Netjuke is a cross-platform Web-based audio streaming jukebox powered by PHP 4 and an increasing choice of databases.

    MP

    TYPO3 4.0.3 RC1 (by Kasper Sk?rh?j)
    TYPO3 is a free Open Source content management system for enterprise purposes on the web and in intranets.

    TYPO3 offers full flexi

  •     search


    Featured Software

    jEdit 4.3 pre8
    jEdit is an Open Source text editor written in Java

    Opera 9.02
    Surf the Internet in a safer, faster, and easier way with Opera browser

    GNU Aspell 0.60.4
    GNU Aspell is a Free and Open Source spell checker designed to eventually replace Ispell


    Subscribe in Rojo
    Google Reader
    Add to My Yahoo!

    Add to My AOL
    Subscribe with Bloglines
    Subscribe in NewsGator Online
    Add 'nixbit linux software' to Newsburst from CNET News.com
    del.icio.us nixbit linux software


    Top tags