JETProxy - A Type 3 JDBC Proxy Driver
The JET Proxy JDBC Driver is a type 3 JDBC driver that can be used to serve data from ANY other JDBC driver using RMI. The driver is does NOT currently support CallableStatements (Stored procedures) or the Stream data types on ResultSets.
Support for streams, CallableStatements, and JDBC 2.0 may come in the future if there is any interest. Source is available for download, and it is free for any use.
Architecture
A Type 3 JDBC driver has 2 components. It uses a middleware component that employs some type of pure java interface, and a JDBC driver that communicates with that middleware component.
The power of the JET Proxy server is that it turns any Type 1 or 2 driver (drivers with native pieces) into a network ready Type 3 driver. This could prove useful for accessing NT based ODBC data sources from UNIX/Linux clients.
The figure below shows a high level picture of how the JET Proxy driver works. You can configure the server to work with any existing JDBC driver.
|