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