About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
See full specifications

linux default iconJava SQL Admin Tool for Linux Publisher's description

This is a Java-based Admin-Tool for SQL-Databases via JDBC. It needs to have JDK 1.6 underneath

This is a Java-based Admin-Tool for SQL-Databases via JDBC. It needs to have JDK 1.6 underneath

In the beginnings of Java I had my first look at this exciting product. So I decided to learn more about Java. As beeing a developer for data-base-applications and generator in my former life it was a short decision to use a database related case for learning Java. So I started at the end of 1995 the development of a tool to manipulate mySQL-Datatabase.
As JDBC (Java Database Connectivity) supports a lot of functions around metadata, it was a good starting point for learning Java. When Swing came out the GUI-capabilities of Java got much more functionalities. So I choosed Swing as the GUI-representation of my new tool.
The first steps with Java where pretty hard for a procedural software developper I was of about then years, but thanks to the help of some friends I got my first impression of how object oriented programming probably looks like and was able to implement the first function. To really get on speed I did not choose a 'Hello World' thing, I directly jumped into the development of the 'Guided-Query'-class. While doing so, I had to learn how Java handels Meta-Data and how these layout-managers works to create my first Swing-GUI. While time was passing by, Admin got more and more functions and thanks to the JDBC-concept it was able to support other databases. Today I did some tests with mySQL, PostgreSQL, InstantDB, HypersonicSQL and Oracle, partwise it also works with Access. As the intention of the project is to learn about Java I put it under open-source. To publish this tool I became a member of the organization trash.net .

Admin is absolutely free for download and use.
Admin offers today the following functions:
* Create Table
* Create Index
* Drop Table
* Modify Table
* Guided Query
* SQL-Monitor
* Dynamic online form
* Generate Java Code out of a XML-File (a Relational-Object-Wrapper and a Swing-Form and a JTableModel)
* Meta-Data Info of a DB

All the windows are generated as panels, they are able to run as standalone as well.
Such a tool is a ongoing project, so the plans for the future looks as follows:
* your ideas and contributions
* extend the generator for JSP / servlets

What's New in This Release:

В· This release 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.

System 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
Program Release Status: Minor Update
Program Install Support: Install and Uninstall

Java SQL Admin Tool for Linux Tags:

Click on a tag to find related softwares

Is Java SQL Admin Tool for Linux your software?

Manage your software

Most Popular

linux default icon A2Billing 1.6.0
A2Billing is a billing system interactive with Asterisk to give any Telecom company traditional offering VOIP... Read more
linux default icon FrontAccounting 2.3.10
FrontAccounting is free and released under the GNU General Public License.
linux default icon PgAdmin III for Linux 1.14.1
pgAdmin is the most popular and feature rich Open Source administration and development platform for... Read more
linux default icon RazorSQL for Linux 5.6.3
RazorSQL is an SQL query tool, database browser, SQL editor,....
linux default icon Salat Book 1.00
Salat / Namaz prayer database and tracking application