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