ThinkUI SQL Client

ThinkUI SQL Client is designed for the Java developers that need to work with multiple databases and would like to a tool with features that will improve their productivity and will help reduce the tedious nature of software development.

Supported Databases (Using either JDBC 2.0 or JDBC 3.0): � Oracle Database � IBM DB2 � IBM Cloudscape / Apache Derby � Microsoft SQL Server � MySQL � PostgreSQL

Here are some key features of "ThinkUI SQL Client":

￭ Support for any Java 1.4 supported platform ￭ Support for any database using JDBC 3.0 (except for SQL create table query generation) ￭ Support for read only access to a database (to prevent accidental data modifications) ￭ Support for Logging output a file or console (with runtime control of logging ￭ Meta Data Browser, SQL Query, & Data Object Editor ￭ Database meta data tree browser (schemas, tables, views, sequences, indices, constraints, triggers, procedures) ￭ Table column meta data grid browser (column name, type, size, nullable, default etc.) ￭ SQL query (auto generate SQL create, select, insert, update queries from table meta data) ￭ Table data grid browser with multi column sort (any combination of ascending and descending) ￭ Right-click menu support to zoom to related foreign key records and certain column values ￭ Graphical user interface for data entry of all tables (object viewer with support for apply and copy as new) ￭ (supports edit of table rows grid as well as selected row from arbitrary SQL query with a single table) ￭ Object viewer automatically display parent-child data with picklist and zoom to related records support ￭ Graphical user interface for executing stored procedures ￭ Data model capture and customization (import from specified database into internal database) ￭ List all related tables (performed recursively to find all dependent tables) ￭ Support for saving SQL queries into a local repository for later reuse. The queries can be associated with a default DB connection to allow convenient execution using the SQL query viewer. The queries are grouped under a particular Project and is limited to 1024 characters. ￭ Code generation of various artifacts using Velocity templates and database meta data ￭ Meta data retrieved from database table, view, stored procedure, imported data model, and SQL query ￭ (supports single table/view queries as well as multi table joins) ￭ Template files can be easily modified (Javadoc available for code generation API) ￭ Generated code can be saved to file (with full package folder path) or copied to clipboard for easy copy & paste ￭ Template parameter values are stored as user preferences for efficient code generation

Requirements:

￭ Java Runtime Environment (JRE) version 1.4 or later ￭ Required JDBC drivers for your databases