Universal SQL Gateway 0.1.0 Released!

The Universal SQL Gateway allows your client application to cummunicate with a database server over JDBC even if a firewall restricts communication to the HTTP protocol.

It is an alternative for rich client GUI applications to communicate with their server database. Instead of additional server side SOAP or RMI calls create your application with performant JDBC calls and use it in your intranet or single pc. This gives you the the benefit of net traffic reduction (no markup), fast calls (you eliminate unnecessary middleware) and no need of dedicatet web servers. Then, If you need to use your distributed application over a firewall simply apply the Universal SQL Gateway.

The Gateway is universal because it is database/JDBC driver independent. The additional XML interface makes its deployment also possible from non JDBC/Java clients.

The idea for the Universal SQL Gateway emerged from an issue that arose as we developed on a distributed application based on an applet and an Oracle Database communicating over JDBC. Because the Oracle protocol opens ports dynamically it was not possible to open specific ports on the firewall because the administrator would have been forced to open a wide variety of ports instead. We knew that we where not the first ones who met this problem but we didn't like the idea of creating another application specific solution with servlets.

The Universal SQL Gateway gave us the possibility not to change our previously design by simply exchangeing the Oracle JDBC driver through the SQL Gateway driver.

The Release 0.1.0 is a production quality version of the software, Wich includes the Server (A Servlet running on a ServletEngine like Tomcat) and the corresponding JDBC Driver wich supports the most commonly used methods you need to build an Client/Server application.

You'll find more information about issues like architecture, deployment and security on our project homepage.
http://sqlgateway.sourceforge.net

If there is enough public intrest we will continue on the development of this software.