BasicQuery is a Java-based application used to access databases through JDBC. It features a Swing-based GUI and includes capabilities useful to developers when testing SQL statements against a database. It also produces timing information, which is valuable during tuning exercises.
|Tags||Database Software Development Testing|
|Operating Systems||OS Independent|
|Translations||German French English Italian Spanish|
Release Notes: Support for placing multiple SQL statements in the query text area, each separated by a semicolon was added. BasicQuery will split the input at each semicolon (unless they are within quotes) and execute each statement independently. The feature can be enabled and disabled by a menu option. All statements in the group must be the same type (selects [with resultsets] versus modifications [update, insert, delete, DDL]).
Release Notes: This begins the next cycle of feature additions scheduled for the 01.04 version. The configuration files have been moved to a sub-directory of the user's home. This will prevent overwriting of configuration files when future versions are installed. The user may now control the font type and size for the messages and data displays. Driver definitions and connect string templates for several DBs have been added to the default driver and connect files. Included are Apache Derby, Informix, and DB2.
Release Notes: This fixes a bug with the handling of incorrectly formatted definitions for user defined row coloring. BasicQuery will now simply report that the color definition cannot be parsed and will ignore the affected portion of the color definition.
Release Notes: This production release encompasses support for 6 languages, a soft-reference-based results cache, and numerous options for controlling application behavior, including reporting of client and server details. Upgrading is recommended. On the source code side, this version completes the integration of log4j, JUnit, and Cobertura. The test suite is fairly complete, other than automating the testing of the GUI components.
Release Notes: Resource bundles were added for French, German, Italian, Portuguese, and Spanish in addition to the original English. The program will use the system configured language/country to attempt to find the correct resource bundle, but has the option to override that setting. Changes were completed for all messages/widgets within the application frame to use the resource bundle values. Finally, a couple of minor bugs were fixed, including resolution of an issue causing leaking DB connections when the database details were being output.