Elvyx is a tool designed to monitor and profile JDBC activity. This JDBC profiler has a wrapper that intercepts access to the database and sends this information to the elvyx server. The server receives the information, stores the data into a database, and serves this information to the client. The client shows SQL statements, bound SQL statements, elapsed time, elapsed time preparing the statements, and more.
Groovy is an agile, dynamic language for the JVM which combines many features from languages like Python, Ruby, and Smalltalk and makes them available to Java developers using a Java-like syntax. It is designed to help get things done on the Java platform in a quicker, more concise, and fun way. It can be used as an alternative compiler to javac to generate standard Java bytecode to be used by any Java project or it can be used dynamically as an alternative language, such as for scripting Java objects, templating, or writing unit test cases.
Nacho is an application server and rapid Web development platform, ideal for producing business applications, content management systems, interactive content, and custom Web applications. It features a fourth generation template language and database abstraction layer to dynamically produce HTML, XML, JPEG, PNG, CSV, ZIP, and other rich content types.
OjBect Console is a Web application that provides administrative facilities for the Object Relational Bridge (OJB) persistence framework. This console provides transparent browse, search, create, update, and delete functionality for the objects configured within OJB. In addition, it provides administrative functionality such as cache management and a configuration viewer. Finally, it can be extended to build a data management Web application. The general idea is to provide a useful administrative tool to OJB and a solid reference application for OJB/Struts.
QueryForm is a Java GUI application that provides a powerful form-based front end for relational databases. It supports multiple concurrent connections to different databases. Tables can be queried through a simple form-based interface or a custom WHERE-clause editor. Query results can be browsed one row at a time through the the form interface or viewed in a scrollable grid, and can be exported to CSV files or INSERT statements. Table rows can be created, updated, or deleted, and table metadata can be viewed for each table in a database.
This small tool connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns to enable database index creation. Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect database problems efficiently.