The SPT Relational Database Web Tool (RWT) is a simple application that can help developers connect to databases configured as a DataSource in the application server or directly through JDBC. The RWT application attempts to replicate basic features found in the popular Aqua Data Studio application. Per user settings (saved connection parameters, saved queries), single and batch query processing, a history browser, multiple query browsers, a tree view of database metadata, and other features are supported. Please read the manual for full details about the application, including simple use cases, features, installation instructions, etc. You can view screen captures of the application under Downloads. Source code for the application is available in subversion.

Features

The following are the basic features provided by the tool:

1. Connect to databases configured in application server as DataSources. Configured DataSources are displayed in the application menu.
2. Display a Connection dialogue through which users may specify the parameters for directly connecting to a database through JDBC. The connection parameters may be saved in which case the Connection will be added to the application menu of available databases.
3. Display in a Tree the following types of database objects available in the connected database.
   1. The schemas accessible to the user.
   2. The tables available under a schema.
   3. The views available under a schema.
   4. The procedures and functions available under a schema.
   5. The triggers defined in a schema.
   6. The constraints (primary and foreign keys) defined in a schema.
4. A query exeecution tool launched through a menu (multiple windows are supported). The query tool makes the following features available:
   1. A free text area in which the user enters the query they wish to execute.
   2. An optional text field which can be used to limit the maximum number of matching records fetched from the database.
   3. A “Save” button that can be used to save the current query for easy access via a menu in the future.
   4. The results of the query are displayed in tabular format. The results are pageable for convenience.
   5. The results of the query can be exported to Excel through a “Export to Excel” button.

Databases Tested

1. PostgreSQL 8.2
2. Oracle 10.2.0.2.0
3. MySQL 5.0.41
4. Sybase 12.50
5. MS SQL Server 9.00.3077
6. DB2 Express-C - Works only partially. DB2 JDBC driver does not allow scrollable cursors when tables contain LOB/XML types.

PostgreSQL JDBC driver and the JTDS driver for Sybase and MS SQL Server are included with the downloaded package (and in subversion). Other drivers are not included due to licencing restrictions (we could include the Oracle driver, but have no means of controlling downloads from export restricted countries).