ThinkUI SQL Client was created for Java developers who need to work with multiple databases and would like to have a tool with features that will improve their productivity and help reduce the tedious nature of software development.
Supported Databases (Using either JDBC 2.0 or JDBC 3.0):
· Oracle Database
· IBM DB2
· Microsoft SQL Server
· PostgreSQL
· IBM Cloudscape / Apache Derby
· MySQL
Here are some key features of "ThinkUI SQL Client":
· Support any Java 1.4 or higher platform (tested on Mac OS X, Windows 2000/XP, Linux)
· Support for selected databases using JDBC 2.0 and any database using JDBC 3.0
· Intuitive MDI user interface supporting multiple databases
· Generic data entry of all tables with picklist and zoom to related records support
· Database meta data browser (schemas, tables, views, sequences, indices, constraints, triggers, procedures)
· SQL query (auto generate SQL create, select, insert, update queries from table meta data)
· Graphical user interface for executing stored procedures
· Data model capture and customization (import from any database or Java code into internal database)
· Data import from flat file (Excel, CSV, and Tab delimited files supported)
· Custom code generation (Java Bean, EJB, JSP, DAO, SQL, etc. using Apache Velocity Engine templates and database meta data)
Requirements:
· Java 1.4 or later.
What`s New in This Release: [ read full changelog ]
· This release adds numerous features and enhancements to help improve the productivity of Java developers.
· New features includes improved management and execution of SQL query objects.
· Copy As "String Expr" feature for saving SQL query in Java code.
· Aew code generation templates and related enhancements.
· Various GUI usability and performance improvements such as the loading of meta data.
· This release also adds support for setting the user preferences for the application LnF as well as various fonts sizes.
Features Added:
· Improved refresh performance when deleting a large number of objects that causes a refresh to occur in the DataObjectTreeViewer. Now, the tree viewer will wait until the last record is deleted before simply refreshing the parent tree node.
· Added support for setting the "Prompt On Exit" user preference.
· Added support for COMMA_SEPARATOR and VALUES_SEPARATOR parameters to provide more control of the formatting of the generated SQL statements. This was done mainly to su...