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!
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.
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.
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.
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.
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.
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
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)
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.
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.
JSQLTool release 1.0 is available.
The distribution includes jar file libraries, source files, javadoc, licence and readme.txt installation instructions.
