Home page SourceForge.net Logo
 Home
 Documentation
 To do
 Download
 Project page

Project description
JSQLTool is java swing SQL Tool which can be used to:

  • connect to a database, using a JDBC or ODBC Driver
  • view tables, views and synonyms list
  • for each table/view/synonym see entity details, like: structure, data, indexes, constraints, SQL script and triggers
  • table data can be visually ordered/filtered; you can add/edit/delete records directly on the table data grid
  • table data can be exported as insert SQL statements, as text or in an Excel File Format (XLS)
  • edit SQL statements in a SQL shell (by coloring SQL text according to syntax), by means of it you can execute queries or other statements and see query results; queries may contain parameters
  • previous SQL statements are recorded to allow re-call and re-execution
  • view a database schema E/R diagram, store and recall schemas, print and export them
  • replicate a set of tables to another schema, by creating tables and populating them. Replication task can be replicated to update data
  • many other features are available, according to the database type: edit/drop contraints, execution query explain plan, trace sessions
Table detail is pluggable: developers can add other table plugins to easly extends the application.
The whole application is designed to support multi-language and internationalization: at the moment these are the languages supported: english, french and italian.

Note: I am available to include support for other languages: if you are interested please email me or create a news in the forum!

  2007-03-20   1.1 version available
JSQLTool release 1.1 is available.
This is a fix patch that resolves some problems related to inserting/updating data in table detail panel, on tables/data replication and on SQL Server connections.
The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.

Click here to download JSQLTool

  2006-11-06   1.0.9 Fix Patch available
JSQLTool release 1.0.9 is available.
This is a fix patch that resolves some problems related to inserting/updating data in table detail panel.
The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.

Click here to download JSQLTool

  2006-09-28   1.0.8 Fix Patch available
JSQLTool release 1.0.8 is available.
This is a fix patch that resolves the following issues:
  • eliminates database errors on fetching data on table detail folders (expecially on Oracle databases)
  • speed up table detail data fetching by retrieving data only when the user clicks on the folder
  • enable drag 'n drop on entities lists on Database Schema

The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.

Click here to download JSQLTool

  2006-09-04   1.0.7 Fix Patch available
JSQLTool release 1.0.7 is available.
This is a fix patch that resolves some problems related to data editing in table detail panel: now insert/update/delete operations in table detail panel could use a double quote " around a table field (useful for example in Teradata databases), according to the "Add quotes to insert/where fields" setting in "Data Connection" window.
The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.

Click here to download JSQLTool

  2006-08-28   1.0.6 Fix Patch available
JSQLTool release 1.0.6 is available.
The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.
This is a fix patch that resolves some problems related to data replication.
It also adds a new window to the application: "Database Schema"; it allows to view a database schema E/R diagram, compose it, store and recall schemas, print and export (in PDF format) them.

Click here to download JSQLTool

  2006-08-01   1.0.5 Fix Patch available
JSQLTool release 1.0.5 is available.
The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.
This is a fix patch that resolves some problems related to data replication.

Click here to download JSQLTool

  2006-07-31   1.0.4 Fix Patch available
JSQLTool release 1.0.4 is available.
The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.
This is a fix patch that resolves some problems:
  • on executing queries on SQL Editor when SQL started with spaces
  • on viewing table detail with MySQL databases on VARCHAR columns

It also add the following features:
  • quick filter on data table using right click mouse
  • data replication between two database schema, by selecting a list of tables to replicate

Click here to download JSQLTool

  2006-06-26   1.0.3 Fix Patch available
JSQLTool release 1.0.3 is available.
The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.
This is a fix patch that resolves some problems on loading/saving connection profile ini files.
It also add the following features:
  • a SQL script panel to the table detail
  • a trigger panel to the table detail
  • improve coloring policy in SQL Shell
  • "Add Column", "Drop Column" and "Drop Table" commands to the table detail
  • "Import sql script" command to the application menu and to SQL Shell toolbar; the command allows to execute a SQL script file in "batch" mode (to speed up the execution of big sql script files)

  2006-06-19   1.0.2 Fix Patch available
JSQLTool release 1.0.2 is available.
The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.
This is a fix patch that resolves database errors on viewing table details, listing schema list, listing tables list, updating dates on grid and executing queries with parameters.
It also add a progress bar to indicate wait for progress.
It also improves CTRL+SPACE and . commands on SQL Shell.
It also improve SQL Shell by coloring text according to SQL syntax.

  2006-06-15   1.0.1 Fix Patch available
JSQLTool release 1.0.1 is available.
The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.
This is a fix patch that resolves table detail visualization problems and database errors on viewing table details.

  2006-06-14   Final release 1.0 available
JSQLTool release 1.0 is available.
The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.



Community
Public forums:
http://sourceforge.net/forum/?group_id=170128
Mailing lists:
http://sourceforge.net/mail/?group_id=170128

Thanks to...
...all people who download and use this application and would give me any suggestion to improve it.


(c) 2006 by Mauro Carniel