Components of the JDBC over HTTP Driver & Framework

The AceQL framework consists of:

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.