DB Cruiser Features Highlight:
 
In addition to the standard features an SQL database access tool usually has, such as exploring tables and stored procedures, execute SQL statements, display table column definitions, primary keys, foreign keys, and table indexes, etc., DB Cruiser has the following major unique features:
 
  One uniform GUI to access different SQL databases products: You can access any SQL database in the same way, as long as the database product has JDBC 2.0 or later driver via DB Cruiser, including (but not limited to) ORACLE, DB2 Universal Database (UDB), Sybase, MySQL, Informix, PostgreSQL, PointBase, HSQL Database Engine, etc.

  Work on Multiple Tables and Multiple Databases Simultaniously. Every table has its own Table Work Area (see section 5 of the User's Guide for the details). You can open several Table Work Area panels at the same time to execute multiple queries (in different Table Work Areas), then do the side-by-side comparisons, etc.

  Navigating among Tables based on Parent/Child Relationship. With mouse clicks, you travel among parent or child tables, based on the foreign key relationship. See section 5.15, 5.16 and 5.17 of the User's Guide for details.

  Load bulk data, and transfer/convert data between databases :
Load bulk data in many formats, including spreadsheets, and user defined delimiters. Combine this feature with saving query results to different formats, you can transfer or convert data between databases. You also have the choice to load the whole table, or selected columns only.

  Save query/listing results up to 7 different formats:
a. HTML REPORT
b. PDF REPORT
c. Comma Separated Values (CSV), which can be used by many spreadsheet applications (like Excel) directly.
d. Tab Separated Values
e. Values separated by user specified delimiters.
f. XML, either each row in the list is an element with columns as sub-elements or
   each row in the list is an element with columns as attributes.
g. SQL insert statements (to export to other databases).

  This feature, together with Query Builder makes DB Cruiser a simple reporting tool.

  Manipulate CLOB and BLOB easily in just few mouse clicks:
You can view, download, insert, update* (modify) a CLOB (Character Large Object).
You have choice to view either a part of a CLOB quickly, or the whole CLOB, up to the maximum displayable size. The maximum displayable size is configurable through the Administration Tool. There are two ways to update a CLOB: either edit it directly, or via file upload.

You can download, insert, update* (via upload) a BLOB (Binary Large Object).

  Search objects by patterns. You may search or list objects, including tables, views, stored procedures, etc. by patterns. For example, pattern "BOOK%" will list all the objects whose names begin with BOOK, pattern "%BOOK%" will list all the objects whose names contain BOOK, pattern "%BOOK" will list all the objects whose names end with BOOK, pattern %BOOK%TITLE% will list all the objects whose names contain BOOK and TITLE, etc.

  Option to Use Connection Pool.You have choice to use a connection pool to connect to a database. With connection pool, you can run several SQL statements or upload data to several large tables simultaneously. The connection can be configured to use connection pool via DB Cruiser Administration panel (section 12. of the User's Guide)

  Navigting among parent/child table tree graphically. It displays both imported keys (keys from parent tables) and exported keys (keys in child tables), then simply click the imported or exported key, it will bring you to the corresponding parent or child table. Continue doing so, you can explore the whole parent/child table tree by mouse clicking.

  A GUI Query Builder, which let you build complicated queries without or with little typing. Furthermore, the query you built will be showed on the query result page, so you can modify it and do the query again, or save it to a local file for future use.

  Mark and execute SQL statement(s) you want. You may enter several SQL statements in SQL Work Area, then use mouse to select (mark) the statement(s) you want to execute each time.

  Modify data in a query result graphically without writing any SQL statement:** to modify data in a query result, simply double click the data, the corresponding table cell will become editable, modify the data, then click Update button to write the modification to the database.

  Delete rows in a query result graphically without writing any SQL statement:** to delete rows in a query result, simply select (check) rows you want to delete, then click the Delete button to remove those rows from the database permenantly.

  Generate JavaBean (Data Object) for each table: For each table/view, the corresponding JavaBean (Data Object) will be generated, which contains all the get() and set() methods for each column in the table/view, as well as the following two methods:
public void setAttributes(java.sql.ResultSet result);  
public void insertDatabase(java.sql.Connection conn);  

  This will help developers reduce the development time greatly.

  Insert new table rows Graphically without writing any SQL statement

  A GUI Administration Tool allows you to change the setting graphically without editing the configuration file dbcruiser_config.xml directly. The Administration Tool can be accessed from any browsers.
For example, you can turn debug on/off, add, delete and modify the connection list (the list shown on the login panel), etc. via the administration tool.
Best of all, any modification made by the administration tool will be taken into effect immediately, no servlet container restart necessary - a MathThinking technology!

  Flexible Login Methods: You may simply select a database from a predefined list to access it, if a particular database is not on the list, you may still access it by providing the information about that database.

  Display time used in milliseconds for every SQL statement(s) execution:
This includes SQL Work Area, View Selected Columns, and query result by Query Builder

This is a useful feature to help you tune your SQL performance

  Display Database Product Information, Product Specific SQL Keywords, and Product Built-in Functions.

  View Current User Sessions* of the database you are accessing: for users with DBA privilege, a "Current Sessions" selection will appear on the main menu after you login.

 
**For Internet Explorer 5 or later versions only.
* Currently, these features are available for Oracle only.