SPT Relational Database Web Tool 1.3

SPT Relational Database Web Tool is a simple application that can help developers connect to databases.
SPT Relational Database Web Tool 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.

Here are some key features of "SPT Relational Database Web Tool":

Connect to databases configured in application server as DataSources. Configured DataSources are displayed in the application menu.
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.
Display in a Tree the following types of database objects available in the connected database.

The schemas accessible to the user.
The tables available under a schema.
The views available under a schema.
The procedures and functions available under a schema.
The triggers defined in a schema.
The constraints (primary and foreign keys) defined in a schema.

A query exeecution tool launched through a menu (multiple windows are supported). The query tool makes the following features available:

A free text area in which the user enters the query they wish to execute.
An optional text field which can be used to limit the maximum number of matching records fetched from the database.
A "Save" button that can be used to save the current query for easy access via a menu in the future.
The results of the query are displayed in tabular format. The results are pageable for convenience.
The results of the query can be exported to Excel through a "Export to Excel" button.

Requirements:

Echo2 Web Framework 2.1.0.beta5 (optional)

What's New in This Release:

The total number of rows in the table/view is now displayed when viewing table/view details.
Clicking on the number of rows now displays a data viewer component that can be used to walk through all the rows in the table/view.
A user controller limitation on number of characters displayed in the results of the query executor was implemented.
Previously this was hard-coded in the application.

last updated on:
November 23rd, 2007, 12:18 GMT
price:
FREE!
developed by:
Sans Pareil Technologies, Inc.
license type:
The Apache License 2.0 
category:
ROOT \ Internet \ HTTP (WWW)

FREE!

In a hurry? Add it to your Download Basket!

user rating

UNRATED
0.0/5
 

0/5

Add your review!

SUBMIT