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 real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns and can generate SQL index creation files. 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.
jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12). jTDS is based on the work of the FreeTDS project and is currently the fastest complete JDBC driver for SQL Server and Sybase. Starting with release 0.7.1 jTDS is 100% JDBC 2.1 compatible, supporting forward-only and scrollable/updateable ResultSets, multiple concurrent (completely independent) Statements per Connection and implementing all of the DatabaseMetaData and ResultSetMetaData methods. As of version 0.9 most of the JDBC 3.0 features are also implemented. Quite a few of the commercial JDBC drivers out there are based on jTDS (or FreeTDS), even if they no longer acknowledge this. jTDS has been tested with virtually all of the available JDBC-based database management tools and is the driver of choice for most of these (DataDino and Aqua Data Studio even contain it). jTDS is also becoming a common choice for enterprise-level applications: starting with release 0.8-rc1 jTDS passes the Hibernate test suite, making it the driver of choice for SQL Server.
P6Spy is an open source framework for applications that intercept and optionally modify database statements. The P6Spy distribution and optionally modify database statements. The P6Spy distribution includes the following modules: * P6Log intercepts and logs the database statements of any * P6Log intercepts and logs the database statements of any application that uses JDBC. This application is particularly useful for developers to monitor the SQL statements produced by EJB servers, enabling the developer to write code that achieves maximum efficiency on the server. P6Spy is designed to be installed in minutes and requires no code changes. * P6Outage detects long-running statements that may be indicative of a database outage proble and will log any statement that surpasses the configurable time boundary during its execution. P6Outage was designed to minimize any logging performance penalty by logging only long running statements. P6Spy includes installation instructions for JBoss, ATG, Orion, JOnAS, iPlanet, WebLogic, WebSphere, Resin and Tomcat.
C-JDBC is a free open source database cluster middleware that allows any Java application (standalone application, servlet or EJB allows any Java application (standalone application, servlet or EJB container, ...) to transparently access a cluster of databases through JDBC(tm). The database is distributed and replicated among several nodes and C-JDBC balances the queries among these nodes. C-JDBC handles node failures and provides support for checkpointing and hot recovery.
HA-JDBC is a JDBC driver proxy that provides light-weight, transparent, fault tolerant clustering capability to any underlying JDBC transparent, fault tolerant clustering capability to any underlying JDBC driver. Features * Supports any database accessible via JDBC. * Supports any database accessible via JDBC. * High-availability/Fault Tolerance - An HA-JDBC database cluster can lose a node without failing/corrupting the current transaction. * Live activation/deactivation allows for maintenance/upgrading of a database node without loss of service. * Improves performance of concurrent read-access by distributing load across individual nodes. * Support for full JDBC 3.0 (Java 1.4) feature set. * Compatible with JDBC RowSet implementations found in Java 1.5. * Out-of-the-box database-independent strategies for synchronizing a failed cluster node. * Exposes JMX management interface to allow administration of database clusters.
Sequoia is a transparent middleware solution for offering clustering, load balancing and failover services for any database. clustering, load balancing and failover services for any database. Sequoia is the continuation of the C-JDBC project. The database is distributed and replicated among several nodes and Sequoia balances the queries among these nodes. Sequoia handles node failures and provides support for checkpointing and hot recovery.
jxDBCon a framework to ease the development JDBC drivers. By using it you can concentrate on the tasks specific to your DBMS and using it you can concentrate on the tasks specific to your DBMS and benefit from the generic solutions provided by jxDBCon. jxDBCon also contains a featureful driver implementation for PostgreSQL
Elvyx is a tool designed to monitor and profile the jdbc activity. This jdbc profiler has a wrapper that intercept the access to activity. This jdbc profiler has a wrapper that intercept the access to the database and send this information to the elvix server. The server receives the information, store the data into a database and serve this information to the client. The client shows sql statements, bound sql statements, elapsed time, elapsed time preparing the statements, etc