Open Source JDBC Proxy Drivers written in Java

• Backpedal - Backpedal is a JDBC driver that can be messaged to roll back all SQL statements issued through it. It is intended to be used in testing scenarios, to allow you return the database to the state it was in before your test case started.
  
  
  
  Development Status: 3 - Alpha
  
  Intended Audience: Developers
  
  License: Apache Software License
  
  Operating System: OS Independent (Written in an interpreted language)
  
  Programming Language: Java
  
  Topic: Database, Software Development
  
  Translations: English
  
  
  
      
• C-JDBC - C-JDBC is a free open source database cluster middleware that 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.
      
• Daffodil Replicator - Daffodil Replicator is a java application that synchronizes databases by transfer and merging of changed data. It allows bi-directional synchronization with heterogeneous enterprise databases supporting JDBC drivers and key features such as -triggers, procedures and auto increment columns. Its flexible publish and subscribe model has been tested with widely used databases such as Oracle, SQL-Sever, PostgreSQL, Derby and Daffodil DB. Daffodil Replicator helps the users by offering following features
      
• HA-JDBC - HA-JDBC is a JDBC driver proxy that provides light-weight, transparent clustering capability to any underlying JDBC driver.
  
  Features
  Supports any database accessible via JDBC.
  High-availability - Database cluster can lose a node without failing transaction.
  Improves performance of concurrent read-access by distributing load across individual nodes.
  Support for full JDBC 3.0 (Java 1.4) feature set.
  Inherently compatible with JSR 114 javax.sql.RowSet API.
  Out-of-the-box database-independent strategies for synchronizing a failed cluster node.
  Exposes JMX management interface to allow administration of database clusters.
  Open source (LGPL).
  
      
• jxdbc - In order to be able to switch JDBC drivers, the application using the JXDBC proxy driver must be unaware that it uses JXTA.
  
  It must be possible to run more than one JXDBC application without having to configure more than one peer on the client side of the proxy.
  
  The server side of the proxy must be able to service more than one database.
  
  This leads to the following architecture.
  
  > <-communication-> <-JXTA-> >
  
  A usual solution for two java applications to communicate is either to use sockets or RMI.
  
  I have chosen RMI.
  
  Why RMI? Since JXDBC is a proxy for JDBC driver
  
      
• LDBC - LDBC (Liberty DataBase Connectivity) is a JDBC driver that provides vendor-independent database access. With LDBC, your application will just work on all major databases and you do not have to change any source code. LDBC is based on ANSI-SQL and JDBC.
  
  LDBC radically simplifies porting of existing or new applications to new databases. The main components of LDBC are a JDBC driver and a SQL grammar converter. LDBC completely shields the application from database vendor specific code. Included SQL grammar and JDBC API documentation.
  
  LDBC is not meant to be a persistence layer or object relation mapping. The main idea of LDBC is providing a standard way to access a SQL database from Java.
  
  
  
      
• Microsoft JDBC Driver Proxy - Tired of the Microsoft JDBC Driver running slowly and failing on Object and NVARCHAR fields? Proxy the Microsoft JDBC driver to run Faster and Better!
  
  
  
  Development Status: 5 - Production/Stable
  
  Intended Audience: Developers
  
  License: Apache Software License
  
  Programming Language: Java
  
  Topic: Database
  
      
• P6Spy - P6Spy is an open source framework for applications that intercept and optionally modify database statements. The P6Spy distribution includes the following modules:
  
  P6Log. 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. 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.
  
      
• PFJDBC - A wrapper over any JDBC driver, it corrects some of the common mistakes the programmers do during the development process and also provides SQL execution timing information. Hints for: cache, AUTOCOMMIT, ISO LEVEL, performance reports for TX,STMTS, etc.
  
  
  
  Development Status: 3 - Alpha
  
  Intended Audience: Developers
  
  License: GNU General Public License (GPL)
  
  Operating System: OS Independent (Written in an interpreted language)
  
  Programming Language: Java
  
  Topic: Database
  
  Translations: English
  
      
• Primrose - Primrose is a mature open source database connection pool; written in Java; for standalone and web-based Java applications.
      
• Proxool - Proxool is a Java connection pool.
  
  Transparently adds connection pooling to your existing JDBC driver. You can monitor the performance of your database connections and listen to connection events.
  
  
  
      
• SSL-SQL-Proxy Server - The Proxyserver is used to make SSL-Secured SQL-request to any database, that has a JDBC-Driver.
  
  The goal was to develop a server, that works as a proxy server, to forward SQL-Queries using SSL. The server was supposed to be mostly platform independent, and after some considerations, Java was the language of choice. The proxy-server accepts SSL-secured connections over TCP/IP, and reads the request using a specified protocol. Then the proxy-server uses a JDBC-Driver to connect to the database and forward the query, getting the result and transfer the result back to the client via SSL.
  
  
  
      
• Virtual JDBC - VJDBC is a vendor-agnostic type 3 JDBC-Driver with which you can remotely access every JDBC-Database in an efficient manner. Due to its command-oriented design different networking protocols can be supported quite easily.
  
  There is a similar open source project called RmiJdbc. The main difference between VJDBC and RmiJdbc is that RmiJdbc exposes the complete interface of the JDBC-Objects via RMI, so every call on an JDBC-Object will go over the network. This can be a major performance killer. VJDBC uses a different approach with command objects and a very thin remote interface.