Components of the JDBC over HTTP Driver & Framework
The AceQL framework consists of:
- A Client Library with a virtual JDBC Driver.
- A Server Manager that embeds it's own Tomcat 7 web server.
- User Configuration classes injected at runtime.
How the JDBC statements are executed through HTTP from the java desktop application
The virtual JDBC Driver is installed on the client side - typically an Android device or a PC. The client application
- typically an Android, Swing or JavaFX Desktop application -
accesses it through APIs that create a Connection instance.
Each JDBC statement is then sent to the Server Manager for execution on the remote machine.
The execution of each JDBC statement is conditioned by the rules defined in
the Java User Configuration classes. Data are transferred using JSON format.
JDBC over HTTP without firewall configuration
All communications between the PC and the Server simply go through HTTP protocol on the standard 80 and 443 ports. Communications may be secured using SSL/TLS. No firewall configuration is required.