Database Tools

iStatsPackAnalyzer is a web based tool which analyzes STATSPACK files of Oracle; finds bottlenecks and offers information on how to tune them.

itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE and Event 10046 trace files of Oracle; finds bottlenecks and offers information on how to tune them.

The POJO Generator generates POJOs (Plain Old Java Objects) and the methods for inserting, updating, deleting and finding them in, from an RDBMS. It does OR-Mapping by generating code in an easy-to-use way. The user can easily create a POJO following by specifying its member variables, their types, the columns they map to in an RDBMS and the table where they are stored. The user has the possibility to create and manage a collection of connection templates, code which the user already uses for connecting to RDBMS. The user has the possibility to attach such code to a POJO, change the code later, re-generate the POJO and have its database connection layer changed on the fly.

Voruta is a data access framework for embedding SQL statements in Java methods using custom javadoc tags and dynamic code generation

A Java/JSP Servlet based application capable of data extraction and presentation from all standard databases like MS SQL, MySQL, Orcale and HySQL. This tool requires practically no knowledge of SQL and is an excellent tool for high level management and actual database users. Features include: Predefined Queries; Predefined Reports; Graphical Output; Tabular Output; Save Queries and Reports; Pure Java Application; Walk thru Query construction. Specific customization services are available.

Rutil Tag Library helps you in time-consuming work for creation data input forms, reports and all conventional needs of JSP developers - upload and download, mail processing, etc. The current version includes source code, examples and demo Forum project.

OpenReference is a Servlet/JSP based database application to manage your or your group's research references. There is also a public server for those who do not have their own servlet engines. The public server can be customized so that it act like your private one. OpenReference is ideal for academic and business researchers.

Meditux is Java-servlet based software that provides a web interface to MySQL. It was developed to support an intranet site in a medical intensive care unit where it was used to collect clinical and research data. Its primary task is to provide timely medical information to both medical and non-medical staff that operate in an ICU (Intensive Care Unit) environment.

SQLServlet provides an easy way to access your database using HTML-forms. It features: Can keep the connection "alive" between the application and the database, Dynamically generate HTML-tables from the result-set, Create forms for inserts and updates, Replace the values in the querystring by formvariables, Does not require the creation of a new process for each request, Only need to be loaded once, and Runs on any platform that supports the Java Virtual Machine. It requires ODBC Driver or a pure JDBC driver for your database.

ThinSQL is a free applet-servlet utility that connects to an SQL server over the Internet. It's compatible with proxy servers and network firewalls because it uses HTTP as its main method of communication. ThinSQL can be used to add, remove, modify, and retrieve data. Features include: Works with any database accessible via JDBC, Works with any Java Servlet Server, Add, remove, modify, and retrieve data, Freeware (not ThinSQLpro), Thin client (<30k), No plugin, no client installation, No expensive application, No need of a RMI-supported browser, and Encoded data send to the server (Base64). The Web server in use must be servlet enabled; the database that is accessed must be JDBC compatible.

Village is a 100% Pure Java API that sits on top of the JDBC API. The purpose of this API is to make it easier to interact with a JDBC compliant relational database. By using Village, it is possible to execute and manage select/insert/update/delete SQL statements without having to actually write a single line of SQL. Village can use any valid JDBC Connection object, so it is possible to use Village with a JDBC Connection pool.